[GENERAL] Advance SQL subquery

Hello, I have a table like : date|value --- 2009-09-19 | 1 2009-09-20 | 2 2009-09-21 | 6 2009-09-22 | 9 2009-09-23 | 1 I'd like a request which gives me the sum of each last n days. For example, if I want the sum of each 3 days,

Re: [GENERAL] Advance SQL subquery

On 23 sep, 17:32, mmonc...@gmail.com (Merlin Moncure) wrote: > On Wed, Sep 23, 2009 at 8:13 AM, AnthonyV wrote: > > Hello, > > > I have a table like : > > >   date        |    value > > --- > > 2009-09-19 |      1 > >

[GENERAL] Backup Postgre server

Hello, I have a pg8.3 server (an 8.4 upgrade is scheduled) on Windows. I would like an other pg server in backup in case of hardware problem on my first server. I use read/write queries and I would like the second pg become master without any human intervention. I saw Slony, but it seems that th

Re: [GENERAL] Backup Postgre server

On 23 nov, 13:20, plk.zu...@gmail.com (Filip Rembiałkowski) wrote: > 2009/11/23 AnthonyV : > > > Hello, > > > I have a pg8.3 server (an 8.4 upgrade is scheduled) on Windows. > > I would like an other pg server in backup in case of hardware problem > > on my fir