[ADMIN] postgres 9.0 - unable to bind to localhost.

Hi all: Getting this error in the postgres logs: 2012-11-29 09:47:39.335 CST - SessionId:50b7839b.4791 - TransId:0 - LOG: could not translate host name localhost, service 5435 to address: Name or service not known 2012-11-29 09:47:39.336 CST - SessionId:50b7839b.4791 - TransId:0 - WARNING:

[ADMIN] Casting bytea to varchar

Hi: I'm relatively new to postgres: I've to alter a column which is of datatype bytea to varchar(255). I used this: ALTER TABLE tablename ALTER COLUMN columname TYPE varchar(255); But I'm really not sure, if the value is casted properly. Is there a way to explicity to cast the value, while

[ADMIN] postgres connections in IDLE state..

Hi all: Our application uses Jboss-hibernate with Postgres as the backend. I'm seeing intermittently - the DB connections getting stale - and not getting returned to the Hibernate session pool. Some of the connections are as old as 9 days. The pg_stat shows the connection as IDLE in the DB.

[ADMIN] pg_stat_activity - proc id

Hi: How to correlate the procpid in pg_stat activity table to any application process? I need to track down some connections to the queries/application threads. Please help!! Regards Jayashree