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.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
