On Wednesday, January 23, 2013 11:51 PM Alvaro Herrera wrote: > Fujii Masao escribió: > > On Wed, Jan 23, 2013 at 12:24 PM, Amit Kapila > <amit.kap...@huawei.com> wrote: > > > >> Is it safe to write something in the directory other than data > > >> directory > > >> via SQL? > > >> > > >> postgres user usually has the write permission for the > configuration > > >> directory like /etc/postgresql? > > > > > > As postgresql.conf will also be in same path and if user can change > that, > > > then what's the problem with postgresql.auto.conf > > > > If the configuration directory like /etc is owned by root and only > root has > > a write permission for it, the user running PostgreSQL server would > not > > be able to update postgresql.auto.conf there. OTOH, even in that > case, > > a user can switch to root and update the configuration file there. > I'm not > > sure whether the configuration directory is usually writable by the > user > > running PostgreSQL server in Debian or Ubuntu, though. > > Yes it is -- the /etc/postgresql/<version>/<cluster> directory (where > postgresql.conf resides) is owned by user postgres.
So in that case we can consider postgresql.auto.conf to be in path w.r.t postgresql.conf instead of data directory. With Regards, Amit Kapila. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
