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