473,385 Members | 1,727 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,385 software developers and data experts.

autovacuum redhat startup

I reconfigured the redhat startup script for postgresql to work with
version 8 and that is working fine.
I thought I could put autovacuum in the startup script and that didn't
cause any problems, but it didn't turn on and I had to start it
manually.

Does anyone know why it didn't catch? I was watching the bootup and it
seemed that the program was actually called. (a screen flew by my eyes
very quickly but since it was the last thing, I didn't see for sure
that it was the autovacuum starting output).

The startup script is in the /etc/rc.d/init.d directory and I put the
autovacuum line after the line echoing that it started. I stopped and
started the script manually and autovacuum did start.

If this can not be accomplished in the same script is there a way to
have it start on server startup?
Thank You
Sim Zacks
IT Manager
CompuLab
04-829-0145 - Office
04-832-5251 - Fax
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 23 '05 #1
0 2473

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Mau | last post by:
Could someone help me find the cnf file so i can turn on the bin log? I can't locate a my.cnf anywhere, but i can find /usr/share/mysql/my-huge.cnf /usr/share/mysql/my-large.cnf...
1
by: Socketd | last post by:
Hi all Will autovacuum both VACUUM and ANALYZE all databases, so that I can delete my script which runs daily: "vacuumdb -a -z"? br socketd (a Postgresql newbie) ps: Please cc to me as I...
1
by: Michael A. Miller | last post by:
I start PostgreSQL in the services utility under Redhat 9.0 with no issues. PostgreSQL runs properly but as soon as I log out PostgreSQL shuts down. It seems that I always need to be logged in for...
4
by: D. Dante Lorenso | last post by:
This isn't entirely PG related, but... Does anyone know what the natural upgrade path from RedHat 9 is? I'm wondering if anyone on the PostgreSQL team is working with redhat to package and...
2
by: Remi | last post by:
Hello, I've installed redhat enterprise 3 on a system to use as a db server. Manually I can install and run postgresql 7.3 (the one on the extras CD). The problem is when you try to add postgres...
3
by: Carlos | last post by:
Hello Forum, I would appreciate it if you could recommend settings to use auto-vacuum in my version 7.4 database. I am uploading several thousands records in the database at a rate of ~1 second...
1
by: Steve Crawford | last post by:
I've been running pg_autovacuum for a week or so, now and while I like it I'm having trouble trusting it. I have several small (~0-50 record) working tables that have high insert/update/delete...
0
by: Sim Zacks | last post by:
I reconfigured the redhat startup script for postgresql to work with version 8 and that is working fine. I thought I could put autovacuum in the startup script and that didn't cause any problems,...
0
by: Assyst | last post by:
Hi All, Nice to come back after a long time o the Scipts Forum , Now Can any body tell me 1 . Steps to sctivate the AUTOVACUUM thread ? 2 . Can we believe the...
0
by: Anna C. Dent | last post by:
srb wrote: $ export DISPLAY=myhost:0.0 and have a functioning X-server on myhost I suspect that LD_LIBRARY_PATH does not contain the directory where libjvm.so resides; such as...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.