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  ("Erik Rijkers" <er@xs4all.nl>)
Re: testing cvs HEAD - HS/SR - xlog timeline 0 pg_xlogfile_name_offset  ("Erik Rijkers" <er@xs4all.nl>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: dblink for 8.4 should work without user-mappings
Следующее
От: Robert Haas
Дата:
Сообщение: Re: query cancel issues in contrib/dblink