On 05/23/2015 07:01 AM, rob stone wrote:
On Sat, 2015-05-23 at 04:23 -0700, twoflower wrote:
I thought I understood how specifying a config file path for the
server works, but that's apparently not the case.
The cluster data is at /storage/postgresql/9.4/data.
The config files are at /etc/postgresql/9.4/main (this is the default
location on Ubuntu).
This is how the beginning of /etc/postgresql/9.4/main/postgresql.conf
looks like:
data_directory = '/storage/postgresql/9.4/data'
hba_file = '/etc/postgresql/9.4/main/pg_hba.conf'
ident_file = '/etc/postgresql/9.4/main/pg_ident.conf'
So I wrote a few scripts to make my life easier, e.g. pg94start.sh:
su postgres -c "/usr/lib/postgresql/9.4/bin/pg_ctl
-D /storage/postgresql/9.4/data -o '-c
config_file=/etc/postgresql/9.4/main/postgresql.conf'"
But running this script did not work, the server would not start. So I
checked the log file and there was:
FATAL: could not open file
"/storage/postgresql/9.4/data/postgresql.conf": Permission denied
After fixing the ownership of this file, it worked.
What's the reason the server was trying to access that file? Why does
not the override given by the config_file parameter work?
Thank you.
______________________________________________________________________
View this message in context: Server tries to read a different config
file than it is supposed to
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
Similar hassles with Debian. I use scripts like this to start the
server.
#! /bin/sh
PGDATA=/home/postgres/data94;export PGDATA
PATH=$PATH:/usr/lib/postgresql/9.4/bin;export PATH
PGBINARIES=/usr/lib/postgresql/9.4/bin;export PGBINARIES
cd /usr/lib/postgresql/9.4/bin
./pg_ctl start
exit 0
I have different scripts depending on the version of Postgres that I
need. I know that I could have a generic script and just pass in the
variables. I run them as the postgres user.
It reads the conf file from the PGDATA path.
Any particular reason you do not use pg_ctlcluster?:
https://wiki.debian.org/PostgreSql#pg_ctl_replacement
HTH.
Robert
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
