Thread: Is there a function to save schema history internally?
Hello Postgresql users,
Is there a function to save schema history internally?
By keeping the schema history inside the DB, we can keep track of what and when is changed in the schema.
While searching google. It seems it is a limitation with the audit trigger:
Thanks and regards,
Patrick
On 08/29/2014 11:23 AM, Patrick Dung wrote: > Hello Postgresql users, > > Is there a function to save schema history internally? > By keeping the schema history inside the DB, we can keep track of what > and when is changed in the schema. > > While searching google. It seems it is a limitation with the audit trigger: > https://wiki.postgresql.org/wiki/Audit_trigger#Limitation:_Cannot_audit_DDL Well going forward, 9.4+, there are EVENT TRIGGERS http://www.postgresql.org/docs/9.4/static/event-triggers.html For a recent thread on what is possible or not see: http://www.postgresql.org/message-id/20EE50F73664E744AF948F0106FE6DFA585A790C@SEAMBX01.sea.corp.int.untd.com > > Thanks and regards, > Patrick -- Adrian Klaver adrian.klaver@aklaver.com
Hi Adrian,
Thanks for the info.
Thanks and regards,
Patrick
On Saturday, August 30, 2014 5:28 AM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 08/29/2014 11:23 AM, Patrick Dung wrote:
> Hello Postgresql users,
>
> Is there a function to save schema history internally?
> By keeping the schema history inside the DB, we can keep track of what
> and when is changed in the schema.
>
> While searching google. It seems it is a limitation with the audit trigger:
> https://wiki.postgresql.org/wiki/Audit_trigger#Limitation:_Cannot_audit_DDL
Well going forward, 9.4+, there are EVENT TRIGGERS
http://www.postgresql.org/docs/9.4/static/event-triggers.html
For a recent thread on what is possible or not see:
http://www.postgresql.org/message-id/20EE50F73664E744AF948F0106FE6DFA585A790C@SEAMBX01.sea.corp.int.untd.com
>
> Thanks and regards,
> Patrick
--
Adrian Klaver
adrian.klaver@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> Hello Postgresql users,
>
> Is there a function to save schema history internally?
> By keeping the schema history inside the DB, we can keep track of what
> and when is changed in the schema.
>
> While searching google. It seems it is a limitation with the audit trigger:
> https://wiki.postgresql.org/wiki/Audit_trigger#Limitation:_Cannot_audit_DDL
Well going forward, 9.4+, there are EVENT TRIGGERS
http://www.postgresql.org/docs/9.4/static/event-triggers.html
For a recent thread on what is possible or not see:
http://www.postgresql.org/message-id/20EE50F73664E744AF948F0106FE6DFA585A790C@SEAMBX01.sea.corp.int.untd.com
>
> Thanks and regards,
> Patrick
--
Adrian Klaver
adrian.klaver@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general