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: unrecognized service

Discussion in 'General Discussion' started by onaweb, Jul 25, 2004.

  1. onaweb

    onaweb Well-Known Member

    Joined:
    Jan 1, 2004
    Messages:
    76
    Likes Received:
    0
    Trophy Points:
    6
    Hello,
    I have a client that wishes to use postgres and so I checked postgresql in service manager of whm, updated php to 4.3.8 with postgres which seems fine ('./configure' '--prefix=/usr' '--with-xml' '--enable-bcmath' '--enable-calendar' '--with-curl' '--enable-ftp' '--enable-magic-quotes' '--with-mysql=/usr' '--enable-discard-path' '--with-pear' '--with-pgsql=/usr' '--enable-sockets' '--enable-track-vars' '--enable-versioning' '--with-zlib' ). I added the postgresql to the service monitor but it says it failed. From shell if I do service postgresql start, I get postgresql: unrecognized service error. I also ran /scripts/installpostgres and that appears just fine with no errors. But postgres still not running. If I try /usr/bin/postmaster -D /var/lib/pgsql/data, I get
    LOG: database system shutdown was interrupted at 2004-07-25 14:34:45 CDT
    LOG: checkpoint record is at 0/8B5E80
    LOG: redo record is at 0/8B5E80; undo record is at 0/0; shutdown TRUE
    LOG: next transaction id: 3377; next oid: 25180
    LOG: database system was not properly shut down; automatic recovery in progress
    LOG: ReadRecord: record with zero length at 0/8B5EC0
    LOG: redo is not required
    LOG: database system is ready
    FATAL: invalid length of startup packet
    LOG: smart shutdown request
    LOG: shutting down
    Killed

    What am I missing? It was working at one time until I added php support for postgres.

    Thanks,
    Andy
     
  2. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    What OS is this?
     
  3. onaweb

    onaweb Well-Known Member

    Joined:
    Jan 1, 2004
    Messages:
    76
    Likes Received:
    0
    Trophy Points:
    6
    OS = Red Hat 9
     
  4. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    Hmm. I've never had any problems on RH9. I've seen problems on RHE and Fedora.
    Do you have any databases yet? If not, do
    rm -rf /var/lib/pgsql/data
    /scripts/installpostgres

    After that, go into WHM and set the Postgres password and set up the configuration file.

    Also, make sure you have port 5432 open in your firewall.
     
  5. onaweb

    onaweb Well-Known Member

    Joined:
    Jan 1, 2004
    Messages:
    76
    Likes Received:
    0
    Trophy Points:
    6
    Tried that this is what I get:

    root@dserv [~]# /scripts/installpostgres
    rm: cannot remove `/root/.cpupdates/pingtimes': Is a directory
    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? y
    Using RPM Backend: RPM version 4.2
    Fetching rpm updates list...Done
    Fetching rpm provides list...Done
    Fetching rpm requires list...Done
    Building local rpm provides list...Done
    Building local rpm requires list...Done
    postgresql-server: installed version 7.3.4-1PGDG is up to date, no action needed.
    postgresql: installed version 7.3.4-1PGDG is up to date, no action needed.
    postgresql-devel: installed version 7.3.4-1PGDG is up to date, no action needed.
    error reading information on service postgresql: No such file or directory
    error reading information on service postgresql: No such file or directory
    postgresql: unrecognized service
    postmaster: no process killed
    postmaster: no process killed
    postgresql: unrecognized service
    You should now configure postgresql from WHM!
    You should now configure postgresql from WHM!
    You should now configure postgresql from WHM!
    You should now configure postgresql from WHM!
     
  6. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    Does postgresql appear in WHM? If so, configure it and see what happens.
     
  7. onaweb

    onaweb Well-Known Member

    Joined:
    Jan 1, 2004
    Messages:
    76
    Likes Received:
    0
    Trophy Points:
    6
    I tried that already. And yes it does appear there but it still will not start.
     
  8. onaweb

    onaweb Well-Known Member

    Joined:
    Jan 1, 2004
    Messages:
    76
    Likes Received:
    0
    Trophy Points:
    6
    Does anyone have any ideas as why postgres is not a recognized service? I had it running at one time, but now it won't start.
     
  9. onaweb

    onaweb Well-Known Member

    Joined:
    Jan 1, 2004
    Messages:
    76
    Likes Received:
    0
    Trophy Points:
    6
    Does anyone have any ideas? I really need to get postgres running.
     

Share This Page