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]

Reply via email to