I'm using 7.4.19 utils on Centos 5 to move a database from one shared
hosting server to another shared hosting server.
The dump and restore options that I used are:-
pg_dump -O -v -F c
pg_restore -c -O -x -v
pg_restore aborts the restore (with a return code=1) when trying to
'comment schema "public"', which is because the schema is not owned by
the database owner.
1. How do I get pg_restore to simply ignore this error and continue
the restore to completion?
2. Is it ok to have the schema "public" owned by the owner of the database?
3. How do I tell if the restore is complete as a cursory look seems to
indicate the restore is complete?
Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
m: 0415 469 095
www.flashdev.org.au
Sydney Flash Platform Developers Group
April meeting: TBD
Date: Mon 28th April 6pm for 6:30 start
Details soon