Re: DB alias ?

On Thu, 2013-01-24 at 09:01 +0530, Shridhar Daithankar wrote:
> On Wednesday, January 23, 2013 09:39:43 PM Gauthier, Dave wrote:
> > Then someone who wants to look at old JAN data will have the same problem
> > :-(
> >
> > If I recall, Oracle enables something like this. Multiple tnsfilenames (or
> > something like that). There was a connect layer on the server side that
> > the DBA had access to where you could do stuff like this.
> > >> proposed new SQL command:
> > >>READ USERS MIND;
> > :
> > :-)
> >
> > Actually, read the DBA's mind.
> >
> > How about...
> >
> > postgres=# create db_alias FEB to db JAN;
> > postgres=# drop db_alias FEB;
>
> I would have suggested to use pg_services file as documented at
>
> http://www.postgresql.org/docs/9.1/static/libpq-pgservice.html
> http://www.postgresql.org/docs/9.1/static/libpq-connect.html
>
> You can think of this as tnsnames replacement.
>
> but I am unable to make it work. I don't know what is wrong with this.
>
> shridhar(at)bheem ~$ cat ~/.pg_service.conf
> [test1]
> host=localhost
> dbname=test
>
> shridhar(at)bheem ~$ strace -o psql.strace psql test1
> psql: FATAL: database "test1" does not exist
>

Well, you need to tell psql to use a service:

psql service=test1

or

PGSERVICE=test1
psql

--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com