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@momjian.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 +