Allow the audit.log_id_seq sequence to be backed with pg_dump

m-martinez / pg-audit-json

Simple, easily customised trigger-based auditing for PostgreSQL (Postgres). See also pgaudit.

Other

44 stars 9 forks source link

Allow the audit.log_id_seq sequence to be backed with pg_dump #6

Closed zaucker closed 4 years ago

zaucker commented 4 years ago

The sequence should be backup up together with the audit.log table, otherwise the last sequence value will not be set with setval() upon restore and the next entry into the audit.log table will fail.

m-martinez commented 4 years ago

Great! Thank you so much!