|
From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx]
On Behalf Of Shridhar Daithankar 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@bheem ~$ cat ~/.pg_service.conf
[test1] host=localhost dbname=test
shridhar@bheem ~$ strace -o psql.strace psql test1 psql: FATAL: database "test1" does not exist
shridhar@bheem ~$ grep -i pg_service psql.strace
shridhar@bheem ~$ psql test psql (9.2.2) Type "help" for help.
test=# \q
shridhar@bheem ~$ psql --version psql (PostgreSQL) 9.2.2
--
Regards Shridhar --------------------------------------------------------------------------------------------- The services file looked/looks interesting, but there are far too many clients, and at multiple sites, to manage this. I really need
something on the server side, a single place to manage this for all connections regardless of where they are coming from. It also looks like a C lib based file, something I won't have access to except, maybe, through an app designed for DBAs to edit this
file. If I am mistaken, and the services file is in the DB root area (the area specified after the "-D" in commands like pg_ctl), then maybe this is still viable. But I don't see a services file there :-( |
