On 05/11/2017 07:10 PM, John R Pierce wrote:
On 5/11/2017 9:53 AM, Pierre Couderc wrote:
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
was there anything in the postgres database other than the default?
Not at my knowledge...
psql template1 -c "drop database postgres; create database postgres
with template template0"
should restore it to a virgin stock empty 'postgres'
Thank you, I do that. This is what I looked for !
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
