public inbox for [email protected]  

help / color / mirror / Atom feed

Can take filesystem bkp of pg data folder when server is running
2+ messages / 2 participants
[nested] [flat]

* Can take filesystem bkp of pg data folder when server is running
@ 2018-01-23 06:00  PG Doc comments form <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: PG Doc comments form @ 2018-01-23 06:00 UTC (permalink / raw)
  To: [email protected]; +Cc: [email protected]

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?


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Can take filesystem bkp of pg data folder when server is running
@ 2018-01-26 04:59  Peter Eisentraut <[email protected]>
  parent: PG Doc comments form <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Peter Eisentraut @ 2018-01-26 04:59 UTC (permalink / raw)
  To: [email protected]; [email protected]

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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2018-01-26 04:59 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-01-23 06:00 Can take filesystem bkp of pg data folder when server is running PG Doc comments form <[email protected]>
2018-01-26 04:59 ` Peter Eisentraut <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox