Re: Problem pg_restore from 7.3 to 7.4
От | mike g |
---|---|
Тема | Re: Problem pg_restore from 7.3 to 7.4 |
Дата | |
Msg-id | 1089431547.10763.26.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Problem pg_restore from 7.3 to 7.4 (Plant Thomas <tomspost_NOSPAM_@dnet.it>) |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: