On Wed, Dec 3, 2008 at 9:38 AM, Kevin Duffy <KD@xxxxxxxxxxxxxxxxx> wrote: > Hello: > > > > On a newly installed PostgreSQL server I made the mistake of restoring over > the postgres database. > > Which I made me feel very silly and brought up a couple of questions. > > > > a) What is the postgres database used for? By default, nothing usually. Whatever you're using it for is usually it. > b) How can I restore the postgres database to a pristine state? shut down postgres delete everything in the $PGDATA directory (or whatever comes after -D when it starts up) run initdb start postgres All should now be clean and fresh. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
