Re: [GENERAL] PostgreSQL and Windows 2003 DFS Replication

2006-08-18 Thread Magnus Hagander
> Hi list ! > > I am currently deploying two servers (Windows 2003 R2) that will be > used as file servers as well as PostgreSQL servers. > > One of the server will be the main server, the other one a backup > server (no load-balancing, only an easy-recoverage solution). > The goal is to be able

Re: [GENERAL] PostgreSQL and Windows 2003 DFS Replication

2006-07-31 Thread Csaba Nagy
On Fri, 2006-07-28 at 22:30, Merlin Moncure wrote: > On 7/28/06, Arnaud Lesauvage <[EMAIL PROTECTED]> wrote: > > Csaba Nagy wrote: > > > I found that PITR using WAL shipping is not protecting against all > > > failure scenarios... it sure will help if the primary machine's hardware > > > fails, but

Re: [GENERAL] PostgreSQL and Windows 2003 DFS Replication

2006-07-28 Thread Merlin Moncure
On 7/28/06, Arnaud Lesauvage <[EMAIL PROTECTED]> wrote: Csaba Nagy wrote: > I found that PITR using WAL shipping is not protecting against all > failure scenarios... it sure will help if the primary machine's hardware > fails, but in one case it was useless for us: the primary had a linux > kerne

Re: [GENERAL] PostgreSQL and Windows 2003 DFS Replication

2006-07-28 Thread Arnaud Lesauvage
Merlin Moncure wrote: I am currently deploying two servers (Windows 2003 R2) that will be used as file servers as well as PostgreSQL servers. One of the server will be the main server, the other one a backup server (no load-balancing, only an easy-recoverage solution). The goal is to be able to

Re: [GENERAL] PostgreSQL and Windows 2003 DFS Replication

2006-07-28 Thread Arnaud Lesauvage
Csaba Nagy wrote: for a cold/warm standby postgresql backup, I'd suggest using pitr. I found that PITR using WAL shipping is not protecting against all failure scenarios... it sure will help if the primary machine's hardware fails, but in one case it was useless for us: the primary had a linux

Re: [GENERAL] PostgreSQL and Windows 2003 DFS Replication

2006-07-27 Thread Csaba Nagy
> for a cold/warm standby postgresql backup, I'd suggest using pitr. I found that PITR using WAL shipping is not protecting against all failure scenarios... it sure will help if the primary machine's hardware fails, but in one case it was useless for us: the primary had a linux kernel with buggy X

Re: [GENERAL] PostgreSQL and Windows 2003 DFS Replication

2006-07-27 Thread Merlin Moncure
On 7/27/06, Arnaud Lesauvage <[EMAIL PROTECTED]> wrote: Hi list ! I am currently deploying two servers (Windows 2003 R2) that will be used as file servers as well as PostgreSQL servers. One of the server will be the main server, the other one a backup server (no load-balancing, only an easy-rec

[GENERAL] PostgreSQL and Windows 2003 DFS Replication

2006-07-27 Thread Arnaud Lesauvage
Hi list ! I am currently deploying two servers (Windows 2003 R2) that will be used as file servers as well as PostgreSQL servers. One of the server will be the main server, the other one a backup server (no load-balancing, only an easy-recoverage solution). The goal is to be able to start wor