I have found my error thanks to a tip from dima. The start of the init.d
script did a silly rm -f
/tmp/.s.PGSQL.* and i only want it to remove the lock for that instance.
Thanks
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Ray Madigan
Sent: Friday, September 06, 2002 10:07 AM
To: Pgsql-Admin
Subject: [ADMIN] Multiple Postmasters
I am attempting to create a database server with multiple harddrives where
each hard drive has an instance of postmaster managing the database cluster
on that drive. Currently i am trying to get this scenario to work with two
instances, and after i get confidence that it will work i will do it for
more.
My environment is Linux 7.1 with PostgreSql 7.0.3
The database superuser is postgres and i create two environment variables
for that user
PGA=/bar/data
PGB=/foo/data
export PGA PGB
I create the data directory in each area and initdb each of the areas.
I copied /etc/rc.d/init.d/postgresql to postgrea and postgreb and changed
all references of
PGDATA to PGA and PGB respectively. Also changes the hard paths to point to
the correct place.
I modified postmaster.opts.default to include options for a different port
for each instance of postmaster in the appropriate data areas.
I linked startup and shutdown deamons in the rc5.d and rc6.d directories,
rebooted and linux started each instance of postmaster as expected
/usr/bin/postmaster -i -p 5433
/usr/bin/postmaster -i -p 5434
I then logged in as postgres and initlocation on each data area.
I then attempted to create a user for each location
createuser -p 5433 abc
psql: connectDBStart ( ) -- connect() failed: No such file or directory
Is the postmaster running at 'localhost'
and accepting connections on Unix socket '5433'?
createuser: creation of user "abc" failed
createuser -p 5434 abc
CREATE USER
the second instance works and the first instance didn't.
Im stumped at this point. Help please.
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster