Re: Can take filesystem bkp of pg data folder when server is running

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: vidyasagarps(at)gmail(dot)com, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: Can take filesystem bkp of pg data folder when server is running
Date: 2018-01-26 04:59:56
Message-ID: a831f2b5-ded2-65aa-5488-988b3dc63663@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On 1/23/18 01:00, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/10/static/backup-file.html
> Description:
>
> I am running postgresql 10 on mac and was experimenting on backup and
> restore features of PG 10
> I certainly can take FS backup of the cluster with TAR when server is
> running and with ACTIVE client connections [dummy begin; statement]
>
> This seems against the documented explanation for FS backup method and its
> limitation.
>
> Is there something I am missing here?

It might work sometimes, especially if you are trying it on a dummy
setup, but it's not going to work in general.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Peter Eisentraut 2018-01-26 05:03:54 Re: [PATCH] Updating documentation about bulding documentation in Windows.
Previous Message Peter Eisentraut 2018-01-26 03:59:23 Re: Correction of intermediate certificate handling