Re: [GENERAL] How to do incremental / differential backup every hour in Postgres 9.1?

2013-08-02 Thread Kevin Grittner
Jeff Janes wrote: > Neil McGuigan wrote: >> Trying to do an hourly hot incremental backup of a single postgres server >> (windows). > > Can you explain what "incremental backup" means to you?  I find that > there is a surprising variety of opinions about what these terms mean. > To me, the accumu

Re: [GENERAL] How to do incremental / differential backup every hour in Postgres 9.1?

2013-07-26 Thread Jeff Janes
On Thu, Jul 25, 2013 at 3:24 PM, Neil McGuigan wrote: > Trying to do an hourly hot incremental backup of a single postgres server > (windows). Can you explain what "incremental backup" means to you? I find that there is a surprising variety of opinions about what these terms mean. To me, the ac

Re: [GENERAL] How to do incremental / differential backup every hour in Postgres 9.1?

2013-07-26 Thread Giuseppe Broccolo
Hi Neil, Il 26/07/2013 00:24, Neil McGuigan ha scritto: Trying to do an hourly hot incremental backup of a single postgres server (windows). I have the following setup in postgresql.conf: max_wal_senders=2 wal_level=archive archive_mode=on archive_command='copy "%p" "c:\\postgres\\archive\\%f

Re: [GENERAL] How to do incremental / differential backup every hour in Postgres 9.1?

2013-07-26 Thread Amit Langote
On Fri, Jul 26, 2013 at 7:24 AM, Neil McGuigan wrote: > Trying to do an hourly hot incremental backup of a single postgres server > (windows). > > I have the following setup in postgresql.conf: > > max_wal_senders=2 > wal_level=archive > archive_mode=on > archive_command='copy "%p" "c:\\postgres\\

[GENERAL] How to do incremental / differential backup every hour in Postgres 9.1?

2013-07-25 Thread Neil McGuigan
Trying to do an hourly hot incremental backup of a single postgres server (windows). I have the following setup in postgresql.conf: max_wal_senders=2 wal_level=archive archive_mode=on archive_command='copy "%p" "c:\\postgres\\archive\\%f"' I did a base backup with pg_basebackup -U postgres -D ..\