track ddl changes on single database

From: Rikard Pavelic <rikard(dot)pavelic(at)zg(dot)htnet(dot)hr>
To: pgsql-general(at)postgresql(dot)org
Subject: track ddl changes on single database
Date: 2007-06-11 10:19:40
Message-ID: 466D21BC.6040105@zg.htnet.hr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

I'm looking for recommendation for tracking DDL changes on
single database instance.

Currently I'm using pg_log to extract DDL changes, but those changes
are cluster wide.

Ideally I would like to enable option in pg_log to give me info about
in which database changes were made.
Something like
timestamp DB: my_database LOG: statement: "DDL statement here..."

Is there such an option, or any other suggestion how to track
these changes?

Thanks,
Rikard

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2007-06-11 10:26:55 Re: performance problem with loading data
Previous Message Alban Hertroys 2007-06-11 09:43:02 Re: parametered views