Re: Proposed enhancement to the init.d script - Mailing list pgsql-pkg-yum

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@gunduz.org] 
Sent: den 10 oktober 2013 1:14
To: Gudmundsson Martin (mg)
Cc: pgsql-pkg-yum@postgresql.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
andnew 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/pgsqlfile.
 
> 
> 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
standardsby 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.dfrom 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.mg.gudmundsson@volvo.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