|
Hi, When I use ecpg code to download File from
database, error occurred occasionally as below: “could
not connect to server: Connection timed out Is the server
running on host "DB" and
accepting TCP/IP connections on port
5432?” This my code:
conn
= PQsetdbLogin(host, NULL, NULL, NULL, database, username, "") ;
if (PQstatus (conn) != CONNECTION_BAD){
PQexec(conn, "BEGIN");
if
(lo_export(conn,oidImage_Data,chImageName) == -1) {
printf("PQSTATUS=%s \n",PQerrorMessage(conn));
PQfinish (conn) ;
printf("EXPORT %s ERROR!
}
printf("PQSTATUS=%s \n",PQstatus(conn));
PQexec(conn, "COMMIT"); This log was found in postgres.log: Oct 18 10:44:35 SUC02
postgres[10159]: [7-1] LOG: database system is ready Oct 18 10:44:35 SUC02
postgres[10159]: [8-1] LOG: transaction ID wrap limit is 3343152371,
limited by database "template1" Oct 18 10:46:11 SUC02
postgres[10997]: [2-1] LOG: unexpected EOF on client connection Oct 18 10:46:11 SUC02
postgres[15899]: [2-1] LOG: could not receive data from client:
Connection reset by peer Oct 18 10:46:11 SUC02
postgres[15899]: [3-1] LOG: unexpected EOF on client connection What is the problem ? What should I investigate ? Please help ! Thank you very much ! Ray Huang |
