Re: [GENERAL] PGDATA / data_directory

2016-09-07 Thread Christoph Berg 
Re: Jehan-Guillaume de Rorthais 2016-09-07 <20160907140816.3e13eaa3@firost>
> Indeed. I never noticed data_directory was set in postgresql.conf file...
> 
> But then, why starting PostgreSQL with the following command ?
> 
>   /usr/lib/postgresql/9.4/bin/postgres -D /var/lib/postgresql/9.4/main \
> -c config_file=/etc/postgresql/9.4/main/postgresql.conf
> 
> It seems the following one work as expected and seems more logical with this
> setup:
> 
>   /usr/lib/postgresql/9.4/bin/postgres -D /etc/postgresql/9.4/main/

TBH, I've been wondering about that myself, but never bothered to to
anything about it. Digging in the (now git) history, it's been like
that from the very beginning in 2005:

https://anonscm.debian.org/cgit/pkg-postgresql/postgresql-common.git/commit/?id=9fa563e78366db3b27d680607c202b6fbb00bef2

It got touched a bit when 8.0 support was added, but basically not
changed since then.

https://anonscm.debian.org/cgit/pkg-postgresql/postgresql-common.git/commit/?id=fecbaad06c3683452228d31c0baffb01ba626a9a

I'll see if I can simply remove it. Thanks for the suggestion.

Christoph


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] PGDATA / data_directory

2016-09-07 Thread Jehan-Guillaume de Rorthais 
On Sun, 4 Sep 2016 11:40:38 +0200
Christoph Berg  wrote:

> Re: Benoit Lobréau 2016-08-31
>

Re: [GENERAL] PGDATA / data_directory

2016-09-04 Thread Christoph Berg 
Re: Benoit Lobréau 2016-08-31

[GENERAL] PGDATA / data_directory

2016-09-02 Thread Benoit Lobréau 
Hi,

My company is using PGDATA to store configuration files and the guc
data_directory to give the path to the instance directory.

They would use it like this:

pg_ctl start -D  -w

with this directory setup:

/CONFDIR => postgresql.conf pg_hba.conf pg_ident.conf
/SYSTEM => All the normal stuff in the postgres instance
directory + recovery.conf recovery.done etc...

Is it commonly used ?

Thanks for your help / remarks / feedback.

Benoit.