Bypass the DB request - Mailing list pgsql-admin

Hi Team,

Can any one advice me to rectify this error message by postgresql as below?

My Scenario: I had 2 servers with Solaris7. ServerA contains my application where it is connected to a database(pgsql-7.1) on the same server. I had installed the pgsql_8.2.5 on the ServerB of Solaris-9. I need to bypass the DB request of ServerA to the ServerB DB.

My work: I had edited the file “pg_hba.conf” and given the entries under the “# IPv4-style local connections:” section. Then I tried to restart the DB server, I get the following “couldn’t bind the socket” as below. I had changed the IP address of the ServerA ‘s “.odbc” file to point to ServerB. Can any one advice me how to bypass the DB request from one server to other.

$ pg_ctl start -D /db1/postgresql/data -o "-N 20 -B 40 -i"

postmaster successfully started

$ LOG:  could not bind socket for statistics collector: Cannot assign requested address

LOG:  database system was interrupted at 2008-02-14 14:47:39 AST

LOG:  checkpoint record is at 0/1B2F56C8

LOG:  redo record is at 0/1B2F56C8; undo record is at 0/0; shutdown TRUE

LOG:  next transaction ID: 1837; next OID: 3834614

LOG:  database system was not properly shut down; automatic recovery in progress

LOG:  record with zero length at 0/1B2F5708

LOG:  redo is not required

LOG:  database system is ready

$