Hello Stephen
I am actually working on a concept for this problems: Many clusters with
different versions on a server:
It consists off 3 docs and some skripts:
* Optimal Flexible Architecture (OFA) for PostgreSQL
* Flexible Environment for PostgreSQL in a Multi-Cluster-Multi-Database
(MCMD) syste
Bang on Tom.
As you can see from the snippet of my mail below, I had it pg_port.
Oh well, make distclean again I suppose
Thanks.
Tom Lane wrote:
"skennedy" <[EMAIL PROTECTED]> writes:
If I configured the server to user 5433 before building (using
--with-pg_port=5433 in configure) shouldn't
"skennedy" <[EMAIL PROTECTED]> writes:
> If I configured the server to user 5433 before building (using
> --with-pg_port=5433 in configure) shouldn't the clients, etc
> automatically look for port 5433?
They should, and they do for me (I routinely run several different
versions of PG on different
Thanks Tom,
PGPORT was unset in the environment.
I set it to 5433 and things started to work.
If I configured the server to user 5433 before building (using
--with-pg_port=5433 in configure) shouldn't the clients, etc
automatically look for port 5433?
The executables ARE the ones I compiled
"skennedy" <[EMAIL PROTECTED]> writes:
> however, when I try and create a user I get
> bash-2.03$ createuser idip_734
> Shall the new user be allowed to create databases? (y/n) y
> Shall the new user be allowed to create more new users? (y/n) n
> psql: FATAL 1: user "p_sql734" does not exist
Loo
Hi..
I have a Solaris 2.8 machine on which I have Postgresql 7.2.4 postgres
listening on port 5432. This works fine.
I have a user who needs a newer version and has asked specifically for
7.3. I have compiled and installed a 7.3.4
successfully, using
./configure --prefix=/usr/local/p_sql734 -
