470,815 Members | 1,284 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,815 developers. It's quick & easy.

Problem pg_restore from 7.3 to 7.4

Hi,
I have a problem restoring a database from Postgresql 7.3 ( backup
created with 'pg_dump -Ft -b > test.tar' ) to a new database on
PostgreSQL 7.4.3 on Cygwin. I get the following error:

pg_restore: executing SEQUENCE SET t_tab_kurs_template_id_seq
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"t_tab_kur
s_template_id_seq" does not exist
pg_restore: *** aborted because of error

it seems that the sequence has not been created during the restore
process and now it tries to set its start value. Is this a bug within
pg_restore?

Thanks for any advice how to compelete this restore.

Greetings,
Thomas

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #1
1 1723
Can you re-execute pg_dump but not output it as a tar format? Then
restore using psql. The tar format does allow one to be selective in
how a database is restored while standard pg_dump does not.

Is the tar file greater than the 8 GB file limit?

That is the limit of my knowledge....

Mike
On Fri, 2004-07-09 at 02:49, Plant Thomas wrote:
Hi,
I have a problem restoring a database from Postgresql 7.3 ( backup
created with 'pg_dump -Ft -b > test.tar' ) to a new database on
PostgreSQL 7.4.3 on Cygwin. I get the following error:

pg_restore: executing SEQUENCE SET t_tab_kurs_template_id_seq
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"t_tab_kur
s_template_id_seq" does not exist
pg_restore: *** aborted because of error

it seems that the sequence has not been created during the restore
process and now it tries to set its start value. Is this a bug within
pg_restore?

Thanks for any advice how to compelete this restore.

Greetings,
Thomas

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Sam | last post: by
reply views Thread by andy morrow | last post: by
14 posts views Thread by Ron Johnson | last post: by
6 posts views Thread by Mike Charnoky | last post: by
1 post views Thread by Roopali Sharma | last post: by
reply views Thread by Stefano Bonnin | last post: by
7 posts views Thread by Tim Penhey | last post: by
1 post views Thread by ruben | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.