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@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!