Hello,
Can you provide the output of following query?
select pg_xlogfile_name(pg_current_xlog_location());
--
Amit Langote
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Hello,
I got response from pgsql-hackers that it is normal. In fact, the
newer segments that you see are pre-allocated ones (none of those
contain any valid WAL data as of now). And WAL data is currently being
written to an earlier segment like 0001000E0080 (which
seems to be the lates
Eduardo Morras yahoo.es> writes:
>
> On Wed, 06 Mar 2013 19:09:43 -0700
> CS DBA consistentstate.com> wrote:
> > We actually are in HOT standby mode, and it is working. However we are
> > also migrating a second db from an older (8.4) server into this master
> > so we did a dump (using the 9.2
