Postgresql replication not starting after running pg_basebackup

From: "Jake O'brien Fagan" <jake(at)househappy(dot)org>
To: pgsql-novice(at)postgresql(dot)org
Subject: Postgresql replication not starting after running pg_basebackup
Date: 2014-09-11 21:30:27
Message-ID: CACjsCgTfvwsKMOjnrdAAHkTCrti8ab2_uj1s_ToegVbREJP4jw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Howdy,

I am trying to create a hot_standby server, and I receive the following
error after pg_basebackup completes. Can anyone give me some insight?

My specs:
Debian Wheezy 7.6
Postgresql 9.3
Database size: ~115GB

postgres(at)database-master:/etc/postgresql/9.3/main$ sh replicator.sh
Stopping PostgreSQL
[ ok ] Stopping PostgreSQL 9.3 database server: main.
Cleaning up old cluster directory
Starting base backup as replicator
Password:

113720266/113720266 kB (100%), 1/1 tablespace

NOTICE: WAL archiving is not enabled; you must ensure that all required WAL
segments are copied through other means to complete the backup
pg_basebackup: base backup completed
Starting Postgresql
[....] Starting PostgreSQL 9.3 database server: main[....] The PostgreSQL
server failed to start. Please check the log output: 2014-09-11 17:56:33
UTC LOG: database system was interrupted; last known up at 2014-09-11
16:54:29 UTC 2014-09-11 17:56:33 UTC LOG: creating missing WAL directory
"pg_xlog/archive_status" 2014-09-11 17:56:33 UTC LOG: incomplete startup
packet 2014-09-11 17:56:33 UTC LOG: invalid checkpoint record 2014-09-11
17:56:33 UTC FATAL: could not locate required checkpoint record 2014-09-11
17:56:33 UTC HINT: If you are not restoring from a backup, try removing the
file "/var/lib/p[FAILesql/9.3/main/backup_label". 2014-09-11 17:56:33 UTC
LOG: startup process (PID 21972) exited with exit code 1 2014-09-11
17:56:33 UTC LOG: aborting startup due to startup process failure ...
failed! failed!

Thank you,
Jake
------------------------------

Jake O'Brien Fagan

Ruby Engineer
househappy.org <http://www.househappy.org/>
Facebook <https://www.facebook.com/househappy.org> | Twitter
<https://twitter.com/househappy> | Instagram
<http://instagram.com/househappy>

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Alonso Isidoro Roman 2014-09-15 10:04:27 newbee, about a bulk loading from a cdv file
Previous Message David Johnston 2014-09-09 19:05:01 Re: Condition in a calculated field