Обсуждение: 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
От
Edilmar LISTAS
Дата:
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
Re: How to config start/stop scripts in a different data dir for CentOS7/systemctl/PG9.6
От
Edilmar LISTAS
Дата:
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 > > > > >
Re: How to config start/stop scripts in a different data dir for CentOS7/systemctl/PG9.6
От
Julien Rouhaud
Дата:
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