Re: default database selector

On Monday, February 06, 2012 10:31:51 pm Dave Potts wrote:
> I am running Ubuntu 11.04, I have Postgres 8.4 and 9.1 installed.
>
> My default when I say psql it connects to postgres 8.4
>
> ie I set export PGCLUSTER=9.1/main
>
> it connects to 9.1
>
> Q. How can I connect to 9.1 by default without having to set PGCLUSTER?
>
> I looked in /etc/postgresql-common, there did not seem to be anything
> obivious in there for which version to use.

http://man.flashnux.com/en/debian/6/6.0.2/man7/postgresql-common.7.html
From here it would seem there several options beside using PGCLUSTER.
You could set up a user ~/.postgresqlrc file
or
a system wide /etc/postgresql−common/user_clusters where
"
/etc/postgresql−common/user_clusters

stores the default cluster and database for users and groups as set by the
administrators.
"
In either case I am not sure the above will help with you PHP problem. The
cluster option seems to be specific the pg_wrapper program and lives a layer
above that which PHP is using to connect. The PHP issue may solved however by
using a service file:
http://www.postgresql.org/docs/9.0/interactive/libpq-pgservice.html

Basically a way to group connection parameters for a particular server.

The other way would be to specify the connection parameters directly in the
connection string and not using the --cluster option. In your case that would
probably be just a matter of naming different ports for the 8.4 and 9.1 databases
respectively.

>
> Dave.

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com