> 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 the user 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
