On Tue, Jul 29, 2014 at 09:08:38AM -0400, Bruce Momjian wrote: > On Thu, Jun 26, 2014 at 09:59:59AM -0400, Stephen Frost wrote: > > Simon, > > > > * Simon Riggs (si...@2ndquadrant.com) wrote: > > > "Which tables are audited" would be available via the reloptions > > > field. > > > > RLS could be implemented through reloptions too. Would it be useful to > > some people? Likely. Would it satisfy the users who, today, are > > actually asking for that feature? No (or at least, not the ones that > > I've talked with). We could expand quite a few things to work through > > reloptions but I don't see it as a particularly good design for complex > > subsystems, of which auditing is absolutely one of those. > > I saw many mentions of pg_upgrade in this old thread. I think the focus > should be in pg_dump, which is where the SQL syntax or custom reloptions > would be dumped and restored. pg_upgrade will just use that > functionality. In summary, I don't think there is anything > pg_upgrade-specific here, but rather the issue of how this information will > be dumped and restored, regardless of whether a major upgrade is taking > place.
Actually, thinking more, Stephen Frost mentioned that the auditing system has to modify database _state_, and dumping/restoring the state of an extension might be tricky. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers