How to recover my postgres database ?

From: Pierre Couderc <pierre(at)couderc(dot)eu>
To: pgsql-general(at)postgresql(dot)org
Subject: How to recover my postgres database ?
Date: 2017-05-11 16:53:23
Message-ID: 0dcc455b-c41a-9416-f546-897b3860d031@couderc.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have broken my postgres database by typing :

psql <yyyy

instead of :

psql dbdb <yyyy

How can I safely repair, knowing that I have the pg_dumpall of last
night, but many dbs have changed today... ?

Thanks in advance

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Francois Bernier 2017-05-11 17:03:55 Re: Querying a policy
Previous Message Vibhor Kumar 2017-05-11 14:49:28 Re: Installing repmgr alongside PostgreSQL installed via EnterpriseDB installer instead of repositories?