Re: Methods to quiesce PostgreSQL DB without configuring log archival

From: Scott Mead <scottm(at)openscg(dot)com>
To: MEERA <meeranair89(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Methods to quiesce PostgreSQL DB without configuring log archival
Date: 2016-11-23 17:53:07
Message-ID: 01E4A593-0BBF-4A4E-817A-F542FA4074A0@openscg.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> On Nov 22, 2016, at 01:23, MEERA <meeranair89(at)gmail(dot)com> wrote:
>
> Hi all,
>
> If archive_mode is not configured, and i use snapshot solution for backup of the server, how can i ensure data consistency? Is there a way to quiesce all the connections to DB?

If your snapshot solution is atomic, then you are *probably* okay. I would do a few restores to test, but atomic snapshots give you a point in time and should be consistent.

Personally, I like archiving because it removes all of the maybes, but, that's me :)

>
>
> Thanks,
> Meera

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Israel Brewster 2016-11-23 18:16:48 Backup "Best Practices"
Previous Message John R Pierce 2016-11-23 17:53:04 Re: Partial update on an postgres upsert violates constraint