Possible to have multiple DB Aliases?

[michael_team]

We use two different iterations of PostgreSQL DB 9.3 on two different machines. I can create a DB Alias OK using sdbc : DSN=PostgreSQL35W, but if I want to access the other database, I have to re-configure this alias with credentials for the other DB. This results in lots of back and forth, and it's actually hard to tell exactly which DB we're currently accessing. If I create a new Alias, it just overwrites the other.

Is it possible to have more than one Alias for Postgres?

Thanks

[dataMack · Accepted solution]

You can alias each odbc DSN once, so simply create a second odbc connection for your other machine and alias that.  This could also work for different database instances on the same machine.

[michael_team]

Your post was very helpful, turns out I was creating a new ODBC connection, but did not rename it, so it just kept overwriting the same one. 

Thanks!