[arch-general] [arch-dev-public] Changes to postgresql

[Marti Raudsepp]

On Thu, Oct 11, 2012 at 2:26 PM, Thomas Bächler <thomas at archlinux.org> wrote:
> 1)
> postgresql expects its configuration files in /usr/etc/postgresql/. It
> doesn't install any files there by default, so namcap doesn't notice -
> however, you can copy the sample files from /usr/share/postgresql to
> this location. This must be fixed by appending --sysconfdir=/etc to the
> configure options.

I think you're wrong about this. PostgreSQL, by default, does not
store config files in /etc (or sysconfdir) at all. Configuration files
are stored along with everything else in PGDATA
(/var/lib/postgres/data)...

% sudo -u postgres strace -eopen postgres -D /var/lib/postgres/data
2>/tmp/strace.out
[...]
^C
% egrep '(etc|conf)' /tmp/strace.out

open("/etc/ld.so.cache", O_RDONLY|O_CLOEXEC) = 3
open("/var/lib/postgres/data/postgresql.conf", O_RDONLY) = 3
open("/etc/nsswitch.conf", O_RDONLY|O_CLOEXEC) = 3
open("/etc/host.conf", O_RDONLY|O_CLOEXEC) = 3
open("/etc/resolv.conf", O_RDONLY|O_CLOEXEC) = 3
open("/etc/ld.so.cache", O_RDONLY|O_CLOEXEC) = 3
open("/etc/hosts", O_RDONLY|O_CLOEXEC)  = 3
open("/etc/gai.conf", O_RDONLY|O_CLOEXEC) = 3
open("/etc/hosts", O_RDONLY|O_CLOEXEC)  = 8
open("/var/lib/postgres/data/pg_hba.conf", O_RDONLY) = 9
open("/var/lib/postgres/data/pg_ident.conf", O_RDONLY) = 9

No attempted accesses to /usr/etc.

Regards,
Marti