[GENERAL] PGBouncer Connection Using Perl DBI

Hello ,   Could you please tell me some one ,how to do connection PGBouncer using Perl DBI module ?   Thanks Prashant

[GENERAL] Sequence scan if "OR Condition" in where statement

Hello All Could you please help me , index is not using if have "OR condition in where statement" ? Always have sequence scan. Thanks Prashant

[GENERAL] CPU Load 100% when pg_dump start in Postgresql 8.4

Hello Everyone I facing a big problem ,when pg_dump start .CPU load become 100%. DB Size 35 GB running with e commerce web site. Insert transaction record successfully but Update transaction is not going through. Could you please help to figure out where is the problem ? Thanks Prashant

[GENERAL] ERROR: invalid byte sequence for encoding "UTF8": 0xc325

Hello All Could you help me to automatically convert all db request into UTF8 encode ? Thx Prashant

[GENERAL] Maxium Share Memory in Debian 64bit

Hello All Could you please help to figure out how much maxium memory can allocated in Shared Memory on Debian 64 bit OS ? Thx Prashant

[GENERAL] Tables creation date and time

Hello All Could you please help me to find out of tables creation date and time in database ? Thanks P Bharucha

[GENERAL] Getting Error On pg_dump

Hello All Could you please help me ,Getting error when I try to get backup of database pg_dump: SQL command failed pg_dump: Error message from server: ERROR:  missing chunk number 0 for toast value 87303 in pg_toast_27342 Thx Prashant

Re: [GENERAL] Error On Slony Replication

But Host Address should take automatically, same thing is working good on other machine. --- On Wed, 11/2/11, Raymond O'Donnell wrote: From: Raymond O'Donnell Subject: Re: [GENERAL] Error On Slony Replication To: "Prashant Bharucha" Cc: pgsql-general@postgresql.org

[GENERAL] Error On Slony Replication

Hello All For replication ,Created cluster and after I run Slon command  getting error on PQconnectdb("dbname=XYZ host= user=cls password=1) failed - could not translate host name Could you please help ? Thx Prashant

[GENERAL] problem,after restarting server

Hello I am facing problem,after restarting server ,i could not populate data from tablespace in postgres db using  version 8.4. I am not getting any error . Could you please help ,how to retrieve data ? Thx Prashant