X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B2BCE54085 for ; Tue, 10 May 2005 15:47:01 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 40581-09 for ; Tue, 10 May 2005 18:46:51 +0000 (GMT) Received: from mta10.nationwireless.net (mta10.nationwireless.net [63.163.128.10]) by svr1.postgresql.org (Postfix) with ESMTP id DBA9253795 for ; Tue, 10 May 2005 15:46:47 -0300 (ADT) Received: from jfradkin [63.162.100.127] by mta10.nationwireless.net with ESMTP (SMTPD-8.20) id A1970240; Tue, 10 May 2005 14:46:47 -0400 From: "Joel Fradkin" To: Subject: Many idle processes? Date: Tue, 10 May 2005 14:47:06 -0400 Message-ID: <002401c55590$aa24d7c0$797ba8c0@jfradkin> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0025_01C5556F.231337C0" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.633 tagged_above=0 required=5 tests=AWL, HTML_MESSAGE, MSGID_DOLLARS X-Spam-Level: * X-Archive-Number: 200505/105 X-Sequence-Number: 17534 This is a multi-part message in MIME format. ------=_NextPart_000_0025_01C5556F.231337C0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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. =20 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. =20 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. =20 Joel Fradkin =20 Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 =20 jfradkin@wazagua.com www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. C 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. =20 =20 =20 ------=_NextPart_000_0025_01C5556F.231337C0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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.

 


 

 

------=_NextPart_000_0025_01C5556F.231337C0--