Re: WAL Archive Log
От | Simon Riggs |
---|---|
Тема | Re: WAL Archive Log |
Дата | |
Msg-id | 1282981883.1800.93.camel@ebony обсуждение исходный текст |
Ответ на | Re: WAL Archive Log (Sam Nelson <samn@consistentstate.com>) |
Список | pgsql-general |
On Fri, 2010-08-27 at 09:56 -0600, Sam Nelson wrote: > Alright, well, we'll probably do something with the archive command, > then, like either echoing %f to a log file or sending that to syslog > (and then, after the echo, doing the actual cp or scp or rsync or > whatever). That way, we should be able to get some form of timestamp > of when each WAL file is copied to the archive directory (using the > archive_command), right? > > > Is there any way we could somehow get postgres to log a line for us, > so that we get that line in the postgres log file? Or are we going to > have to use a separate file? Run this every N seconds to get the averaged write rate over the period SELECT pg_xlogfile_name(pg_current_xlog_location()); -- Simon Riggs www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Training and Services
В списке pgsql-general по дате отправления: