PGAdmin server(s) related question
Posted: Sat May 31, 2008 11:34 pmWhen I open PGAdmin3 I have two different servers listed. They both appear to be identical with these two exceptions. One server has "Restore Environment?" checked yes and the other no. The second difference is one server has "postgres" listed as the maintenance db, the other "template1".
The help file says the following:
The maintenance DB field is used to specify the initial database that pgAdmin connects to, and that will be expected to have the pgAgent schema and adminpack objects installed (both optional). On PostgreSQL 8.1 and above, the maintenance DB is normally called 'postgres', and on earlier versions 'template1' is often used, though it is preferrable to create a 'postgres' database for this purpose to avoid cluttering the template database.
The "Restore env?" option determines whether or not pgAdmin will attempt to restore the browser environment when you reconnect to this server. If you regularly use different databases on the same server you might want to turn this option off.
Since originally installing postgresql with PT2, I have only run into two problems using it.
1) I absolutely cannot upgrade one version to the next without doing a complete uninstall/reinstall. Every time I try to run upgrade.bat it tells me I need to have administrative privileges (which I do and I even tried upgrading through the Administrator account on XP with no success.) Perhaps this is why I have two servers listed in PGAdmin?
2) I used to have a lot of problems with psql not connecting when I would first boot up my computer. All I had to do was start the service but it was annoying. That problem seems to have largely disappeared. Is that because of the "restore environment" setting?
I'm getting ready to upgrade to the most recent version of psql as I'm still using 8.2.x so I'm trying to clean things up as much as possible. Will performance improve if I drop one of these servers? If another server is installed following the upgrade, is it ok to drop these ones?
The help file says the following:
The maintenance DB field is used to specify the initial database that pgAdmin connects to, and that will be expected to have the pgAgent schema and adminpack objects installed (both optional). On PostgreSQL 8.1 and above, the maintenance DB is normally called 'postgres', and on earlier versions 'template1' is often used, though it is preferrable to create a 'postgres' database for this purpose to avoid cluttering the template database.
The "Restore env?" option determines whether or not pgAdmin will attempt to restore the browser environment when you reconnect to this server. If you regularly use different databases on the same server you might want to turn this option off.
Since originally installing postgresql with PT2, I have only run into two problems using it.
1) I absolutely cannot upgrade one version to the next without doing a complete uninstall/reinstall. Every time I try to run upgrade.bat it tells me I need to have administrative privileges (which I do and I even tried upgrading through the Administrator account on XP with no success.) Perhaps this is why I have two servers listed in PGAdmin?
2) I used to have a lot of problems with psql not connecting when I would first boot up my computer. All I had to do was start the service but it was annoying. That problem seems to have largely disappeared. Is that because of the "restore environment" setting?
I'm getting ready to upgrade to the most recent version of psql as I'm still using 8.2.x so I'm trying to clean things up as much as possible. Will performance improve if I drop one of these servers? If another server is installed following the upgrade, is it ok to drop these ones?
