how to restore only one db from a pg_dumpall type dump

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



This is a multi-part message in MIME format...

------------=_1115409263-27750-10
Content-type: text/plain; charset=US-ASCII
Content-Disposition: inline

My first challange with restoring from dumps across different versions...


in pgsql 7.4.2:
 I use pg_dumpall > $BACK_DIR/pgdumpall_test$TSTAMP.dmp.
 I than copy the dump file over to another machine with pgsql 7.2.2.
 I want to pg_restore just one database (i.e. wxsdb)  without having to
manually clear data and tables, also ignore the original owner of tables.

Is it possible with opne pg_restore (pgsql 7.2.2)?
What are the 'default' values for pg_dumpall on pgsql 7.4.2 that i may have
missed?
What pg_restore flags to use on pg_restore ?

I tried this: pg_restore -O -i  -c -d wxsdb --format=c  (for some reason
format=p does not exist)...
...getting constrints violations
...or users doesnt exist
...I tried to manually delete all tables, but than there are many 'types'
and 'sequences'  that wont go away...

Any hints and tips will b eappreciated.

eg






Edan Gavish
Oracle DBA
WWIT
Ogilvy & Mather Worldwide, New York
Office: +1 212 237 5759
Fax: +1 212 237 4060
E-mail: edan.gavish@xxxxxxxxxx





Privileged/Confidential Information may be contained in this message.  If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. Please advise immediately if you or your employer does not consent to email or messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of the Ogilvy Group shall be understood as neither given nor endorsed by it.

------------=_1115409263-27750-10--


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux