Re: Problem pg_restore from 7.3 to 7.4

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