patternsqlMajor
What is the Maintenance DB asked by pgAdmin?
Viewed 0 times
pgadminthewhataskedmaintenance
Problem
pgAdmin dialog for adding new database connections asks for a "Maintenance DB".
In order to be able to connect, I set it to the database I want to connect (and also, I have the rights to connect).
So, why is it named "Maintenance DB" instead of "DB" or "Database"?.
In order to be able to connect, I set it to the database I want to connect (and also, I have the rights to connect).
So, why is it named "Maintenance DB" instead of "DB" or "Database"?.
Solution
It is worth mentioning that you are free to define any existing database in the cluster as "Maintenance DB". You are not limited to the options suggested by the interface, which are just typical defaults.
This is particularly useful for users with limited permissions or read-only access. Access to a single DB is simpler with the same DB as "Maintenance DB". Related:
What is the maintenance db? The manual:
The
initialized. This database is meant as a default database for users
and applications to connect to. It is simply a copy of
can be dropped and recreated if necessary.
This is particularly useful for users with limited permissions or read-only access. Access to a single DB is simpler with the same DB as "Maintenance DB". Related:
- Do all users need access to the postgres database in pg_hba.conf?
What is the maintenance db? The manual:
The
postgres database is also created when a database cluster isinitialized. This database is meant as a default database for users
and applications to connect to. It is simply a copy of
template1 andcan be dropped and recreated if necessary.
Context
StackExchange Database Administrators Q#68077, answer score: 26
Revisions (0)
No revisions yet.