[GENERAL] warm database, tape device backup

2009-02-06 Thread milos . babic
abase)? Another question is: Do you have some positive experience regarding warm standby databases of this size? Kind regards Milos Babic

Re: [GENERAL] This is my first template

2009-04-21 Thread milos . babic
There are 30 days in April. On Apr 21, 2009 2:34pm, Merlin Moncure wrote: On Tue, Apr 21, 2009 at 7:02 AM, Geoff Caplan ge...@uviva.com> wrote: > Hi folks > > Looks like there's something I'm not understanding about date/time queries > on a date field. > > I have a param quer

Re: [GENERAL] recover corrupt DB?

2009-04-23 Thread Milos Babic
Yes. Some things like duplicate primary key can exist in pg_resetxlog-ed db. So, dump db and restore it again on clean initialized cluster. Regards Milos On Thu, Apr 23, 2009 at 8:25 PM, Dan Armbrust < daniel.armbrust.l...@gmail.com> wrote: > > In general, pg_resetxlog would be > > the tool to