How do I change the maintenance database for Postgres?

database postgresql maintenance pgadmin
gsiener picture gsiener · Apr 17, 2011 · Viewed 15.8k times · Source

I'm running PostgreSQL version 9.0 on OSX version 10.6.6. Somehow one of my development databases has become the maintenance db, not postgres (this db also exists). I can't find any documentation on how to change/set the maintenance db back to postgres.

I can't drop my development database because of this issue...

Answer

Răzvan Flavius Panda picture Răzvan Flavius Panda · Apr 6, 2013

You can change maintenance db from pgAdmin but you have to be disconnected from the database engine to be able to do that.

First disconnect:

Then in the database server properties:

Choose the desired maintenance database:

Related questions

How to select the nth row in a SQL database table?

I'm interested in learning some (ideally) database agnostic ways of selecting the nth row from a database table. It would also be interesting to see how this can be achieved using the native functionality of the following databases: SQL Server …

Read More
What is this Javascript "require"?

I'm trying to get Javascript to read/write to a PostgreSQL database. I found this project on github. I was able to get the following sample code to run in node. var pg = require('pg'); //native libpq bindings = `var pg = …

Read More
Import SQL dump into PostgreSQL database

We are switching hosts and the old one provided a SQL dump of the PostgreSQL database of our site. Now, I'm trying to set this up on a local WAMP server to test this. The only problem is that I …

Read More