Peter Eisentraut <peter_e@gmx.net> writes:
> Iain wrote:
>> Is there a "standard" directory that people tend to use for this,
>> such as /var/local/pgsql/ ?
> According to the Filesystem Hierarchy Standard, program data should be
> under /var/lib/<packagename>. Indeed, many binary distributions use
> some variant of that as data directory location.
The RPM distributions of PG use /var/lib/pgsql/data as the standard
PGDATA value. I'm not sure what Debian does but I think it might be
different. Also there has been some talk of including the major
release number (7.4, 8.0, etc) in the standard PGDATA value, to ease
migration across server versions by allowing different versions to be
installed concurrently.
regards, tom lane