[ADMIN] postgres deployment

2009-03-09 Thread Nagalingam, Karthikeyan
Hi, Can I know the effective solution to do the backup and recovery for Postgres in storage environment. Please share Any existing deployment and solution for backup and recovery for Postgres in storage Any suggestion and recommendation are welcome. Regards Karthikeyan.N

Re: [ADMIN] Urgent PST time changing tonight

2009-03-09 Thread DM
Thanks Steve for sharing this info. Thanks Deepak On Mon, Mar 9, 2009 at 12:14 PM, Steve Crawford < scrawf...@pinpointresearch.com> wrote: > DM wrote: > >> Hi All, >> >> PST time changing tonight, I am not sure if this is going to affect the >> database >> > IF you are up-to-date on your TZ f

Re: [ADMIN] Urgent PST time changing tonight

2009-03-09 Thread Scott Marlowe
On Mon, Mar 9, 2009 at 1:14 PM, Steve Crawford wrote: > Then there are the scripts that calculate dates externally for feeding into > your database-backed processes (for fun, try "-d yesterday" and "-d > tomorrow" in most versions of the "date" command in the vicinity of DST > changes). I ran int

Re: [ADMIN] Urgent PST time changing tonight

2009-03-09 Thread Steve Crawford
DM wrote: Hi All, PST time changing tonight, I am not sure if this is going to affect the database IF you are up-to-date on your TZ files the database itself should be fine. But external processing is another matter - especially if you have processes that assume conventions from previous