Re: [ADMIN] URGENT PROBLEM: connection time-outs of postgresql backend/frontend
On Thu, 29 Jun 2000, stanislas pinte wrote: > hello, > > I posted several questions in the mailing list "general", and received no > response. I think that it is not documented where to manage the > connection time-out as far as TCP/IP connections are concerned. > > My problem is the following: using a JDBC client, and long-lived > connections, I see my connections being timed-out by the postmaster after > having been idle for a given time. How could I modify the time-out time? > > Could the postgresql dev team answer this? > Now it is not possible, but I have in my private TODO oracle's CREATE PROFILE with connection idle time etc. But it is far future... (7.2/3?). Karel
[ADMIN] URGENT PROBLEM: connection time-outs of postgresql backend/frontend
hello, I posted several questions in the mailing list "general", and received no response. I think that it is not documented where to manage the connection time-out as far as TCP/IP connections are concerned. My problem is the following: using a JDBC client, and long-lived connections, I see my connections being timed-out by the postmaster after having been idle for a given time. How could I modify the time-out time? Could the postgresql dev team answer this? thanks a lot, Stan. Trademine corp.
Re: [ADMIN] Exporting database
At 17:01 2000-06-26 +0530, Anupam Sanghera wrote: > >How can I export a postgres database to another server ? > Put the data into a file like this: psql -D dbname dbname.dump.gz Then copy the file to the new machine and do this: createdb dbname psql dbname < dbname.dump Tony -- Anthony E. Greene <[EMAIL PROTECTED]> PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26 C484 A42A 60DD 6C94 239D Linux: The choice of a GNU Generation.
[ADMIN] problem in pg_hba.conf file
I m getting the following error message when i try to get a connection through a jsp file. "Something unusual has occured to cause the driver to fail. Please report this exception: java.sql.SQLException: No pg_hba.conf entry for host 161.58.235.51, user ticket, database theatick " where '161.58.235.51' is the ip address of my server and theatick is the database name and tikcet is the user Id for that database whereas pg_hpa.conf file contain two (by default) entries local all trust host all 127.0.0.1 255.255.255.255 trust is there anything else required in pg_hba.conf or what Irfan Qaiser
