Re: psql + autocommit

* Michael Paesold:
| Peter Eisentraut wrote:
| > Lars Haugseth wrote:
| > > Version 8.0.0beta2 supports a global configuration file. It's should
| > > be located in '~postgres/etc/pgsql'.
| >
| > That would be pretty useless, since normal users often don't have read
| > access to another user's home directory.
|
| Further up in this thread I read $PGDATA/etc/psqlrc, which seems like
| nonsense, too. First, $PGDATA is not known at compile time, second no user
| should have access to that directory.
|
| Perhaps it should be (and really is) $PREFIX/etc/psqlrc?
| (where $PREFIX is of course the installation prefix set during configure)
|
| I am not at work, so I can have a look at the code or test it myself right
| now.

There's a file $PREFIX/share/psqlrc.sample that reads:

--
-- psql configuration file
--
-- This file is read before the .psqlrc file in the user's home directory.
--
-- Copy this to your sysconf directory (typically /usr/local/pgsql/etc) and
-- rename it psqlrc.

So $PREFIX/etc/psqlrc is the right place. (In my setup, ~postgres equals
$PREFIX).

This directory is not created by "gmake install", though. Perhaps it should
be?

--
Lars Haugseth
Tinde ASA
mob 92087323