Creating a clean database - Mailing list pgsql-novice

From Keith Worthington
Subject Creating a clean database
Date
Msg-id 41D9FBE4.8020805@NarrowPathInc.com
Whole thread Raw
Responses Re: Creating a clean database  (Michael Fuhr <mike@fuhr.org>)
List pgsql-novice
Hi All,

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.

--
Kind Regards,
Keith


pgsql-novice by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: checksumming data
Next
From: Michael Fuhr
Date:
Subject: Re: Creating a clean database