

> -----Original Message-----
> From: PJourdan [mailto:info@lespetitsplaisirs.com] 
> Sent: 11 April 2002 17:24
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] migration problem
> 
> 
> I know this is not strictly a pgadmin issue, but I don't know 
> where else to 
> turn.
> At worst, perhaps someone can steer me in the right 
> direction. :)) Dave seems terribly knowlegable on pgsql, so I 
> thought I'd risk the question: 

Thanks for the vote of confidence, but this is not really within my field of
knowledge. I've CC'd this to pgsql-hackers@postgresql.org - you are more
likely to get good help from there.

Regards, Dave.

> I am trying to restore a 
> database from a gzipped file: I believe that 
> backups were done as complete files (not partial) under 
> Postgresql 7.0.3. 
> Pg_restore does not recognize the ungzipped file "filename.psql". The 
> command, psql -d database -f filename.psql, restores it 
> partially, but with 
> numerous errors and the database is mostly empty. As I 
> understand, this 
> command restores the file to an existing database, so I had 
> to create one 
> with the original filename. But I don't know if the newly 
> created database 
> must have the exact same permissions, ownership, etc. as the 
> original. I am told to install the earlier version of 
> Postgresql to restore, but that 
> does not work - cannot configure it. Even if that works, how can the 
> restored database be migrated to a newer version of 
> Postgresql? Does anybody out there know about this kind of 
> thing? Thanks for any help. P. Jourdan
> 
> 
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to 
> majordomo@postgresql.org
> 

Thu, 11 Apr 2002 20:29:55 +0100
Dave Page <dpage@vale-housing.co.uk>
Re: migration problem