Installing Postgresql - HOWTO

[justhost]

How do you remove PostgreSQL ? I had installed it for a client but they decided against using it. I have no reason to leave it running so to lighten the load I figure I should remove it.

Anyone?

[BigBamboo]

To drop a Postgre Database (as it doesn't seem to work through phpPgAdmin):

run the following command in a shell:
dropdb -U postgreusername databasename

To drop a database you have to do it as the user associated with that database: that's where the -U comes in handy as even if you're root you can't delete a users db just doing a dropdb databasename.

[justhost]

Can someone give me the command to actually uninstall postgresq?

[Sheldon]

could we get a whole updated tutorial with the latest cpanel ...

I noticed this thread is old.

[Rackster]

This thread is old. Need the latest updates on cPanel 9.4.1 and PostgreSQL 7.4.3.

[Sheldon]

yes I actually need this... ASAP

Sheldon

[ajralston]

I was runing into the same issue where I could not create a user or a database after the install. The issue was that I was logged in as Root on another browser window. Once I opened a different browser (IE) and relogged in as the user I was able to create the user and database.

[gorilla]

Just wanted to say THANKS !
That was a great tutorial and got postgesql running within minutes !

[Cash]

May I know how to uninstall my Postgresql and re-install again?

[scapeweb]

I have the same question? Cause I am still getting the fail message

[DigitalN]

To uninstall postgresql the following should work for you.

/sbin/service postgresql stop

rpm -qa | grep postgres | xargs rpm -e

or

rpm -qa | grep postgres

and uninstall the rpms that are listed - rpm -e postgresql postgresql-devel etc etc

Remove the /var/lib/pgsql directory

rm -rf /var/lib/pgsql (Only if you don't have databases that you want to keep !)

Remove the chkservd file if it exists (to stop cpanel sending fail messages out.)

rm -f /etc/chkserv.d/postgres or /etc/chkserv.d/postgresql

/etc/init.d/chkservd restart

[wfwh]

I got mine installed. It shows up in WHM, and I followed the password change steps as outlined.

In cPanel, it allows me to create a database and user.

However, phppgAdmin give this error message:

Warning: open(/tmp/sess_0b936145dfc77fcf7f490f82a874bf93, O_RDWR) failed: Permission denied (13) in /usr/local/cpanel/base/3rdparty/phpPgAdmin/libraries/lib.inc.php on line 74

And when I try to login to phppgAdmin, I get these errors:

Warning: open(/tmp/sess_0b936145dfc77fcf7f490f82a874bf93, O_RDWR) failed: Permission denied (13) in /usr/local/cpanel/base/3rdparty/phpPgAdmin/libraries/lib.inc.php on line 74

Warning: open(/tmp/sess_0b936145dfc77fcf7f490f82a874bf93, O_RDWR) failed: Permission denied (13) in Unknown on line 0

Warning: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp) in Unknown on line 0

What do I do to fix these errors?

Help...

cPanel.net Support Ticket Number:

I HAVE THESE SAME ERRORS, any help?

[Stream]

I got mine installed. It shows up in WHM, and I followed the password change steps as outlined.

In cPanel, it allows me to create a database and user.

However, phppgAdmin give this error message:

Warning: open(/tmp/sess_0b936145dfc77fcf7f490f82a874bf93, O_RDWR) failed: Permission denied (13) in /usr/local/cpanel/base/3rdparty/phpPgAdmin/libraries/lib.inc.php on line 74

And when I try to login to phppgAdmin, I get these errors:

Warning: open(/tmp/sess_0b936145dfc77fcf7f490f82a874bf93, O_RDWR) failed: Permission denied (13) in /usr/local/cpanel/base/3rdparty/phpPgAdmin/libraries/lib.inc.php on line 74

Warning: open(/tmp/sess_0b936145dfc77fcf7f490f82a874bf93, O_RDWR) failed: Permission denied (13) in Unknown on line 0

Warning: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp) in Unknown on line 0

What do I do to fix these errors?

Help...

cPanel.net Support Ticket Number:

I did the following to get it working:

1. Open for editing: /usr/local/cpanel/base/3rdparty/phpPgAdmin/libraries/lib.inc.php
2. Find: session_name('PPA_ID');
(just below if (!ini_get('session.auto_start')) { )
3. Replace with: session_name('SESS_ID');
4. Save file and refresh the browserwindow with phpPgAdmin -> No errors

This did it for me, hope it can help others too...

[Snowman30]

Im wondering if someone can tell me how to setup remote access to Postgres???

I want to monitor it in my remote monitoring system but for the life of me cant get it to come up..

Im monitoring port 5432 is that correct?

[casey]

Im wondering if someone can tell me how to setup remote access to Postgres???

I want to monitor it in my remote monitoring system but for the life of me cant get it to come up..

Im monitoring port 5432 is that correct?

You have to do some configuration in /var/lib/pgsql/data/postgresql.conf