Hi!
I’m using the intit.d scripts to start our Postgres clusters. Also I am creating new files in /etc/sysconfig/pgsql and new links in /etc/init.d if I want new clusters.
I would like support in the init.d script, in the initdb function to also specify pg_xlog path, if specified in /etc/sysconfig/pgsql file.
So, let’s say I have the following in /etc/sysconfig/pgsql/secondary-9.3:
PGENGINE=/usr/pgsql-9.3/bin
PGPORT=5432
PGDATA=/var/lib/pgsql/9.3/data
PGLOG=/var/lib/pgsql/9.3/pgstartup.log
PGXLOG=/var/lib/pgsql/9.3/xlog # Added by me J
And then have the initdb function check for PGXLOG environment variable and if set, call initdb with –X $PGXLOG.
If this would be put in place it would be easier to automatically provision new postgres clusters according to our standards by using standard RHEL system commands from puppet, cfengine etc.
Then we just create a new file in /etc/sysconfig/pgsql with the settings for the new cluster, create a link in /etc/init.d from secondary-9.3 to postgres-9.3.
Then we just do:
# service secondary-9.3 initdb
# service secondary-9.3 start
# chkconfig secondary-9.3 on
And we would have a fully functional postgres cluster with xlog and data separated.
Would this be something that would be possible to implement? I could probably write a patch if wanted.
Martin Gudmundsson
Database Technical Specialist
Infrastructure Architect
Volvo Information Technology
IMO Java Database Gothenburg
Dept DE56720, DA2N
SE-405 08 Gothenburg, Sweden
Tel: +46 31 3224333
Email: martin.mg.gudmundsson@volvo.com
P Please consider your environmental responsibility. Before printing this e-mail ask yourself:- "Do I need a hard copy?"