469,366 Members | 2,286 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,366 developers. It's quick & easy.

Performance failure / automatic restart / cron ?


I have this notorious problem: at some point pgsql simply hangs up and
requires a restart.

---------------------------------------------------------------------------
-------
homer:/usr/share/doc/postgresql-contrib# /etc/init.d/postgresql restart
Restarting PostgreSQL database: postmaster
Stopped /usr/lib/postgresql/bin/postmaster (pid 14243 14245 14247 14750
14811 1489 15569 15570 15573 15584 15643 15644 15665 15800 15801
15804 15817 15874 16072 20473 20474 20549 20763).
Starting PostgreSQL postmaster.
postmaster successfully started
....
homer:/usr/share/doc/postgresql-contrib#
---------------------------------------------------------------------------
-------

Whenever i restart the server i get a long list of pid's - sometimes its many
lines.

I wrote a little script to restart, vacuum and analyze the database. And
although the script runs, there are no results. i have to restart the db
manualy...
ive seen a post about vacuum an analyze not working from the cron,
unfortunately there was no solution.

Ill be happy with any ideas - in the last week the db required me to have it
restarted once a day which is not very convenient.

I realize my app is very resource hungry but the thing is that it works great
with mysql. The problem occurs only with pgsql which i realy need.

Best regards,
Piotr


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 12 '05 #1
1 1980
Question? Why are you restarting the postmaster? If you're getting a lot of
PIDs that means you have a lot of connections open. What are you doing to
use so many connections? Did you increase the max_connections variable?

Please supply more details of your actual problem. Perhaps a 'ps aux'
output.

Hope this helps,

On Sat, Oct 25, 2003 at 04:57:30PM +0200, Piotr Trawi?ski wrote:

I have this notorious problem: at some point pgsql simply hangs up and
requires a restart.

---------------------------------------------------------------------------
-------
homer:/usr/share/doc/postgresql-contrib# /etc/init.d/postgresql restart
Restarting PostgreSQL database: postmaster
Stopped /usr/lib/postgresql/bin/postmaster (pid 14243 14245 14247 14750
14811 1489 15569 15570 15573 15584 15643 15644 15665 15800 15801
15804 15817 15874 16072 20473 20474 20549 20763).
Starting PostgreSQL postmaster.
postmaster successfully started
...
homer:/usr/share/doc/postgresql-contrib#
---------------------------------------------------------------------------
-------

Whenever i restart the server i get a long list of pid's - sometimes its many
lines.

I wrote a little script to restart, vacuum and analyze the database. And
although the script runs, there are no results. i have to restart the db
manualy...
ive seen a post about vacuum an analyze not working from the cron,
unfortunately there was no solution.

Ill be happy with any ideas - in the last week the db required me to haveit
restarted once a day which is not very convenient.

I realize my app is very resource hungry but the thing is that it works great
with mysql. The problem occurs only with pgsql which i realy need.

Best regards,
Piotr






---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org
--
Martijn van Oosterhout <kl*****@svana.org> http://svana.org/kleptog/ "All that is needed for the forces of evil to triumph is for enough good
men to do nothing." - Edmond Burke
"The penalty good people pay for not being interested in politics is to be
governed by people worse than themselves." - Plato


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE/mpclY5Twig3Ge+YRAiI9AJ98HGe9LY2osNblZ/CljrVN7n0WQQCeIpGB
uLWoQO6XsbENa1WzCG+mIPQ=
=qzHj
-----END PGP SIGNATURE-----

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by David Hickman | last post: by
5 posts views Thread by anr | last post: by
reply views Thread by HJ | last post: by
RedSon
7 posts views Thread by RedSon | last post: by
1 post views Thread by symbioid | last post: by
reply views Thread by =?Utf-8?B?ZmliYw==?= | last post: by
6 posts views Thread by chazzy69 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.