Re: [ADMIN] snapshot backup with WAL files

2011-08-01 Thread Greg Smith
On 07/29/2011 11:35 AM, Isabella Ghiurea wrote: I would like to configure our Pg db for OS file system snapshot backup with Pg WAL files, need to know if would be enough in pg db to call : |*SELECT* *pg_start_backup*('pitr_backup'); and next take the snapshot and after pg_stop the backup

Re: [ADMIN] snapshot backup with WAL files

2011-08-01 Thread Robert Treat
On Fri, Jul 29, 2011 at 11:53 AM, Kevin Grittner wrote: > Isabella Ghiurea wrote: > >> I would like to configure  our Pg db for OS  file system snapshot >> backup with Pg  WAL files, need to know if would be enough in pg >> db to call : >> |*SELECT* *pg_start_backup*('pitr_backup'); >> and next t

Re: [ADMIN] snapshot backup with WAL files

2011-07-29 Thread Kevin Grittner
Isabella Ghiurea wrote: > I would like to configure our Pg db for OS file system snapshot > backup with Pg WAL files, need to know if would be enough in pg > db to call : > |*SELECT* *pg_start_backup*('pitr_backup'); > and next take the snapshot and after > pg_stop the backup and close the W

[ADMIN] snapshot backup with WAL files

2011-07-29 Thread Isabella Ghiurea
Hello Gurus, I would like to configure our Pg db for OS file system snapshot backup with Pg WAL files, need to know if would be enough in pg db to call : |*SELECT* *pg_start_backup*('pitr_backup'); and next take the snapshot and after pg_stop the backup and close the WAL files . During thi