I was experimenting with creating a copy of an existing database from a pg_dump sql backup file. I made an misake in failing to delimit an environment variable and in consequence I issued this command as user postgres:
Which caused the postgres database to be overwritten with hll_redmine.pgsql.gz. Is there an easy way to get this back or do I have to reinitialise the whole thing?
Well, you can connect to some database (but not postgres), drop the postgres one, and create it again.