Re: Postgres Backup Utility

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Postgres Backup Utility
Дата
Msg-id AANLkTikOdsjzGFMpti_P9+yuFGP08jA_QL1_vbBJd=uB@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgres Backup Utility  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-admin
On Thu, Jan 20, 2011 at 10:52 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> Followup, note that you can set the log_statement='ddl' for an entire
> pg cluster, for a single database, or for a single user, if that
> helps.  logging ddl does not log dml, or data changes, just structural
> changes.

also also wik, you can use the log_line_prefix to make it so that you
can grep out what you need easier too.

#log_line_prefix = ''                   # special values:
                                        #   %u = user name
                                        #   %d = database name
                                        #   %r = remote host and port
                                        #   %h = remote host
                                        #   %p = process ID
                                        #   %t = timestamp without milliseconds
                                        #   %m = timestamp with milliseconds
                                        #   %i = command tag
                                        #   %c = session ID
                                        #   %l = session line number
                                        #   %s = session start timestamp
                                        #   %v = virtual transaction ID
                                        #   %x = transaction ID (0 if none)
                                        #   %q = stop here in non-session
                                        #        processes
                                        #   %% = '%'
                                        # e.g. '<%u%%%d> '

В списке pgsql-admin по дате отправления:

Предыдущее
От: Chris Browne
Дата:
Сообщение: Re: State of multi-master replication options
Следующее
От: "Igor Neyman"
Дата:
Сообщение: Re: Postgres Backup Utility