[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

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      |    |                 |       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: