[HACKERS] Kill a Long Running Query

2007-04-25 Thread Mageshwaran
Hi , Any body tell me how to kill a long running query in postgresql, is there any statement to kill a query, and also tell me how to log slow queries to a log file. Regards J Mageshwaran ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary

[HACKERS] POSTGRES WAL

2007-02-28 Thread Mageshwaran
Hi , Is there any method or utility to convert content of WAL files into Human Readable format. Regards J Mageshwaran Andrew Dunstan wrote: Chad Wagner wrote: On 2/26/07, *Josh Berkus* josh@agliodbs.com mailto:josh@agliodbs.com wrote: Just wondering after reading so many

Re: [HACKERS] POSTGRES WAL

2007-02-28 Thread Mageshwaran
Thanks tsunakawa , harris Jonah H. Harris wrote: On 2/28/07, Mageshwaran [EMAIL PROTECTED] wrote: Is there any method or utility to convert content of WAL files into Human Readable format. Not really. The only two WAL utilities available that I know of are Tom's xlogdump and the SoC

Re: [HACKERS] POSTGRES WAL

2007-02-28 Thread Mageshwaran
Hi , I want setup replication for postgres server , please help me on this issue. I dont want to use any third party programs. I like to do it using WAL. Regards J Mageshwaran Mageshwaran wrote: Thanks tsunakawa , harris Jonah H. Harris wrote: On 2/28/07, Mageshwaran [EMAIL

[HACKERS] Postgres Replication

2007-03-01 Thread Mageshwaran
Hi, Some body help me regarding postgres replication, Give me some ideas . Thanks in advance Regards J Mageshwaran ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Limited and is intended for use only by the individual or entity