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 Install Problems

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

  1. Starcraftmazter

    Starcraftmazter Well-Known Member

    Joined:
    May 5, 2006
    Messages:
    47
    Likes Received:
    0
    Trophy Points:
    6
    Code:
    [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 ?
        yummain.main(sys.argv[1:])
      File "/usr/share/yum-cli/yummain.py", line 94, in main
        result, resultmsgs = base.doCommands()
      File "/usr/share/yum-cli/cli.py", line 381, in doCommands
        return self.yum_cli_commands[self.basecmd].doCommand(self, self.basecmd, self.extcmds)
      File "/usr/share/yum-cli/yumcommands.py", line 134, in doCommand
        return base.installPkgs(extcmds)
      File "/usr/share/yum-cli/cli.py", line 539, in installPkgs
        self.doRepoSetup()
      File "/usr/share/yum-cli/cli.py", line 109, in doRepoSetup
        self.doSackSetup(thisrepo=thisrepo)
      File "/usr/lib/python2.4/site-packages/yum/__init__.py", line 338, in doSackSetup
        self.repos.populateSack(which=repos)
      File "/usr/lib/python2.4/site-packages/yum/repos.py", line 200, in populateSack
        sack.populate(repo, with, callback, cacheonly)
      File "/usr/lib/python2.4/site-packages/yum/yumRepo.py", line 91, in populate
        dobj = repo.cacheHandler.getPrimary(xml, csum)
      File "/usr/lib/python2.4/site-packages/yum/sqlitecache.py", line 100, in getPrimary
        return self._getbase(location, checksum, 'primary')
      File "/usr/lib/python2.4/site-packages/yum/sqlitecache.py", line 93, in _getbase
        self.updateSqliteCache(db, parser, checksum, metadatatype)
      File "/usr/lib/python2.4/site-packages/yum/sqlitecache.py", line 382, in updateSqliteCache
        cur.execute("DELETE FROM "+table+ " where pkgKey in %s" % delpkgs)
      File "/usr/lib64/python2.4/site-packages/sqlite/main.py", line 244, in execute
        self.rs = 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?

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

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

    Code:
    [root@tesla ~]# rpm -e apr-util-1.2.7-6.x86_64 apr-util-1.2.7-6.i386
    error: Failed dependencies:
            libaprutil-1.so.0()(64bit) is needed by (installed) httpd-2.2.3-7.el5.centos.x86_64
            libaprutil-1.so.0()(64bit) is needed by (installed) apr-util-devel-1.2.7-6.x86_64
            libaprutil-1.so.0()(64bit) 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
            libaprutil-1.so.0 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

    Joined:
    Mar 13, 2006
    Messages:
    526
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    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.
     
Loading...

Share This Page