postgresql-9.1: pg_stat_replication is empty for monitoring user.
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
Reply to: