Patrick Roberts wrote:
Hi All,
On a newly created server I stupidly restored over the top of the
postgres system database using the GUI...(postgresql n00b) and am
wondering a couple of things.
Firstly, if this database is overwritten, is it detrimental to the
running of PostgreSQL?
The "postgres" database is basically an empty holder so that when you do
this:
psql
as the user postgres, you actually get into the system.
Secondly is it just a simple matter of restoring it using a backup
from a different PostgreSQL instance installed elsewhere.
If you are indeed speaking about the "postgres" database yes.
Sincerely,
Joshua D. Drake
