PokerTracker

I have been following the back up guide for backing up a PostgreSQL database as I want to format my computer. On the step by step guide, this step shows only one database sub group in the pgadmin window, whereas my pgadmin window shows several (a screenshot is here. I'm just wondering which database I should be backing up, and why my window shows more entries than what is shown in the guide?

Thanks

It looks like you just added a second connection to your local server. Both copies of "PT3 DB" should be identical (since the connection is to the same computer on the same port), and it's that one you want to back up (but it doesn't matter which you pick).

kraada wrote:It looks like you just added a second connection to your local server. Both copies of "PT3 DB" should be identical (since the connection is to the same computer on the same port), and it's that one you want to back up (but it doesn't matter which you pick).

Thanks, that's right both files are equal in size. (23mb)

cheers

I have recently leanred that pgAdmin will remember all your postgres installations. i think it saves them in the registry or somtehing. I have installed and uninstalled pg 8.2, 8.3.4, 8.3.7 and pgAdmin still shows all of them. But as kraada says, since they all read localhost:5432, it will only connect to the one you have installed, so all should report the same dbs

With regard to the multiple server connections, will this slow down the computer's usage or postgres' overall performance? Is it ok to delete one of them, or could this cause problems?

As long as you only have one version of the postgres service running then it shouldn't affect performance.
If you don't have any old databases you haven't backed up then it should be fine to uninstall, though. (if you created a database in 8.2 you won't be able to use it directly in 8.3, you'd need to backup in 8.2 before uninstalling 8.2 and restore in 8.3.)