Re: 9.4 and centos/yum multiversion installs

On 9/29/2015 10:09 AM, John R Pierce wrote:
> does the 9.4 yum install no longer support using the sysconfig
> settings fragments ? I see what looks like the correct shell code for
> it in /etc/rc.d/init.d/postgresql-9.4 ...
>
> # Override defaults from /etc/sysconfig/pgsql if file is present
> [ -f /etc/sysconfig/pgsql/${NAME} ] && . /etc/sysconfig/pgsql/${NAME}
>
>
> ....arrrrgh, comment in /etc/rc.d/init.d/postgresql-9.4 would suggest
> so...
>
>
> # Version 9.4.0 Devrim Gunduz <devrim(at)gunduz(dot)org>
> # Remove PGPORT variable
>
> so... how do you run multiple versions??

and apparently the answer is, you set pgport in postgresql.conf rather
than via shell. ugh. means you can't tell the port from ps...

$ ps auxww |grep postmaster
postgres 3291 0.0 0.0 1288244 57876 ? S Aug30 13:31
/usr/pgsql-9.1/bin/postmaster -p 5433 -D /var/lib/pgsql/9.1/data
postgres 3333 0.0 0.0 2352980 76048 ? S Aug30 21:28
/usr/pgsql-9.2/bin/postmaster -p 5432 -D /var/lib/pgsql/9.2/data
postgres 3442 0.0 0.0 2352848 76060 ? S Aug30 10:57
/usr/pgsql-9.3/bin/postmaster -p 5435 -D /var/lib/pgsql/9.3/data
postgres 44139 0.0 0.0 324628 15084 ? S 10:12 0:00
/usr/pgsql-9.4/bin/postmaster -D /var/lib/pgsql/9.4/data

--
john r pierce, recycling bits in santa cruz