Re: Proposed enhancement to the init.d script

Hi!
Hmm your email ended up in my Junk mail folder, so sorry for my late response.

Yes, that would've been good, but no rush.

Anyway, I also did see that LOCALE could be specified as input to the initdb function.
Perhaps it would be reasonable to add that as well as an option in the /etc/sysconfig/pgsql files?

I will look into a patch, hopefully in the coming week or so.

Best regards, Martin

-----Original Message-----
From: Devrim GÜNDÜZ [mailto:devrim(at)gunduz(dot)org]
Sent: den 10 oktober 2013 1:14
To: Gudmundsson Martin (mg)
Cc: pgsql-pkg-yum(at)postgresql(dot)org
Subject: Re: [pgsql-pkg-yum] Proposed enhancement to the init.d script

Hi Martin,

Sounds good to me. I wish you sent this mail 2 days before, while we
were working on updated releases, so that we could add this feature to
today's updates.

I created http://wiki.pgrpms.org/ticket/145 for this, and added you as a
CC, so that you can see the progress. I think we can add this feature
in next update set.

Regards, Devrim

On Thu, 2013-10-10 at 06:51 +0000, Gudmundsson Martin (mg) wrote:
> 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 :)
>
> 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.
>
> Best regards,
>
> 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(dot)mg(dot)gudmundsson(at)volvo(dot)com
> P Please consider your environmental responsibility. Before printing this e-mail ask yourself:- "Do I need a hard copy?"
>
>
>

--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz