Many idle processes? - Mailing list pgsql-admin

From Joel Fradkin
Subject Many idle processes?
Date
Msg-id 002401c55590$aa24d7c0$797ba8c0@jfradkin
Whole thread Raw
Responses Re: Many idle processes?
List pgsql-admin

I just went live yesterday and I can see many idle processes on my redhat AS4 running postgres 8.0.2

Is this something I should be worried about?

Being a newb to Linux and somewhat to postgres I need to add the vacuum and backup scenario.

Josh from Commandpromt gave me some syntax, so I am wondering about how often I should vacuum ?

An example of cron setting would be perfect.

I may run the backup from a different server.

 

Also I am experiencing an issue with French text not appearing correctly on the web site.

We did not have this issue in testing and even now when we hook up to a test server locally (running windows) the French text appears ok in a test of our app running on a desk top.

 

In production I have windows 2000 for my IIS server and the Linux box for Data. Any ideas how to fix up my French the database itself is SQL_ASCHII.

 

Joel Fradkin

 

Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida 34243
Tel.  941-753-7111 ext 305

 

jfradkin@wazagua.com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced tools.
© 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc
 This email message is for the use of the intended recipient(s) and may contain confidential and privileged information.  Any unauthorized review, use, disclosure or distribution is prohibited.  If you are not the intended recipient, please contact the sender by reply email and delete and destroy all copies of the original message, including attachments.

 


 

 

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_toast_xxxxxx_index is not a btree error
Next
From: "Dave Held"
Date:
Subject: Irrevocable privileges