Thread: How to config start/stop scripts in a different data dir for CentOS7/systemctl/PG9.6

How to config start/stop scripts in a different data dir for CentOS7/systemctl/PG9.6

From
Edilmar LISTAS
Date:
Hi,

I do these steps to config Postgresql 9.6 in CentOS 6.x using a
different data directory:
yum -y install postgresql96-server postgresql96-contrib pg_top96
chkconfig postgresql-9.6 on
service postgresql-9.6 initdb
service postgresql-9.6 start
echo "localhost:5432:*:postgres:mypass" > ~/.pgpass
chmod 0600 ~/.pgpass
echo "localhost:5432:*:postgres:mypass" > ~postgres/.pgpass
chmod 0600 ~postgres/.pgpass
chown postgres.postgres ~postgres/.pgpass
su - postgres
psql -U postgres -c "ALTER USER postgres WITH PASSWORD 'mypass';"
exit
#------------------------------------- => my data dir is /sistemas/sat4/bdpg
service postgresql-9.6 stop
cd /etc/rc.d/init.d
ln postgresql-9.6 pgsat
cd /etc/sysconfig/pgsql
echo "PGDATA=/sistemas/sat4/bdpg" > pgsat
mkdir /sistemas/sat4/bdpg
chown postgres.postgres /sistemas/sat4/bdpg
chmod 700 /sistemas/sat4/bdpg
su - postgres
/usr/pgsql-9.6/bin/initdb -D /sistemas/sat4/bdpg
/usr/pgsql-9.6/bin/pg_ctl -D /sistemas/sat4/bdpg -l logfile start
sleep 5000
psql -U postgres -c "ALTER USER postgres WITH PASSWORD 'mypass';"
exit
#-------------------------------------
su - postgres
/usr/pgsql-9.6/bin/pg_ctl -D /sistemas/sat4/bdpg -l logfile stop
exit
service pgsat start
chkconfig --add pgsat
chkconfig pgsat on
chkconfig postgresql-9.6 off
#-------------------------------------

But now CentOS7 uses the new systemd service control system.
I only get to start PG manually like this:
su - postgres
/usr/pgsql-9.6/bin/pg_ctl -D /sistemas/sat4/bdpg -l logfile start





I decided to use the pg_ctl to start/stop, I didn't find a way to
configure systemctl script.

Em 05-12-2016 15:21, Edilmar LISTAS escreveu:
> Hi,
>
> I do these steps to config Postgresql 9.6 in CentOS 6.x using a
> different data directory:
> yum -y install postgresql96-server postgresql96-contrib pg_top96
> chkconfig postgresql-9.6 on
> service postgresql-9.6 initdb
> service postgresql-9.6 start
> echo "localhost:5432:*:postgres:mypass" > ~/.pgpass
> chmod 0600 ~/.pgpass
> echo "localhost:5432:*:postgres:mypass" > ~postgres/.pgpass
> chmod 0600 ~postgres/.pgpass
> chown postgres.postgres ~postgres/.pgpass
> su - postgres
> psql -U postgres -c "ALTER USER postgres WITH PASSWORD 'mypass';"
> exit
> #------------------------------------- => my data dir is
> /sistemas/sat4/bdpg
> service postgresql-9.6 stop
> cd /etc/rc.d/init.d
> ln postgresql-9.6 pgsat
> cd /etc/sysconfig/pgsql
> echo "PGDATA=/sistemas/sat4/bdpg" > pgsat
> mkdir /sistemas/sat4/bdpg
> chown postgres.postgres /sistemas/sat4/bdpg
> chmod 700 /sistemas/sat4/bdpg
> su - postgres
> /usr/pgsql-9.6/bin/initdb -D /sistemas/sat4/bdpg
> /usr/pgsql-9.6/bin/pg_ctl -D /sistemas/sat4/bdpg -l logfile start
> sleep 5000
> psql -U postgres -c "ALTER USER postgres WITH PASSWORD 'mypass';"
> exit
> #-------------------------------------
> su - postgres
> /usr/pgsql-9.6/bin/pg_ctl -D /sistemas/sat4/bdpg -l logfile stop
> exit
> service pgsat start
> chkconfig --add pgsat
> chkconfig pgsat on
> chkconfig postgresql-9.6 off
> #-------------------------------------
>
> But now CentOS7 uses the new systemd service control system.
> I only get to start PG manually like this:
> su - postgres
> /usr/pgsql-9.6/bin/pg_ctl -D /sistemas/sat4/bdpg -l logfile start
>
>
>
>
>



On Thu, Dec 08, 2016 at 05:16:11PM -0300, Edilmar LISTAS wrote:
> I decided to use the pg_ctl to start/stop, I didn't find a way to
> configure systemctl script.

I didn't noticed your first mail.

You can find all needed informations on this blog post:

https://people.planetpostgresql.org/devrim/index.php?/archives/82-Running-more-than-one-9.4-9.3-instance-in-parallel-on-RHEL-7.html
(This link is available in the "Yum Howto" section of yum.postgresql.org)

Last time I tried it worked as intended.

--
Julien Rouhaud
http://dalibo.com - http://dalibo.org


On Thu, Dec 08, 2016 at 05:16:11PM -0300, Edilmar LISTAS wrote:
> I decided to use the pg_ctl to start/stop, I didn't find a way to
> configure systemctl script.

I didn't noticed your first mail.

You can find all needed informations on this blog post:

https://people.planetpostgresql.org/devrim/index.php?/archives/82-Running-more-than-one-9.4-9.3-instance-in-parallel-on-RHEL-7.html
(This link is available in the "Yum Howto" section of yum.postgresql.org)

Last time I tried it worked as intended.

--
Julien Rouhaud
http://dalibo.com - http://dalibo.org