Re: about and feature matrix on site

On Mon, Jun 20, 2016 at 09:07:22AM -0700, John R Pierce wrote:
> On 6/20/2016 8:48 AM, Alvaro Herrera wrote:
>
> Marko Tiikkaja wrote:
>
> > On 2016-06-20 5:23 PM, Jim Michaels wrote:
>
> > >both about and feature matrix on site should contain the critical
> > >feature that the db files can be backed up since they do not mod the fs
> > >under the hood like other DBMS. this is very important for me.
>
> >
> > Huh? You can ABSOLUTELY NOT take backups of postgres that way.
>
> Actually you can, as long as the server is stopped.
>
>
> or if you bracket the backup with pg_{start,stop}_backup() calls...

And have all the WAL files used during the backup, and do PITR restore.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +