Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

PostgreSQL Install Problems

Discussion in 'General Discussion' started by Starcraftmazter, Jul 13, 2007.

  1. Starcraftmazter

    Starcraftmazter Well-Known Member

    May 5, 2006
    Likes Received:
    Trophy Points:
    [root@tesla ~]# /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
    Loading "installonlyn" plugin
    Setting up Install Process
    Setting up repositories
    base                      100% |=========================| 1.1 kB    00:00     
    updates                   100% |=========================|  951 B    00:00     
    addons                    100% |=========================|  951 B    00:00     
    extras                    100% |=========================| 1.1 kB    00:00     
    Reading repository metadata in from local files
    updates   : ################################################## 561/561
    Traceback (most recent call last):
      File "/usr/bin/yum", line 29, in ?
      File "/usr/share/yum-cli/", line 94, in main
        result, resultmsgs = base.doCommands()
      File "/usr/share/yum-cli/", line 381, in doCommands
        return self.yum_cli_commands[self.basecmd].doCommand(self, self.basecmd, self.extcmds)
      File "/usr/share/yum-cli/", line 134, in doCommand
        return base.installPkgs(extcmds)
      File "/usr/share/yum-cli/", line 539, in installPkgs
      File "/usr/share/yum-cli/", line 109, in doRepoSetup
      File "/usr/lib/python2.4/site-packages/yum/", line 338, in doSackSetup
      File "/usr/lib/python2.4/site-packages/yum/", line 200, in populateSack
        sack.populate(repo, with, callback, cacheonly)
      File "/usr/lib/python2.4/site-packages/yum/", line 91, in populate
        dobj = repo.cacheHandler.getPrimary(xml, csum)
      File "/usr/lib/python2.4/site-packages/yum/", line 100, in getPrimary
        return self._getbase(location, checksum, 'primary')
      File "/usr/lib/python2.4/site-packages/yum/", line 93, in _getbase
        self.updateSqliteCache(db, parser, checksum, metadatatype)
      File "/usr/lib/python2.4/site-packages/yum/", line 382, in updateSqliteCache
        cur.execute("DELETE FROM "+table+ " where pkgKey in %s" % delpkgs)
      File "/usr/lib64/python2.4/site-packages/sqlite/", line 244, in execute = self.con.db.execute(SQL)
    [B][COLOR="Red"]_sqlite.DatabaseError: unable to open database file
    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[/COLOR][/B]
    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!
    I had a thorough search on the forum, and maybe it's because I have these PostgreSQL packages installed?

    [root@tesla ~]# rpm -qa | grep postgres
    However when I try to remove them, I get the multiple selection error. When I use allmatches this is what happens:

    [root@tesla ~]# rpm -e --allmatches postgresql-libs-8.1.9-1.el5
    error: Failed dependencies:
   is needed by (installed) apr-util-1.2.7-6.x86_64
   is needed by (installed) apr-util-1.2.7-6.i386
    And the other 2 packages have even more...

    [root@tesla ~]# rpm -e apr-util-1.2.7-6.x86_64 apr-util-1.2.7-6.i386
    error: Failed dependencies:
   is needed by (installed) httpd-2.2.3-7.el5.centos.x86_64
   is needed by (installed) apr-util-devel-1.2.7-6.x86_64
   is needed by (installed) mod_perl-2.0.2-6.3.el5.x86_64
            apr-util = 1.2.7-6 is needed by (installed) apr-util-devel-1.2.7-6.i386
            apr-util = 1.2.7-6 is needed by (installed) apr-util-devel-1.2.7-6.x86_64
   is needed by (installed) apr-util-devel-1.2.7-6.i386

    Any thoughts?
    I'm running CentOS 5x64, WHM 11.2 (CURRENT)
  2. katmai

    katmai Well-Known Member

    Mar 13, 2006
    Likes Received:
    Trophy Points:
    Brno, Czech Republic
    i think i can help you with installing the postgres. i usually do it manually, as the cpanel scripts for postgres bum me each time i try, so i just do it old fashion. pm me if you need help.
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice