On Mon, Jan 03, 2005 at 09:13:56PM -0500, Keith Worthington wrote:

> I have finished a testing phase and I would like to create a production
> database. My thought is to use pg_dump to create a backup of the data
> dictionary, create a new database using pgadminIII or psql and then use
> something (pg_restore or psql or ?) to rebuild all of the database
> objects. I am hoping that a technique is available that will allow me
> to get all new oids and reset all sequences. Suggestions will be
> appreciated.

Have you looked at the documentation for pg_dump, in particular
the --schema-only and --data-only options? If those won't work
then please be more specific about what you're trying to do.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html