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@ogilvy.com
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.
Insuch case, you should destroy this message and kindly notify the sender by reply email. Please advise immediately if
youor your employer does not consent to email or messages of this kind. Opinions, conclusions and other information in
thismessage that do not relate to the official business of the Ogilvy Group shall be understood as neither given nor
endorsedby it.
------------=_1115409263-27750-10--