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

Asunto: Re: Problems restoring a DB with oids

From: juanmime(at)ono(dot)com
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Asunto: Re: Problems restoring a DB with oids
Date: 2004-06-23 11:43:25
Message-ID: 40D794F2000011E9@mta02.ono.com (view raw or flat)
Thread:
Lists: pgsql-admin
Thanks you very much Tom,

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

I think, that in the first step, we can drop "-S postgres --disable-triggers"
options.

Thanks.


In response to

Responses

pgsql-admin by date

Next:From: V i s h a l Kashyap @ [Sai Hertz And Control Systems]Date: 2004-06-23 13:27:57
Subject: Re: Backup / Restore
Previous:From: Eduardo S. FontanettiDate: 2004-06-23 11:40:34
Subject: Backup / Restore

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