[ADMIN] Postgres client/server connection

2003-11-03 Thread Akhona Damane
Hi I have been trying to connect to the DB from a client maching using PgAdmin III but with error stating "server is not running", while I know the server is running. The server (PostgreSQL 7.3) is running on Linux and the PgAdmin III on the Windows 2000 machine. I did state the server IP addres

[ADMIN] set the per-connection timeout

2003-11-03 Thread Ivaylo Mutafchiev
Hi, I have about 30 tcp-ip user-connections to my pg-server (via odbc). I would like to set some timeout per inactive connection, if possible - means no statements processed per some period. Is that possible and what should I do? I've investigated a bit .conf file, but nothing sounds appropriate t

Re: [ADMIN] Postgres client/server connection

2003-11-03 Thread Thierry Missimilly
You should try to launch postmaster -i or set tcpip_socket to true in postgresql.conf Regards Thierry Missimilly Akhona Damane wrote: > Hi > > I have been trying to connect to the DB from a client maching using > PgAdmin III but with error stating "server is not running", while I know > the serv

[ADMIN] Application monitoring

2003-11-03 Thread Steve Lane
Title: Application monitoring Hi all: We maintain a number of web-based applications that use postgres as the back end. We recently had an unfortunate situation where the hosted server was hacked and the client had some significant downtime. We proposed a custom monitoring app, written in PHP,

Re: [ADMIN] Can I configure to authenticate PGSQL 7.3.4 by LDAP

2003-11-03 Thread Le Ngoc Thach
Dear Peter, I' m a new user of Linux and PostgreSQL, I have used PAM for Linux System, SendMail, but I don't know how to do with PostgreSQL. Please give me where can I get documents about this. Thanks. Thach. Peter Eisentraut wrote: Le Ngoc Thach writes: I'm using Open LDAP in RedHat Linu

Re: [ADMIN] Application monitoring

2003-11-03 Thread Jeff Bohmer
I can't offer info about monitoring for break-ins or other malicious activity. But if you're looking for monitoring a site/database to see that it's up and working properly, there are many, many options. Here's a product I've used to monitor an extremely complex site at a financial company (ex

Re: [ADMIN] Application monitoring

2003-11-03 Thread Steve Crawford
On Monday 03 November 2003 5:19 pm, Steve Lane wrote: > Hi all: > > We maintain a number of web-based applications that use postgres as > the back end > > The client responded that surely this problem of monitoring a > database-backed web app was a known, solved problem, and wanted to > know wh

Re: [ADMIN] Application monitoring

2003-11-03 Thread Jean Huveneers
Hi, I've got experice with monitoring all kinds of serviers/services with Nagios (www.nagios.org). I has some plugins to check webservers, postgresql etc. And is you need any special test, you can write your own plugin (open a webpage and check for a certain string or so). We use i to monitor our