Package: postgresql-9.1 Version: 9.1.3-2 Severity: normal *** Please type your report below this line ***
Regression: pg_stat_replication view is empty for monitoring user ( either with or without REPLICATION role ). In previous versions of postgresql 9.1 it was visible, and enabled monitoring state of replication. Now it seems that only SUPERUSER can check if replication is working correctly. Here's how it should look like: select * from pg_stat_replication: procpid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | state | sent_location | write_location | flush_location | replay_location | sync_priority | sync_state ---------+----------+-------------+------------------+----------------+-----------------+-------------+-------------------------------+-----------+---------------+----------------+----------------+-----------------+---------------+------------ 28561 | 81673311 | replication | walreceiver | 192.168.1.1 | | 45743 | 2012-04-04 09:04:30.554112+02 | streaming | F6D/B6D4CA08 | F6D/B6D4CA08 | F6D/B6D4CA08 | F6D/B6D4C990 | 0 | async -- System Information: Debian Release: 6.0.4 APT prefers stable APT policy: (500, 'stable') Architecture: amd64 (x86_64) Kernel: Linux 2.6.32.bsd54g3 (SMP w/48 CPU cores) Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) Shell: /bin/sh linked to /bin/bash Versions of packages postgresql-9.1 depends on: ii libc6 2.13-4 Embedded GNU C Library: Shared lib ii libcomerr2 1.41.12-4stable1 common error description library ii libgssapi-krb5-2 1.9+dfsg-1+b1 MIT Kerberos runtime libraries - k ii libkrb5-3 1.9+dfsg-1+b1 MIT Kerberos runtime libraries ii libldap-2.4-2 2.4.23-7.2 OpenLDAP libraries ii libpam0g 1.1.1-6.1+squeeze1 Pluggable Authentication Modules l ii libpq5 9.1.3-2 PostgreSQL C client library ii libssl0.9.8 0.9.8o-4squeeze7 SSL shared libraries ii libxml2 2.7.8.dfsg-2+squeeze3 GNOME XML library ii locales 2.13-4 Embedded GNU C Library: National L ii postgresql-client- 9.1.3-2 front-end programs for PostgreSQL ii postgresql-common 128 PostgreSQL database-cluster manage ii ssl-cert 1.0.28 simple debconf wrapper for OpenSSL ii tzdata 2011n-0squeeze1 time zone and daylight-saving time postgresql-9.1 recommends no packages. Versions of packages postgresql-9.1 suggests: pn locales-all <none> (no description available) pn oidentd | ident-server <none> (no description available) -- no debconf information -- To UNSUBSCRIBE, email to debian-wnpp-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org Archive: http://lists.debian.org/20120404082025.gj1...@kuszelas.eu