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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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