Обсуждение: Restore 8.1.4 backup in 8.2.5

Поиск
Список
Период
Сортировка

Restore 8.1.4 backup in 8.2.5

От
MargaretGillon@chromalloy.com
Дата:

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 like PG_ADMIN III? As far as I can see the archive is text. My postgresql 8.1.4 installation is no longer working.

su --command="/usr/local/pgsql/bin/pg_dump -p 55432 -U postgres -C -D -f /tmp/$(date +%F)owl.sql owl"

*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297

This e-mail message and any attachment(s) are for the sole use of the intended recipient(s) and may contain proprietary and/or confidential information which may be privileged or otherwise protected from disclosure.  Any unauthorized review, use, disclosure or distribution is prohibited.  If you are not the intended recipient(s), please contact the sender by reply email and destroy the original message and any copies of the message as well as any attachment(s) to the original message.

Re: Restore 8.1.4 backup in 8.2.5

От
"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: MargaretGillon@chromalloy.com

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 like PG_ADMIN III? As far as I can see the archive is text. My postgresql
8.1.4 installation is no longer working.

su --command="/usr/local/pgsql/bin/pg_dump -p 55432 -U postgres -C -D -f /tmp/$(date
+%F)owl.sql owl"

*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297

This e-mail message and any attachment(s) are for the sole use of the intended recipient(s)
and may contain proprietary and/or confidential information which may be privileged or
otherwise protected from disclosure.  Any unauthorized review, use, disclosure or
distribution is prohibited.  If you are not the intended recipient(s), please contact the
sender by reply email and destroy the original message and any copies of the message as well
as any attachment(s) to the original message.


Re: Restore 8.1.4 backup in 8.2.5

От
MargaretGillon@chromalloy.com
Дата:

>"Andrew J. Kopciuch" <akopciuch@bddf.ca> 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 Dept., Chromalloy Los Angeles, ext. 297