Re: [GENERAL] How to recover my postgres database ? - Mailing list pgsql-general

From Tom Lane
Subject Re: [GENERAL] How to recover my postgres database ?
Date
Msg-id 19330.1494525141@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] How to recover my postgres database ?  (Pierre Couderc <pierre@couderc.eu>)
List pgsql-general
Pierre Couderc <pierre@couderc.eu> writes:
> Mmm, there is some misunderstanding. I have lost nothing.
> All my DBs are ok.
> I am speaking of the specific "postgres" database that you connect to with
> \c postgres
> What is its use ? how to restore it ?

If you know that there should be nothing non-default in the postgres
database, it should be fine to just drop it and recreate it.  It's
not magic, it's just a default landing point for connections.

If there is stuff you keep there, probably restoring that stuff
from your last backup is the best you're going to be able to do.

            regards, tom lane


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Top posting....
Next
From:
Date:
Subject: [GENERAL] Constraints of view attributes