The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Postgresql Won't work

Discussion in 'General Discussion' started by GOT, Sep 2, 2003.

  1. GOT

    GOT Get Proactive!

    Joined:
    Apr 8, 2003
    Messages:
    902
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Norfolk, VA
    cPanel Access Level:
    DataCenter Provider
    Tried installing postgresql today, and it is not working for some reason:

    root@server2 [/usr/local/apache]# /scripts/installpostgres
    This script will install Postgres 7.3.x or later
    If you have an older version installed you wil need to
    Dump your databases to a file and then restore them
    after the install as 7.3.x is not backwards compatible.
    If you do not have any databases, you can just run:
    mv /var/lib/pgsql /var/lib/pgsql.old
    /sbin/service postgresql stop
    /sbin/service postgresql start
    to force creating a 7.3.x style setup. Do not do this if
    you have databases that you wish to keep!

    Are you sure you wish to proceed? yes
    Fetching rpm updates list...Done
    Fetching rpm provides list...Done
    Fetching rpm requires list...Done
    Building local rpm provides list...Done
    Adding Dependency postgresql (required by postgresql-server)
    postgresql: not installed.
    postgresql-server: not installed.
    Retrieving http://updates.cpanel.net/postgres/v7.3.3/redhat-7.3/postgresql-7.3.3-1PGDG.i386.rpm
    Retrieving http://updates.cpanel.net/postgres/v7.3.3/redhat-7.3/postgresql-server-7.3.3-1PGDG.i386.rpm
    Preparing... ########################################### [100%]
    1:postgresql ########################################### [ 50%]
    2:postgresql-server ########################################### [100%]
    Rebuilding local rpm provides list.....postgresql....postgresql-server..Done
    postgresql: installed version 7.3.3-1PGDG is up to date, no action needed.
    postgresql-devel: not installed.
    Retrieving http://updates.cpanel.net/postgres/v7.3.3/redhat-7.3/postgresql-devel-7.3.3-1PGDG.i386.rpm
    Preparing... ########################################### [100%]
    1:postgresql-devel ########################################### [100%]
    Rebuilding local rpm provides list.....postgresql-devel..Done
    [FAILED]
    postmaster: no process killed
    postmaster: no process killed
    Starting postgresql service: [FAILED]
    root@server2 [/usr/local/apache]#

    I thought I had had this working at one point, but I noticed it was not running today, so I removed all postgresql rpms and tried to start from scratch, but this is what I get.

    Any thoughts?

    cPanel.net Support Ticket Number:
     
    #1 GOT, Sep 2, 2003
  2. mickeymouse

    mickeymouse Well-Known Member

    Joined:
    Sep 16, 2003
    Messages:
    389
    Likes Received:
    0
    Trophy Points:
    166
    RE: Postgresql Won

    Dear GotHosting,

    Check the postmaster\'s log file, or start postmaster service in command prompt to see whether postmaster is installed properly in server and also find out what complaint messages appear.

    If the postgresql got installed and if there is only problem in start up of postmaster service then starting the service in command prompt will help to find the exact error message you get.

    Also, check for any postmaster service already running using ps -aux command if it is running then kill that service before trying reinstallation.

    Regards,

    cPanel.net Support Ticket Number:
     
    #2 mickeymouse, Sep 23, 2003
  3. ahaley

    ahaley Member

    Joined:
    Oct 6, 2003
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    151
    Is Postmaster Running?

    Hi
    This is what I did to get it fixed on my server:

    login to ssh as root:

    mv /var/lib/pgsql /var/lib/pgsql.old

    then run the postgre install again under ssh:

    /scripts/installpostgres

    then log into your WHM admin and click on the Postgre Config and reconfig and then change your password and all should be working.

    Regards
    Andrew Haley
    :cool:

    cPanel.net Support Ticket Number:
     
    #3 ahaley, Oct 7, 2003
(You must log in or sign up to post here.)
Loading...
Similar Threads - Postgresql Won't
  1. Mulyawan Sentosa

    Blind SQL Injection in PostgreSQL

    Mulyawan Sentosa, May 27, 2017, in forum: Security
    Replies:
    3
    Views:
    108
    cPanelKenneth
    May 30, 2017
  2. jimjoe

    How do I see if I have PostgreSQL in easyapache 4

    jimjoe, May 13, 2017, in forum: EasyApache
    Replies:
    1
    Views:
    172
    cPanelJasonT
    May 16, 2017
  3. Oldiesmann

    Cannot manage PostgreSQL DBs/Tables with phpPgAdmin

    Oldiesmann, Dec 29, 2016, in forum: Database Discussions
    Replies:
    5
    Views:
    435
    cPanelMichael
    Jan 23, 2017
  4. andreiev

    Error configuring PostgreSQL Error: PostgreSQL is not running.

    andreiev, Nov 24, 2016, in forum: Database Discussions
    Replies:
    2
    Views:
    925
    cPanelMichael
    Nov 28, 2016
  5. Edmund Ong

    Postgresql Failed despite following documentation

    Edmund Ong, Sep 4, 2016, in forum: Database Discussions
    Replies:
    1
    Views:
    391
    cPanelMichael
    Sep 5, 2016

Share This Page