Re: backup.old

From: Steve Pribyl <Steve(dot)Pribyl(at)akunacapital(dot)com>
To: John R Pierce <pierce(at)hogranch(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: backup.old
Date: 2015-10-07 03:47:58
Message-ID: SN1PR07MB2175566B269178FFCC358269E4360@SN1PR07MB2175.namprd07.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Honestly I don't know. It was either pg_dump or a recovery script, that would have included a call to pg_start_backup. It does have the start_backup looking format.

START WAL LOCATION: F3/1000028 (file 00000045000000F300000001)
CHECKPOINT LOCATION: F3/1000060
BACKUP METHOD: pg_start_backup
BACKUP FROM: master
START TIME: 2015-05-30 01:39:24 CDT
LABEL: base-backup

Steve Pribyl
Sr. Systems Engineer
steve(dot)pribyl(at)akunacapital(dot)com
Desk: 312-994-4646

________________________________________
From: pgsql-general-owner(at)postgresql(dot)org <pgsql-general-owner(at)postgresql(dot)org> on behalf of John R Pierce <pierce(at)hogranch(dot)com>
Sent: Tuesday, October 6, 2015 10:43 PM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] backup.old

On 10/6/2015 8:28 PM, Steve Pribyl wrote:
> What do I need to do to recover a database server that has a backup.old file in the data_directory. I have see references to a database being stopped during a backup and/or a second backup running and moving the old file aside, but it was not clear to me what needs to be done do recover.
>
> postgresql-9.3 9.3.0-2.pgdg12.4+1

what method or software were you using to perform this backup?

--
john r pierce, recycling bits in santa cruz

--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
________________________________
[http://www.akunacapital.com/images/akuna.png]
Steve Pribyl | Senior Systems Engineer
Akuna Capital LLC
36 S Wabash, Suite 310 Chicago IL 60603 USA | www.akunacapital.com <http://www.akunacapital.com>
p: +1 312 994 4646 | m: | f: +1 312 750 1667 | Steve(dot)Pribyl(at)akunacapital(dot)com

Please consider the environment, before printing this email.

This electronic message contains information from Akuna Capital LLC that may be confidential, legally privileged or otherwise protected from disclosure. This information is intended for the use of the addressee only and is not offered as investment advice to be relied upon for personal or professional use. Additionally, all electronic messages are recorded and stored in compliance pursuant to applicable SEC rules. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, printing or any other use of, or any action in reliance on, the contents of this electronic message is strictly prohibited. If you have received this communication in error, please notify us by telephone at (312)994-4640 and destroy the original message.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bernd Helmle 2015-10-07 09:20:31 Issues with german locale on CentOS 5,6,7
Previous Message John R Pierce 2015-10-07 03:43:09 Re: backup.old