> We have test database created in the initdb cluster, but on the Add Server page of
> pgAdmin3, the Maintenance DB dropdown box does not show this database. How can we
> make it to display this db in the dropdown box too?
You can't without hacking the code. Those databases are just helpful defaults.
> As the Maintenance DB dropdown box doesn't show this test db, we have to allow the
> owner of this test db (a new user created for this test db only) to access 'all'
> database in the pg_hba.conf file in order to allow it to login through pgAdmin. And
> once loged in, it of course has access to all databases including the postgres. How
> can we control this situation through pgAdmin?
No, you don't have to allow access to all databases. You can type the name of the preferred maintenance DB, or grant
theuser access to 'postgres' as well as any other databases they need. 'postgres' is intended for this sort of use...
Regards, Dave
-----Unmodified Original Message-----
Hi All,
Have a question on pgAdmin3:
We have test database created in the initdb cluster, but on the Add Server page of
pgAdmin3, the Maintenance DB dropdown box does not show this database. How can we
make it to display this db in the dropdown box too?
As the Maintenance DB dropdown box doesn't show this test db, we have to allow the
owner of this test db (a new user created for this test db only) to access 'all'
database in the pg_hba.conf file in order to allow it to login through pgAdmin. And
once loged in, it of course has access to all databases including the postgres. How
can we control this situation through pgAdmin?
Any help would be greatly appreciated.
Thanks,
leo
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match