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 !