Error message in wal_log for Streaming replication

Поиск
Список
Период
Сортировка
От Nimesh Satam
Тема Error message in wal_log for Streaming replication
Дата
Msg-id AANLkTikX6DwvJseUST-dvXV8uBmSZQRmLKTrDmEowjhe@mail.gmail.com
обсуждение исходный текст
Ответы Re: Error message in wal_log for Streaming replication  (Jeff Davis <pgsql@j-davis.com>)
Список pgsql-performance
Hi All,

We have been trying to implement the streaming replication on one of our test servers. We have set archive_xlogs to on. But on the standby server,  when we start the database we get error the following errors:

LOG:  shutting down
LOG:  database system is shut down
LOG:  database system was shut down in recovery at 2010-10-05 05:05:27 EDT
LOG:  entering standby mode
cp: cannot stat `/home/postgres/archive_xlogs/000000010000000D00000036': No such file or directory
LOG:  consistent recovery state reached at D/36000078
LOG:  database system is ready to accept read only connections
LOG:  invalid record length at D/36000078
cp: cannot stat `/home/postgres/archive_xlogs/000000010000000D00000036': No such file or directory
LOG:  streaming replication successfully connected to primary

The file "000000010000000D00000036" is seen in pg_xlog folder of the primary database, but is not yet pushed to the archive location.

Can you let us know what the error means and if we are doing anything wrong?

Regards,
Nimesh.

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Sander, Ingo (NSN - DE/Munich)"
Дата:
Сообщение: Runtime dependency from size of a bytea field
Следующее
От: Dan Ports
Дата:
Сообщение: Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance