Running 2 postmaster Instances on different ports

From: "Gonzales,S" <gonzales_speedy(at)fastmail(dot)fm>
To: pgsql-admin(at)postgresql(dot)org
Subject: Running 2 postmaster Instances on different ports
Date: 2004-10-05 17:12:38
Message-ID: cjukma$nab$1@ikaria.belnet.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Environement: debian, postgresql 7.4.5

This is my problem:
"/etc/init.d/postgresql2 restart
Stopping PostgreSQL database server: postmasterpg_ctl: could not find
/var/lib/postgres/data2/postmaster.pid
Is postmaster running?
.
Starting PostgreSQL database server: postmaster(FAILED)
ERROR: pg_ctl: Another postmaster may be running. Trying to start
postmaster anyway.
pg_ctl: cannot start postmaster
Examine the log output."

The problem seems to be the "/etc/postmaster.conf",
this file seems to be used by both postmaster instances,
but since both postmaster instances have different data-dirs (two
different clusters), this is a problem. I would like the two clusters to
be started at boottime automatically.

I changed all the references in the "/etc/init.d/postgresql2" script to
the files in data-dir of second instance (with an adapted copy
postmaster.conf), but still this doesnt do the trick.

How do i solve this problem?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mike Darretta 2004-10-05 20:13:54 Migrating Data Between PG Tables
Previous Message John Allgood 2004-10-05 14:48:40 Re: Failover Solution for Postgres