Ian Barwick writes:
> On 12/10/2018 11:50 AM, Michael Paquier wrote:
>> Perhaps. Even with that, writing an extension for 9.2 would require
>> copy-pasting a lot of code from pg_controldata.c and taking as well the
>> code which has been introduced for the various control functions.
>> Dirty, sti
On 12/10/2018 11:50 AM, Michael Paquier wrote:
On Sun, Dec 09, 2018 at 08:10:57PM -0600, Ron wrote:
On 12/09/2018 07:51 PM, Ian Barwick wrote:
but you're out of luck for 9.2. The only option to query the desired
values via
SQL would be to write an extension which reads pg_controldata
(possibly
On 12/09/2018 08:50 PM, Michael Paquier wrote:
[snip]
(9.2 is EOL'd for one year now, you may want to upgrade.)
You assume that the DBA controls the data; he doesn't. It's the customer's
data, and they control the OS, RDBMS and application versions. We just
migrated the big databases off an
On Sun, Dec 09, 2018 at 08:10:57PM -0600, Ron wrote:
> On 12/09/2018 07:51 PM, Ian Barwick wrote:
>> but you're out of luck for 9.2. The only option to query the desired
>> values via
>> SQL would be to write an extension which reads pg_controldata
>> (possibly as a backport of the above-mentioned
On 12/09/2018 07:51 PM, Ian Barwick wrote:
On 12/09/2018 01:25 AM, Ron wrote:
>
> In v9.2 (yes, I know it's EOL; there's nothing I can do about it), what
tables
> do I query to get these values, and can I also get them from the streamed
> replication host?
>
> - Database cluster state
> - Lates
On 12/09/2018 01:25 AM, Ron wrote:
>
> In v9.2 (yes, I know it's EOL; there's nothing I can do about it), what tables
> do I query to get these values, and can I also get them from the streamed
> replication host?
>
> - Database cluster state
> - Latest checkpoint location
> - Time of latest check
In v9.2 (yes, I know it's EOL; there's nothing I can do about it), what
tables do I query to get these values, and can I also get them from the
streamed replication host?
Database cluster state
Latest checkpoint location
Time of latest checkpoint
[postgres@fpslbxhaprl05 ~]$ pg_controldata
p