Postgres Pro
Downloads
Home   >   mailing lists

Re: [PROPOSAL] Backup and recovery of pg_statistic - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: [PROPOSAL] Backup and recovery of pg_statistic
Date
Msg-id CANP8+jK+eoTwzo_jbyQ5+_7DSh50Od4iYWp20oRw+C7DKVRWsA@mail.gmail.com
Whole thread Raw
In response to [PROPOSAL] Backup and recovery of pg_statistic  (Dmitry Ivanov <d.ivanov@postgrespro.ru>)
Responses Re: [PROPOSAL] Backup and recovery of pg_statistic
List pgsql-hackers
Tree view
On 27 November 2015 at 15:52, Dmitry Ivanov <d.ivanov@postgrespro.ru> wrote:

Currently there is no way to backup 'pg_statistic' because columns of
'anyarray' type cannot be reconstructed solely with their textual
representation. Meanwhile, all that is needed to solve this problem is a small
extension capable of retrieving the element type of an 'anyarray' object and
recreating this particular 'anyarray' object using the 'array_in' procedure.

Please submit a patch on core for this. 

--
Simon Riggs                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Tab-comletion for RLS
Next
From: Amit Kapila
Date:
Subject: Re: Move PinBuffer and UnpinBuffer to atomics