Re: Postgres perfornace problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Try to track down the problem through gatekeeper/radius/pgsql logs/
top utility.
You may also try to run vacuum or vacuum analyze every a few hours through cron.
BTW There should be no need to REINDEX tables everyday.

----- Original Message ----- From: "Steve Smith" <steve_smith_ss@xxxxxxxxx>
Sent: Saturday, May 28, 2005 5:47 AM


I am using gnugk 2.2.2 (routed mode -No proxy )with
SqlBIll. The systems has been running smoothly for few
weeks but since yesterday I am getting
"Error: rlm_sql_postgresql: PostgreSQL Query failed
Error:"    on radius.log every 3-4 hours and the
systems stops responding to Auth requsts till reboot.

I am doing Reindexing and vacuuming on DB everyday.

The system handles about 15 concurrent calls maximum.
The machine i am using is PIII PC with 256MB RAM.
I am using the Downloaded binary of 2.2.2 from
gnugk.org.
Can it be a resource issue in the Machine?
Do i need to compile the source and build.?

Can anyone advise me ?

Thanks in advance

Steve



-------------------------------------------------------
This SF.Net email is sponsored by Yahoo.
Introducing Yahoo! Search Developer Network - Create apps using Yahoo!
Search APIs Find out how you can build Yahoo! directly into your own
Applications - visit http://developer.yahoo.net/?fr=offad-ysdn-ostg-q22005
_______________________________________________________

Posting: mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx
Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549
Unsubscribe: http://lists.sourceforge.net/lists/listinfo/openh323gk-users
Homepage: http://www.gnugk.org/

[Index of Archives]     [SIP]     [Open H.323]     [Gnu Gatekeeper]     [Asterisk PBX]     [ISDN Cause Codes]     [Yosemite News]

  Powered by Linux