Uninstall/delete postgresql

Nathan D.

Well-Known Member
Mar 21, 2004
78
0
156
Virginia
How do I remove postgresql? We don't use it/need it and it keeps trying to restart itself and I don't even want in there in the first place. When I try to uncheck it in the service manager, it doesn't let me; it stays checked.
 

shannon

Well-Known Member
Mar 25, 2002
48
0
306
Yeah, this would be nice to know.. seeing as how when the postgres stuff first started appearing in cPanel I took the time to run through each server and remove it all from the Features List/etc, as we have no intention of using pgres.... yet *somehow*, somewhere along the line cPanel decided to just up and install it for us any way.. out of the kindness of it's heart no doubt. (Which honestly, probably would have never noticed.. if not for the rush of "PostGres Failed!" emails sunday morning.. nothing like an email every 5 minutes... from every server... to get your day started right... ~sigh~)...

Disabled the chkservd entry for it, but how to remove it alltogether?
 

haze

Well-Known Member
Dec 21, 2001
1,540
3
318
rpm -e the installed rpm's for postgre, then remove it from chkdservd. In the /etc/chkserv.d/ folder is a postgres file, remove it, restart chkservd and that should be it.
 

tandyuk

Active Member
Dec 18, 2003
40
15
158
Worthing, UK
cPanel Access Level
DataCenter Provider
It would be nice is cpanel didnt mess with things unless asked to.

I run a manually setup copy of postgres to run GNUworld services.

Since a recent update, chkservd has "checked" postgres every 9 minutes, and shuts it down.

This is getting highly annoying on irc, where ever half hour or so the services netsplit.


Does anyone know how to customise which installation of postgres chkservd checks, and of course how to disable the cpanel installation of postgres without doing anything to the one i want.

I'm still unsure why its even being checked, within cpanel, postgres is disabled, yet within all my customers cpanel's its listed, and of course doesnt work as the cpanel copy of postgres is not installed.

Cpanel guys, PLEASE will you make sure your script at least like asks us before changing **** in the future.


Regards,

James Tandy
TandyUK
 

gfmorris

Member
Jun 6, 2003
20
0
151
Huntsville, AL, USA
haze said:
rpm -e the installed rpm's for postgre, then remove it from chkdservd. In the /etc/chkserv.d/ folder is a postgres file, remove it, restart chkservd and that should be it.
Many, many thanks, Haze. Having just upgraded to 9.7.x and getting stuck with chkserv.d looking for postgres when it wasn't installed, I was pulling my hair out a bit. :)

GFM
 

stuartj

Member
Jul 17, 2003
18
0
151
UK
If you do the following this will remove the main rpm's machines will vary on what they have installed.

[email protected] [/]# rpm -e postgresql-server
[email protected] [/]# rpm -e postgresql-devel
[email protected] [/]# rpm -e postgresql-contrib-7.3.4-11
[email protected] [/]# rpm -e postgresql

then chkserver --del postgresql
delete it completely to make sure
rm -rf /var/run/chkservd/postgresql

service cpanel restart

That should remove it from the box.

I have tested this with FC1 & FC2 & RH9
 

webits

Well-Known Member
May 15, 2004
114
0
166
Postgres

All of a sudden Postgres is over loading my average, I'm sure its that since its the only thing that is running.
 

rsutc

Well-Known Member
Oct 8, 2002
85
0
156
stuartj said:
If you do the following this will remove the main rpm's machines will vary on what they have installed.

[email protected] [/]# rpm -e postgresql-server
[email protected] [/]# rpm -e postgresql-devel
[email protected] [/]# rpm -e postgresql-contrib-7.3.4-11
[email protected] [/]# rpm -e postgresql

then chkserver --del postgresql
delete it completely to make sure
rm -rf /var/run/chkservd/postgresql

service cpanel restart

That should remove it from the box.

I have tested this with FC1 & FC2 & RH9
I tried this only to have whm and cpanel fail. The machine had to be rebooted, but appears to work now, without postgres.

Rick
 

jackie46

BANNED
Jul 25, 2005
536
0
166
Posgresql? Whats that? Not one of our users have ever used it, requested it or sent us a message that they are glad we support it. In fact, if we removed it from every box, nobody would miss it. There must be an EOL for it, if not, its coming.