Re: PostgreSQL 7.2 - 8.0 replication issue

Hi, I write an litle procedure about migration from postgres 7x to 8x. this is the link: http://fastonion.blogspot.com/2005/04/gentoo-migrando-postgres-7x-8.html In Resume you must be do: On current DB Server: su - postgres pg_dumpall > /tmp/db.out On remote DB Server: copy db.out to new location on new server su - postgres psql -f db.out template1 Good Luck! Regards, Luis Morales On Mon, 2005-06-27 at 15:46 -0300, Martín Marqués wrote: > El Lun 27 Jun 2005 15:31, Mark Galbreath escribió: > > I have to upgrade a web app from PHP 4.3.11 with PostgreSQL 7.2 to PHP 5.0.4 > with PostgreSQL 8.0.3. > > > > Currently I have PHP4 (as Apache 2.54 mod on port 80) and PHP5 (default CGI > mode on port 8181) running concurrently on my DEV box. I installed > PostgreSQL 8.0.3 on the DEV box as well. > > > > On the PostgreSQL 7.2 server, I did a pg_dumpall > db.out and ftp'd db.out > to the PostgreSQL 8.0.3 (DEV) server. When I attempt to pg_restore db.out, > the PostgreSQL archiver aborts with the error: "input file does not appear to > be a valid archive" > > Never used pg_restore. I just do this: > > $ psql -f db.out > > Always worked for me. > > -- > select 'mmarques' || '@' || 'unl.edu.ar' AS email; > --------------------------------------------------------- > Martín Marqués | Programador, DBA > Centro de Telemática | Administrador > Universidad Nacional > del Litoral > --------------------------------------------------------- >