Reece Hart wrote:
> I'd like to be able to have several versions of a database
> available concurrently and one database alias that refers to
> the most recent of these. For example:
>
> dbname_1-1
> dbname_1-2
> dbname_1-3
> dbname -> dbname_1-3
>
> and
> $ psql -d dbname
> would connect to dbname_1-3.
>
> Any ideas?
In 8.2 (currently beta) you can store connection data and
database name on an LDAP server and refer to it via a service name.
See http://developer.postgresql.org/pgdocs/postgres/libpq-ldap.html
You can use the service name to connect:
env PGSERVICE=dbname psql
This will work with all client interfaces that use libpq to connect.
Yours,
Laurenz Albe