Dropped the default postgres database in Postgresql server

Question

I did not know what the database did and I deleted it without realizing that now I wouldn't be able to run psql again. How do I get thngs back to normal again?

user330315 · Accepted Answer · 2021-02-09 14:53:49Z

3

The postgres database isn't really needed.

But you can re-create it using:

psql -U postgres -d template1
psql (13.1)

postgres=# create database postgres;

The -d template1 tells psql to connect to the template1 database.

answered Feb 9, 2021 at 14:53

user330315

Sign up to request clarification or add additional context in comments.

1 Comment

molereddy Over a year ago

that worked, thanks! I was afraid that postgres was the only way in..

Collectives™ on Stack Overflow

Dropped the default postgres database in Postgresql server

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related