Page 7 of 14 FirstFirst ... 56789 ... LastLast
Results 91 to 105 of 205

Thread: Installing Postgresql - HOWTO

  1. #91
    Registered Member
    Join Date
    Sep 2003
    Location
    Halifax, Nova Scotia
    Posts
    108

    Default

    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?
    Keith Gallant
    JustHosting.ca
    http://www.justhosting.ca

  2. #92
    Registered Member
    Join Date
    Jan 2004
    Posts
    29

    Default Drop DB

    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.

  3. #93
    Registered Member
    Join Date
    Sep 2003
    Location
    Halifax, Nova Scotia
    Posts
    108

    Default

    Can someone give me the command to actually uninstall postgresq?
    Keith Gallant
    JustHosting.ca
    http://www.justhosting.ca

  4. #94
    Registered Member
    Join Date
    Jun 2004
    Location
    Canada
    Posts
    378

    Default

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

    I noticed this thread is old.
    Sheldon King
    Server Adminisrator
    http://www.forgehosting.com

  5. #95
    Registered Member
    Join Date
    Mar 2004
    Posts
    7

    Default Open a new thread on this.

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

  6. #96
    Registered Member
    Join Date
    Jun 2004
    Location
    Canada
    Posts
    378

    Default

    yes I actually need this... ASAP

    Sheldon
    Sheldon King
    Server Adminisrator
    http://www.forgehosting.com

  7. #97
    Registered Member
    Join Date
    Aug 2003
    Posts
    11

    Default Unable to create database or user - solved.

    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.

  8. #98
    Registered Member cPanel Partner NOC Badge gorilla's Avatar
    Join Date
    Feb 2004
    Location
    Sydney / Australia
    Posts
    740

    Thumbs up

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

  9. #99
    Registered Member
    Join Date
    Jun 2004
    Posts
    49

    Default

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

  10. #100
    Registered Member
    Join Date
    Aug 2003
    Posts
    46

    Default

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

  11. #101
    Registered Member
    Join Date
    Sep 2004
    Posts
    422

    Default

    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
    Last edited by DigitalN; 10-07-2004 at 07:18 PM.

  12. #102
    Registered Member
    Join Date
    Oct 2004
    Posts
    19

    Default

    Quote Originally Posted by nlservices
    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?

  13. #103
    Registered Member
    Join Date
    Feb 2004
    Posts
    64

    Default

    Quote Originally Posted by nlservices
    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...

  14. #104
    Registered Member cPanel Partner NOC Badge
    Join Date
    Apr 2002
    Posts
    686
    cPanel/WHM Access Level

    DataCenter Provider

    Default

    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?

  15. #105
    Registered Member casey's Avatar
    Join Date
    Jan 2003
    Location
    If there is trouble, it will find me
    Posts
    2,332

    Default

    Quote Originally Posted by 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?
    You have to do some configuration in /var/lib/pgsql/data/postgresql.conf

Page 7 of 14 FirstFirst ... 56789 ... LastLast

Similar Threads

  1. Installing Postgresql - HOWTO
    By cPanelNick in forum General Discussion
    Replies: 197
    Last Post: 07-19-2010, 01:03 PM
  2. HELP: Howto Upgrade to PostgreSQL 7.4.1/7.4.3 on RHEL
    By Rackster in forum General Discussion
    Replies: 0
    Last Post: 07-05-2004, 10:23 PM
  3. HOWTO: Disable PostGreSQL Link
    By dgbaker in forum General Discussion
    Replies: 0
    Last Post: 03-10-2004, 04:29 PM
  4. HOWTO: Install phpPgAdmin to support Postgresql db's using C
    By ozzi4648 in forum General Discussion
    Replies: 42
    Last Post: 04-09-2003, 06:21 PM
bargain