Re: Asunto: Re: Problems restoring a DB with oids - Mailing list pgsql-admin

From Tom Lane
Subject Re: Asunto: Re: Problems restoring a DB with oids
Date
Msg-id 2983.1088005839@sss.pgh.pa.us
Whole thread Raw
In response to Asunto: Re: Problems restoring a DB with oids  (juanmime@ono.com)
Responses Re: Asunto: Re: Problems restoring a DB with oids
List pgsql-admin
juanmime@ono.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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Non existent user error on restore
Next
From: "Jhonatas M. Rodríguez"
Date:
Subject: A question about Join?...