From: | Stephen Frost <sfrost(at)snowman(dot)net> |
---|---|
To: | Ayush Goyal <ayush(at)helpshift(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Using pg hotbackup directly without wal archives |
Date: | 2016-10-26 13:30:56 |
Message-ID: | 20161026133056.GB13284@tamriel.snowman.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Greetings,
* Ayush Goyal (ayush(at)helpshift(dot)com) wrote:
> 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.
No, WAL is required for correct backups. There are multiple ways to
ensure that the WAL is archived.
> 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?
No, the database state will *not* be consistent after pg_resetxlog. You
must archive the WAL which is written during the backup and must provide
a recovery.conf when performing a restore.
I strongly recommend that you look at using the existing PG backup tools
which will correctly perform the backup and WAL archiving, such as
pg_basebackup, pgBackRest, or barman.
Thanks!
Stephen
From | Date | Subject | |
---|---|---|---|
Next Message | Poul Kristensen | 2016-10-26 13:36:40 | Re: PostgresSQL 9.5 and systemd autorestart but without replication. |
Previous Message | Tom Lane | 2016-10-26 13:10:49 | Re: PostgresSQL 9.5 and systemd autorestart but without replication. |