restored over postgres database - Mailing list pgsql-general

From Kevin Duffy
Subject restored over postgres database
Date
Msg-id DFC309C8A42633419600522FA8C4AE1A561153@mail-01.wrcapital.corp
Whole thread Raw
Responses Re: restored over postgres database  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-general

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?

b)       How can I restore the postgres database to a pristine state?

 

 

 

Regarding restoring postgres databse to a pristine state I attempted to restore, from within PGAdmin,  the

postgres for a different server but that did not work. 

 

Attempted to do a DROP DATABASE from within psql, but that did not work either.  The database did not drop and no error message was produced.

Strange.

 

Any suggestions.

 

Thanks in advance for your kind assistance.

 

 

Kevin Duffy

 

pgsql-general by date:

Previous
From: "Josh Harrison"
Date:
Subject: Limit on number of databases in a Cluster ?
Next
From: "Scott Marlowe"
Date:
Subject: Re: restored over postgres database