Re: [HACKERS] POSTGRES WAL
Hi Just to add an question to it.. do we have a felixbitily to run this xlogdump or xlogviewer on windows installation of Postgres. Also how do we run these utilities with the existing postgres server running on linux box. thanks Vishal From: "Jonah H. Harris" <[EMAIL PROTECTED]> To: Mageshwaran <[EMAIL PROTECTED]> CC: "Andrew Dunstan" <[EMAIL PROTECTED]>, "Chad Wagner" <[EMAIL PROTECTED]>, "Josh Berkus" , pgsql-hackers@postgresql.org, [EMAIL PROTECTED] Subject: Re: [HACKERS] POSTGRES WAL Date: Wed, 28 Feb 2007 22:51:22 -0500 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 project based on it called XlogViewer. http://pgfoundry.org/projects/xlogviewer/ -- Jonah H. Harris, Software Architect | phone: 732.331.1324 EnterpriseDB Corporation| fax: 732.331.1301 33 Wood Ave S, 3rd Floor| [EMAIL PROTECTED] Iselin, New Jersey 08830| http://www.enterprisedb.com/ ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate _ Mortgage rates as low as 4.625% - Refinance $150,000 loan for $579 a month. Intro*Terms https://www2.nextag.com/goto.jsp?product=10035&url=%2fst.jsp&tm=y&search=mortgage_text_links_88_h27f6&disc=y&vers=743&s=4056&p=5117 ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] POSTGRES WAL
> 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. This is not the correct list for these kinds of questions. Please try pgsql-general instead. Thanks. -- Josh Berkus PostgreSQL @ Sun San Francisco ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] POSTGRES WAL
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 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 project based on it called XlogViewer. http://pgfoundry.org/projects/xlogviewer/ ** 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 to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail & notify us immediately at [EMAIL PROTECTED] Watch the latest updates on Mumbai, with video coverage of news, events, Bollywood, live darshan from Siddhivinayak temple and more, only on www.mumbailive.in Watch the hottest videos from Bollywood, Fashion, News and more only on www.sifymax.com ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
Re: [HACKERS] POSTGRES WAL
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 project based on it called XlogViewer. http://pgfoundry.org/projects/xlogviewer/ ** 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 to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail & notify us immediately at [EMAIL PROTECTED] Watch the latest updates on Mumbai, with video coverage of news, events, Bollywood, live darshan from Siddhivinayak temple and more, only on www.mumbailive.in Watch the hottest videos from Bollywood, Fashion, News and more only on www.sifymax.com ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] POSTGRES WAL
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 project based on it called XlogViewer. http://pgfoundry.org/projects/xlogviewer/ -- Jonah H. Harris, Software Architect | phone: 732.331.1324 EnterpriseDB Corporation| fax: 732.331.1301 33 Wood Ave S, 3rd Floor| [EMAIL PROTECTED] Iselin, New Jersey 08830| http://www.enterprisedb.com/ ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
Re: [HACKERS] POSTGRES WAL
Is there any method or utility to convert content of WAL files into Human Readable format. xlogdump (or xlog viewer) might help. Sorry, I've never used it yet. http://pgfoundry.org/projects/xlogviewer/ ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match