Your message dated Mon, 8 Aug 2011 12:03:10 +0200
with message-id <[email protected]>
and subject line Re: Bug#616154: postgresql-9.0: Bug prevents access to
postgresql 9 after upgrade from 8.4
has caused the Debian Bug report #616154,
regarding postgresql-9.0: Bug prevents access to postgresql 9 after upgrade
from 8.4
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
616154: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=616154
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: postgresql-9.0
Version: 9.0.3-1
Severity: normal
initially not even the admin could access the
database because all the defaults expect port
5432. The 9.0 postgresql.conf file sets the
port to 5433. Changing the port back to 5432
allows access to the database using existing
settings for pgadmin3 and psql.
-- System Information:
Debian Release: wheezy/sid
APT prefers testing
APT policy: (500, 'testing')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.36-rc8-ver.1.0 (SMP w/4 CPU cores)
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages postgresql-9.0 depends on:
ii libc6 2.11.2-11 Embedded GNU C Library: Shared lib
hi libcomerr2 1.41.12-2 common error description library
ii libgssapi-krb5-2 1.8.3+dfsg-4 MIT Kerberos runtime libraries - k
ii libkrb5-3 1.8.3+dfsg-4 MIT Kerberos runtime libraries
ii libldap-2.4-2 2.4.23-7 OpenLDAP libraries
ii libpam0g 1.1.2-2 Pluggable Authentication Modules l
ii libpq5 9.0.3-1 PostgreSQL C client library
ii libssl0.9.8 0.9.8o-5 SSL shared libraries
ii libxml2 2.7.8.dfsg-2 GNOME XML library
ii locales 2.11.2-11 Embedded GNU C Library: National L
ii postgresql-client-9.0 9.0.3-1 front-end programs for PostgreSQL
ii postgresql-common 114 PostgreSQL database-cluster manage
ii ssl-cert 1.0.28 simple debconf wrapper for OpenSSL
ii tzdata 2011b-2 time zone and daylight-saving time
postgresql-9.0 recommends no packages.
Versions of packages postgresql-9.0 suggests:
hi pidentd [ident-server] 3.0.19.ds1-5 TCP/IP IDENT protocol server with
-- no debconf information
--- End Message ---
--- Begin Message ---
Hello Richard,
richard [2011-03-02 20:29 +0000]:
> initially not even the admin could access the database because all
> the defaults expect port 5432. The 9.0 postgresql.conf file sets the
> port to 5433. Changing the port back to 5432 allows access to the
> database using existing settings for pgadmin3 and psql.
It does default to port 5432, but it will pick pick 5433, 5434, etc.
if the port is already being used by another instance/version. So
presumably "pg_lsclusters" already showed another cluster at the time
when you installed this?
Thanks,
Martin
--
Martin Pitt | http://www.piware.de
Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org)
--- End Message ---
