I should have added that (on the slave) all pg_xlog/ files have timeline 1 like: 00000001000000E2000000C0
On Wed, February 24, 2010 20:40, Erikruary 24, 2010 20:40, Er Rijkers wrote: > I have two 9.0devel machines (*not* alpha but cvs as of 2010.02.19 22.48). > > One primary, one slave. > > In an attempt to keep track of standby progression (versus primary), I ran > slave-side: > > replicas=# select > pg_last_xlog_replay_location() > pg_xlogfile_name_offset(pg_last_xlog_replay_location()) > , pg_last_xlog_receive_location() > , pg_xlogfile_name_offset(pg_last_xlog_receive_location()) > ; > pg_last_xlog_replay_location | pg_xlogfile_name_offset | > ------------------------------+------------------------------------+- > E2/C012AD90 | (00000000000000E2000000C0,1224080) | > > pg_last_xlog_receive_location | pg_xlogfile_name_offset > -------------------------------+----------------------------------- > E2/C012AD90 | (00000000000000E2000000C0,1224080) > (1 row) > > These zero-timeline filenames look suspicious, no? > I understand timeline-count to normally start at 1, not 0? > > The replication seems to be running fine (680 GB). > > ps seems to report the right xlog filename (slave): > > /var/data1/pg_stuff/pg_installations/pgsql.sr_hotslave/bin/postgres -D > /var/data1/pg_stuff/pg_installations/pgsql.sr_hotslave/data > \_ postgres: startup process recovering 00000001000000E2000000C0 > \_ postgres: wal receiver process streaming E2/C012AE28 > \_ postgres: writer process > \_ postgres: stats collector process > > > > replicas=# select version(); > version > ------------------------------------------------------------------------------------------ > PostgreSQL 9.0devel on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) > 4.4.3, 64-bit > (1 row) > > > Is the filename that pg_xlogfile_name_offset( > pg_last_xlog_(replay|receive)_location() ) reports a > bug, or expected as shown? > > > thanks, > > > Erik Rijkers > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
