Package: postgresql
Version: 7.5.4
Severity: normal
Since updating to the new postgresql packages last night and also
installing postgresql 8, when I su to the postgres user I now get the
following error:
jupiter:~# su - postgres
-su: /etc/postgresql/postmaster.conf: No such file or directory
This is caused by a .profile in the homedir of the postgres user which
contains:
. /etc/postgresql/postmaster.conf
PATH=/bin:/usr/bin:/usr/lib/postgresql/bin
POSTGRES_DATA=/var/lib/postgres/data
PGDATA=${POSTGRES_DATA:-/var/lib/postgres/data}
PGLIB=/usr/lib/postgresql/lib
export PGLIB PGDATA
Now that the packages have moved to a different directory layout all
of this is basically incorrect. I'm not sure how important it is to
set these variables or how I would go about setting them correctly
depending on the version of the database to which I wanted to talk.
Thanks,
Stephen Quinney
-- System Information:
Debian Release: testing/unstable
APT prefers unstable
APT policy: (500, 'unstable')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.11
Locale: LANG=C, LC_CTYPE=C (charmap=UTF-8) (ignored: LC_ALL set to en_GB.UTF-8)
Versions of packages postgresql depends on:
ii postgresql-7.4 1:7.4.8-7 object-relational SQL database, ve
ii postgresql-client 7.5.4 front-end programs for PostgreSQL
-- debconf information:
* postgresql/upgrade/preserve_location: /var/lib/postgres/preserve
* postgresql/settings/day_month_order: US
postgresql/convert-postmaster.init: true
* postgresql/upgrade/policy: true
postgresql/enable_lang: true
postgresql/contains_POSTGRESHOME: true
postgresql/very_old_version_warning: true
* postgresql/upgrade/dump_location: /var/lib/postgres
postgresql/convert-pg_hba.conf: true
* postgresql/initdb/location: /var/lib/postgres/data
shared/postgresql/upgrade74: false
* postgresql/settings/locale: C
postgresql/peer-to-ident: true
postgresql/missing_conf: true
* postgresql/purge_data_too: false
* postgresql/settings/encoding: per_locale
* postgresql/settings/date_style: ISO
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
