Postgres Pro
Downloads
Home   >   mailing lists

Re: track ddl changes on single database - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: track ddl changes on single database
Date
Msg-id 9e4684ce0706110355q3df95c3ej5929cff981be9c0e@mail.gmail.com
Whole thread Raw
In response to track ddl changes on single database  (Rikard Pavelic <rikard.pavelic@zg.htnet.hr>)
Responses Re: track ddl changes on single database  (Ray Stell <stellr@cns.vt.edu>)
List pgsql-general
Tree view
you can modify log_line_prefix to contain database name.

depesz

On 6/11/07, Rikard Pavelic <rikard.pavelic@zg.htnet.hr > wrote:
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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match



--
http://www.depesz.com/ - nowy, lepszy depesz

pgsql-general by date:

Previous
From: Rikard Pavelic
Date:
Subject: track ddl changes on single database
Next
From: "Pit M."
Date:
Subject: transaction problem using cursors