Hi,
we need to run a second instance of PostgreSQL on one machine (RHEL5).
What I did:
made a /var/lib/pgsql2 directory
made a new link /usr/bin/postmaster2 -> postgres
edited /var/lib/pgsql2/data/postmaster.opts regarding link and port:
/usr/bin/postgres -D /var/lib/pgsql2/data
copied the init script and edited port and directories in the copy.
while the database starts when started manually, it won't through the
init script. This is where the problem seems to be with a "sh -x
/etc/init.d/postgres2 start":
postgresql2-Dienst starten:+ runuser -l postgres -c
'/usr/bin/postmaster2 -p '\''5433'\'' -D '\''/var/lib/pgsql2/data'\''
&'
+ sleep 2
++ pidof -s /usr/bin/postmaster2
+ pid=
+ '[' ']'
+ failure 'postgresql2-Dienst starten:'
it seems it doesn't get the pid correctly.
Does somebody have an idea where to check for mistakes?
Lars