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
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
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
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)--
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
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
unsubscribe psql-admin
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)---
[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
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])
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
11 matches
Mail list logo