Re: [HACKERS] POSTGRES WAL

2007-03-01 Thread Vishal Arora

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

2007-02-28 Thread Josh Berkus

> 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

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 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

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 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

2007-02-28 Thread Jonah H. Harris

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

2007-02-28 Thread Takayuki Tsunakawa
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