Using pg hotbackup directly without wal archives

From: Ayush Goyal <ayush(at)helpshift(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Using pg hotbackup directly without wal archives
Date: 2016-10-26 08:27:15
Message-ID: CA+Pdoy_rU8eqbXBZVKaqun8Q-K0e38QGpy_TiEV6uSW5hYa92Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

I need to ask if there is a way to use the pg hot backup taken via
pg_start_backup() and pg_stop_backup() calls directly without using the wal
archives.

If I start postgres with just base backup without setting up recovery.conf
for fetching archived wal logs, I get this im the log files:

2016-10-26 06:48:25 UTC LOG: database system was shut down in recovery at
2016-10-25 15:50:16 UTC
2016-10-26 06:48:25 UTC LOG: invalid primary checkpoint record
2016-10-26 06:48:25 UTC LOG: invalid secondary checkpoint record
2016-10-26 06:48:25 UTC PANIC: could not locate a valid checkpoint record
2016-10-26 06:48:25 UTC LOG: startup process (PID 980) was terminated by
signal 6: Aborted
2016-10-26 06:48:25 UTC LOG: aborting startup due to startup process
failure

Also, I noticed that if I run pg_resetxlog, I am able to start postgres,
but I am not sure if the database is consistent after running
pg_resetxlog. Is database state consistent after running pg_resetxlog on
this hot backup?

Thanks,
Ayush Goyal

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Poul Kristensen 2016-10-26 09:57:46 Re: PostgresSQL 9.5 and systemd autorestart but without replication.
Previous Message Albe Laurenz 2016-10-25 10:46:53 Re: pg_basebackup Error