Re: Use a custom postgresql.conf?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 11/29/2011 01:06 PM, Colin E Busse wrote:
Hello,

I am trying to determine how to get postgres to use a custom postgresql.conf file that will be located in a directory other than the default postgresql.conf file.  I would like it to be installed via an rc script so that the database setup can be part of a self-contained install.  I do not want to use symbolic links, and I do not want to edit the default postgresql.conf file.  I am using PostgreSQL version 8.4.4 on Red Hat Enterprise Linux 6.  Currently, I am able to start the database using the following command, which specifies my custom postgresql.conf file:

pg_ctl start -D /var/lib/pgsql/data -l /var/lib/pgsql/pgstartup.log -o "-c config_file='/<path-to-custom-config-file>/postgresql.conf'"

Is there a way to set this up so that I can simply call:

service postgresql start

And have the database start using my config file?

Don't have RHEL6 handy so looking at a CentOS 5.3 box...

I *think* you should be able to put the custom settings in /etc/sysconfig/pgsql/postgresql which is used by /etc/init.d/postgresql to override its defaults. Set $PGOPTS to the custom additions to the standard startup command.

The wiki page may be of help: http://wiki.postgresql.org/wiki/PostgreSQL_on_RedHat_Linux

Cheers,
Steve


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux