Package: postgresql-8.2 Version: 8.2.4-1 Severity: grave Justification: renders package unusable
After upgrading from PostgreSQL 8.1 according to the instructions in the Debian.README I cannot start psql any more. I had moved my database files in 8.1 from their default location to their own partition on with their own controller and disks. PostgreSQL works OK and I can connect with Pgadmin (Debian Lenny AMD64, PostgreSQL 8.2.4). When I want to connect with psql however (with a non-root account) I get the following: panoramix:~$ psql -d my_database Error: Cannot stat /pgdata/8.2/main /pgdata/8.2/main is the location where the database files are actually located. When I look in the postmaster.conf I see that the database is started with -D /pgdata/8.2/main and not with /var/lib/postgresql/8.2/main. During the upgrade /var/lib/postgresql/8.1/main was a symlink to /pgdata/8/1/main. -- System Information: Debian Release: lenny/sid APT prefers testing APT policy: (500, 'testing'), (500, 'stable') Architecture: amd64 (x86_64) Kernel: Linux 2.6.18-4-amd64 (SMP w/2 CPU cores) Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) Shell: /bin/sh linked to /bin/bash Versions of packages postgresql-8.2 depends on: ii libc6 2.5-9 GNU C Library: Shared libraries ii libcomer 1.39+1.40-WIP-2006.11.14+dfsg-2 common error description library ii libkrb53 1.6.dfsg.1-4 MIT Kerberos runtime libraries ii libpam0g 0.79-4 Pluggable Authentication Modules l ii libpq5 8.2.4-1 PostgreSQL C client library ii libssl0. 0.9.8e-5 SSL shared libraries ii postgres 8.2.4-1 front-end programs for PostgreSQL ii postgres 75 manager for PostgreSQL database cl ii tzdata 2007f-8 time zone and daylight-saving time postgresql-8.2 recommends no packages. -- no debconf information -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]