Re: track ddl changes on single database
От | hubert depesz lubaczewski |
---|---|
Тема | Re: track ddl changes on single database |
Дата | |
Msg-id | 9e4684ce0706110355q3df95c3ej5929cff981be9c0e@mail.gmail.com обсуждение исходный текст |
Ответ на | track ddl changes on single database (Rikard Pavelic <rikard.pavelic@zg.htnet.hr>) |
Ответы |
Re: track ddl changes on single database
|
Список | pgsql-general |
you can modify log_line_prefix to contain database name.
depesz
--
http://www.depesz.com/ - nowy, lepszy depesz
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 по дате отправления: