Postgresql replication not starting after running pg_basebackup
| От | Jake O'brien Fagan |
|---|---|
| Тема | Postgresql replication not starting after running pg_basebackup |
| Дата | |
| Msg-id | CACjsCgTfvwsKMOjnrdAAHkTCrti8ab2_uj1s_ToegVbREJP4jw@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Postgresql replication not starting after running pg_basebackup
Re: Postgresql replication not starting after running pg_basebackup |
| Список | 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?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!
Thank you,
Jake
В списке pgsql-novice по дате отправления: