testing cvs HEAD - HS/SR - xlog timeline 0 pg_xlogfile_name_offset
От | Erik Rijkers |
---|---|
Тема | testing cvs HEAD - HS/SR - xlog timeline 0 pg_xlogfile_name_offset |
Дата | |
Msg-id | 965ef07ee820104e6d20840f8b9f4b60.squirrel@webmail.xs4all.nl обсуждение исходный текст |
Ответы |
Re: testing cvs HEAD - HS/SR - xlog timeline 0
pg_xlogfile_name_offset
Re: testing cvs HEAD - HS/SR - xlog timeline 0 pg_xlogfile_name_offset |
Список | pgsql-hackers |
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)(1row) 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: statscollector 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
В списке pgsql-hackers по дате отправления: