Tom Lane wrote: > Rikard Pavelic <[EMAIL PROTECTED]> writes: > >> I'm looking for recommendation for tracking DDL changes on >> single database instance. >> > > Perhaps "ALTER DATABASE mydb SET log_statement = ddl" would do what > you want. > > regards, tom lane > > ;( I'm having trouble with this one.
If postgresql.conf has log_statement=none and I execute log_statement=ddl on mydb I don't see any ddl in pg_log So I tried setting log_statement=ddl in postgresql.conf and I see ddl from all databases in pg_log I tried "Alter database other_db set log_statement=none" but it's ddl changes still appears in pg_log Anyway, it's not a big deal, I can extract ddl which I need based on log_line_prefix and %d Regards, Rikard ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
