Subject: Re: Can take filesystem bkp of pg data folder when server is running
To: vidyasagarps@gmail.com, pgsql-docs@lists.postgresql.org
References: <20180123060015.7407.32905@wrigleys.postgresql.org>
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Organization: 2ndQuadrant
Message-ID: <a831f2b5-ded2-65aa-5488-988b3dc63663@2ndquadrant.com>
Date: Thu, 25 Jan 2018 23:59:56 -0500
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:52.0)
 Gecko/20100101 Thunderbird/52.5.2
MIME-Version: 1.0
In-Reply-To: <20180123060015.7407.32905@wrigleys.postgresql.org>
Content-Type: text/plain; charset=utf-8
Content-Language: en-US
Content-Transfer-Encoding: 7bit
Precedence: bulk

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