On Wed, Dec 3, 2008 at 9:38 AM, Kevin Duffy <KD(at)wrinvestments(dot)com> 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.