Re: HA solution

http://wiki.postgresql.org/wiki/Streaming_Replication

I have gone through the above link. Current streaming replication provides Asynchronous based solution & synchronous solution will come with version 9.1

Can some one please give me an approximate idea when version 9.1 will be release?

--

Thanks & Regards
Dhaval Jaiswal

________________________________

From: Adrian Klaver [mailto:adrian(dot)klaver(at)gmail(dot)com]
Sent: Mon 1/17/2011 1:41 AM
To: pgsql-general(at)postgresql(dot)org
Cc: Jaiswal Dhaval Sudhirkumar; John R Pierce
Subject: Re: [GENERAL] HA solution

On Sunday 16 January 2011 7:19:49 am Jaiswal Dhaval Sudhirkumar wrote:
> Thanks for your great comments.
>
> I have gone through suggested link & the streaming replication with 9.0+.
> (We are using PostgreSQL 8.4. Not to worry I will migrate it to 9.0+)
>
> It seems to me that if i will go with this Active/Hot stand by(stream)
> architecture, I can generate the report from my standby database; which is
> in readable mode. Isn't it?

Yes.

>
> Can i take the dump from my standby database through pg_dump?

See here for answer and a suggestion:
http://archives.postgresql.org/pgsql-general/2010-07/msg00767.php

>
> Is this standby comfortable with Big datatypes like (BLOB, CLOB, GIS, etc.)
> & partitioning table?

The built-in replication works at the binary level and ships whatever happens on
A to B. For a more in depth look see this Wiki page:

http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial#What_Can_You_Do_With_Binary_Replication.3F
>
>
> --
> Thanks & Regards
> Dhaval Jaiswal
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.
Any review, re-transmission, dissemination or other use of or taking of any action in reliance upon,this information by persons or entities other than the intended recipient is prohibited.
If you received this in error, please contact the sender and delete the material from your computer.
Microland takes all reasonable steps to ensure that its electronic communications are free from viruses.
However, given Internet accessibility, the Company cannot accept liability for any virus introduced by this e-mail or any attachment and you are advised to use up-to-date virus checking software.