Re: [GENERAL] Restore 8.1.4 backup in 8.2.5

2007-09-21 Thread MargaretGillon
>"Andrew J. Kopciuch" <[EMAIL PROTECTED]> wrote on 09/19/2007 08:31:08 PM: > Or just run the dump through psql. > psql -U postgres -d template1 -f /tmp/$(date +%F)owl.sql Thank you this worked. *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** Margaret Gillon, IS De

Re: [GENERAL] Restore 8.1.4 backup in 8.2.5

2007-09-19 Thread Hiroshi Saito
Hi. pgAdminIII uses pg_restore by restoration. Then, pg_restore does not recognize a PlainText format. Please use psql from a command line... Regards, Hiroshi Saito - Original Message - From: [EMAIL PROTECTED] I have a backup file from Postgresql 8.1.4. When I try to use 8.2.5 pg_

[GENERAL] Restore 8.1.4 backup in 8.2.5

2007-09-19 Thread MargaretGillon
I have a backup file from Postgresql 8.1.4. When I try to use 8.2.5 pg_restore the restore doesn't recognize the archive format. The archive file was made with the command below. Is there a way to get 8.2.5 to recognize the file, or a way to run the file as a script from a different program lik