Skip site navigation (1) Skip section navigation (2)

Re: Asunto: Re: Problems restoring a DB with oids

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: juanmime(at)ono(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Asunto: Re: Problems restoring a DB with oids
Date: 2004-06-23 15:50:39
Message-ID: 2983.1088005839@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
juanmime(at)ono(dot)com writes:
> Here is the solution to the problem:
> First: We have to restore (only) the structure (schema) of the database
> pg_restore -Ft -v -s db.tar -d database_name -U postgres -S postgres --disable-triggers
> Second: Restore the datas
> pg_restore -Ft -v -a db.tar -d database_name -U postgres -S postgres --disable-triggers

[ scratches head... ]  Definitely seems that there is a bug in there
somewhere, if you have to do it that way.  I'll take a look later ...

			regards, tom lane

In response to

Responses

pgsql-admin by date

Next:From: Jhonatas M. RodríguezDate: 2004-06-23 16:11:33
Subject: A question about Join?...
Previous:From: Tom LaneDate: 2004-06-23 15:43:05
Subject: Re: Non existent user error on restore

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group