| From: | "Albe Laurenz" <all(at)adv(dot)magwien(dot)gv(dot)at> |
|---|---|
| To: | "Reece Hart *EXTERN*" <reece(at)harts(dot)net>, "pgsql-general" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: database name aliases? |
| Date: | 2006-11-07 07:54:23 |
| Message-ID: | 52EF20B2E3209443BC37736D00C3C1380B4AADD2@EXADV1.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2006-11-07 08:22:39 | Re: R and postgres |
| Previous Message | Gurjeet Singh | 2006-11-07 07:37:48 | Re: Cannot rename file pg_xlog\0000..... |