Error message in wal_log for Streaming replication

From: Nimesh Satam <nimesh(dot)zedo(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Error message in wal_log for Streaming replication
Date: 2010-10-05 09:11:49
Message-ID: AANLkTikX6DwvJseUST-dvXV8uBmSZQRmLKTrDmEowjhe@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2010-10-05 16:11:29 Re: Runtime dependency from size of a bytea field
Previous Message Sander, Ingo (NSN - DE/Munich) 2010-10-05 07:23:27 Runtime dependency from size of a bytea field