[ADMIN] Re: pg_hba.conf problems with Postgresql 7.0.2

2000-10-17 Thread Alexey Rodriguez Yakushev
Hi guys, i have discovered my stupid error. When PostgreSQL 7 is installed it creates a new directory called data in /var/lib/pgsql, but the installation does not erase old configuration files so i edited the old pg_hba.conf instead of the new one in data. I hope this information will be u

Re: [ADMIN] Too many open files in system

2000-10-17 Thread Stephan Szabo
It sounds as if postgres is running into the kernel's system open files limit. What is it set to, and how many backends are running when this starts happening? Stephan Szabo [EMAIL PROTECTED] On Tue, 17 Oct 2000, Toma Vailikit wrote: > I run a pretty heavily visited web site and am using post

[ADMIN] Too many open files in system

2000-10-17 Thread Toma Vailikit
I run a pretty heavily visited web site and am using postgres aa the SQL database on it. I'm beta testing some stuff and after a while Postgres dies like a dog and I get the following entries in the log: FATAL 1: File '/usr/local/pgsql/data/PG_VERSION' does not exist or no read permission. postm

[ADMIN] pltcl, linker and statistical functions

2000-10-17 Thread Michel Decima
Hello, I'm a beginner postgresql admin and I have problems with pltcl on a solaris box. Some users need statistical function (standard deviation, variance) and I know that this feature is not (yet) implemented. I found a piece of Tcl code in the mailing list archive at http://www.