[ADMIN] Checking Postgres Database

2003-10-07 Thread Ganesan Kanavathy
Title: Message Dear all,   How to check database size for Posgresql db. I need give hardisk utilization of the database on daily basis.   Regards, ganesh

[ADMIN] Pgsql crashes frequently

2003-10-07 Thread Ganesan Kanavathy
Title: Message We are running Postgresql db and it crashes almost every hour Unable to load up pgsql after a crash.   We need to restart the server to start back pg.   What would be the cause of this problem. Please help.   Regards, ganesh    

[ADMIN] t help PostgreSQL server: FATAL 1: S

2003-10-07 Thread Priya G
I saw this error PostgreSQL server: FATAL 1: Sorry, too many clients already in /usr/share/php/phplib/db_pgsql.inc on line 49.   It seems like I have to increase the maximum connections in the postgresql.conf .Is that the right step to fix the problem..Also I am seeing lot of idle processess   Hel

Re: [ADMIN] Checking Postgres Database

2003-10-07 Thread scott.marlowe
On Tue, 7 Oct 2003, Ganesan Kanavathy wrote: > Dear all, > > How to check database size for Posgresql db. I need give hardisk > utilization of the database on daily basis. Here's how I do it: su - postgres cd $PGDATA du -s base ---(end of broadcast)--

Re: [ADMIN] Pgsql crashes frequently

2003-10-07 Thread scott.marlowe
On Tue, 7 Oct 2003, Ganesan Kanavathy wrote: > We are running Postgresql db and it crashes almost every hour Unable to > load up pgsql after a crash. > > We need to restart the server to start back pg. > > What would be the cause of this problem. Please help. Bad hardware. Check for bad mem

Re: [ADMIN] t help PostgreSQL server: FATAL 1: S

2003-10-07 Thread scott.marlowe
On Tue, 7 Oct 2003, Priya G wrote: > I saw this error > PostgreSQL server: FATAL 1: Sorry, too many clients already in > /usr/share/php/phplib/db_pgsql.inc on line 49. >   > It seems like I have to increase the maximum connections in the postgresql.conf .Is > that the > right step to fix the prob

[ADMIN] unsubscribe

2003-10-07 Thread Dylan Milks
unsubscribe psql-admin

[ADMIN] unsubscribe

2003-10-07 Thread AlmawElias Fantahun
unsubscribe psql-admin _ Add MSN 8 Internet Software to your existing Internet access and enjoy patented spam protection and more. Sign up now! http://join.msn.com/?page=dept/byoa ---(end of broadcast)---

Re: [ADMIN] Return last value in of array (PostgreSQL 7.2.1)

2003-10-07 Thread Erwin Brandstetter
[EMAIL PROTECTED] (Joe Conway) wrote in news:[EMAIL PROTECTED]: > http://developer.postgresql.org/docs/postgres/functions-array.html Very good! PostgreSQL 7.4 will provide the functions "array_lower" and "array_upper" doing exactly what I was looking for. Unfortunately I have to implement the

[ADMIN] unsubscribe

2003-10-07 Thread EOsorio
unsubscribe psql-admin ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [ADMIN] Question about DB VACUUM

2003-10-07 Thread Chris White (cjwhite)
Tom, I have found that vacuum only truly gets back all the tuples when there are no other connections to the database. I found I had a connection to the database which was doing nothing, only when I dropped this connection did the vacuum give back all the tuples and reduce the pages to zero, until