how to restore database 'postgres' from postgresql

Question

I am using local postgresql and pgadmin 4. I dropped database 'postgres' and now pgadmin won't open. How can I restore 'postgres' or fix this issue?

Does this answer your question? How to recover or recreate orginal Postgres database after dropping it? — Dušan Maďar
– Dušan Maďar, Commented Oct 1, 2021 at 16:39

Laurenz Albe · Accepted Answer · 2021-10-01 17:00:07Z

2

You have to change the definition of the "server" in pgAdmin and set the "maintenance database" to something else than postgres, for example template1.

Then you will be able to connect, and you can create the database postgres again.

answered Oct 1, 2021 at 17:00

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

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

1 Comment

Zuckerbrenner Over a year ago

Thanks! This was helpful.

Collectives™ on Stack Overflow

how to restore database 'postgres' from postgresql

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related