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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
