473,287 Members | 1,651 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

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 2184
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: David Hickman | last post by:
Hi all, I have a website that I am building in PHP that I would like to send e-mails to users every 2 days to inform of new updates. I know how to trigger the sending of e-mails if a user...
5
by: anr | last post by:
Hi everyone, I have made a solution where a user is added to the system and a folder is set up for him. In order to make the folder webDAV accessible for him I have to add some lines to the...
3
by: JP SIngh | last post by:
Is there a way to automatically execute code in ASP? I need to send reminders for one my applications and need some suggestions how I can send reminder emails automatically. Many thanks
0
by: HJ | last post by:
The Windows platform provides a mechanism to automatically restart a service when a failure occurs in the 'Recovery' tab in the services panel. It allows you to specify actions on first, second...
2
by: ray | last post by:
I have a client that doesn't want Access to automatically repair into a backup file if it crashes (and it crashes only on very rare occasions). My (sketchy) understanding is that this is a...
7
RedSon
by: RedSon | last post by:
Hi guys, I don't really know anything about cron jobs but I need something that will check to make sure my mysql server is up and running every few minutes or so. Or maybe one that can detect if...
1
by: symbioid | last post by:
Hello, I'm working on a project, and VMware has problems with suspending the virtual machine. We are accessing the machine through samba. However, when I suspend the VM, it stops the Samba...
0
by: =?Utf-8?B?ZmliYw==?= | last post by:
I had to re-install Windows Xp Home Edition. after restart, automatic update informed me that 84 updates did not install. Every time I shut down and later restrt, the same 84 updates are in the...
6
by: chazzy69 | last post by:
Ok two questions- First is it possible to replicate javascripts automatic submit with a php function, i want to do this due to the fact we i run a cron job it wont run javascript. Second If the...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.