Obsolete Releases > SME 8.x Contribs
PostgreSQL 9.2
(1/1)
newburns:
I am trying to install postgresql 9.2, but I see some pretty important dependencies trying to install, so I haven't gone through with it. Any help is appreciated.
The commands I am issuing are
--- Code: ---db yum_repositories set pgdg9 repository \
Name 'PostgreSQL 9' \
BaseURL 'http://yum.postgresql.org/9.2/redhat/rhel-5-i386' \
GPGCheck yes \
GPGKey file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-92 \
Visible no \
status disabled
--- End code ---
It took quite a while to get that far. From there I issue
--- Code: ---yum --enablerepo=pgdg9 install postgresql
--- End code ---
Which returns
--- Code: ---Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
postgresql92 i386 9.2.3-2PGDG.rhel5 pgdg9 1.6 M
Installing for dependencies:
audit-libs i386 1.8-2.el5 base 80 k
cracklib i386 2.8.9-3.3 base 58 k
libgcrypt i386 1.4.4-5.el5_8.2 base 251 k
libgpg-error i386 1.4-2 base 60 k
libtermcap i386 2.0.8-46.1 base 14 k
libxml2 i386 2.6.26-2.1.21.el5_9.2 updates 798 k
libxslt i386 1.1.17-4.el5_8.3 base 420 k
pam i386 0.99.6.2-12.el5 base 983 k
postgresql92-libs i386 9.2.3-2PGDG.rhel5 pgdg9 217 k
Transaction Summary
================================================================================
Install 10 Package(s)
Upgrade 0 Package(s)
Total download size: 4.4 M
Is this ok [y/N]:
--- End code ---
Initially I see "pam", and that got me scared. So I stopped.
When issuing this command:
--- Code: ---yum --enablerepo=pgdg9 install postgresql92 postgresql92-devel postgresql92-server postgresql92-libs
--- End code ---
Returns
--- Code: ---Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
postgresql92 i386 9.2.3-2PGDG.rhel5 pgdg9 1.6 M
postgresql92-devel i386 9.2.3-2PGDG.rhel5 pgdg9 1.7 M
postgresql92-libs i386 9.2.3-2PGDG.rhel5 pgdg9 217 k
postgresql92-server i386 9.2.3-2PGDG.rhel5 pgdg9 5.5 M
Installing for dependencies:
audit-libs i386 1.8-2.el5 base 80 k
cracklib i386 2.8.9-3.3 base 58 k
libgcrypt i386 1.4.4-5.el5_8.2 base 251 k
libgpg-error i386 1.4-2 base 60 k
libtermcap i386 2.0.8-46.1 base 14 k
libxml2 i386 2.6.26-2.1.21.el5_9.2 updates 798 k
libxslt i386 1.1.17-4.el5_8.3 base 420 k
pam i386 0.99.6.2-12.el5 base 983 k
Transaction Summary
================================================================================
Install 12 Package(s)
Upgrade 0 Package(s)
Total download size: 12 M
Is this ok [y/N]:
--- End code ---
newburns:
I get different results on a Fresh system :lol:
First -->
--- Code: ---wget http://yum.postgresql.org/9.2/redhat/rhel-5-i386/pgdg-redhat92-9.2-7.noarch.rpm
--- End code ---
--- Code: ---yum localinstall pgdg-redhat92-9.2-7.noarch.rpm
--- End code ---
--- Code: ---rm /etc/yum.repos.d/pgdg-92-redhat.repo
--- End code ---
Set new repository
--- Code: ---db yum_repositories set pgdg9 repository \
Name 'PostgreSQL 9' \
BaseURL 'http://yum.postgresql.org/9.2/redhat/rhel-5-i386' \
GPGCheck yes \
GPGKey file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-92 \
Visible no \
Exclude pam \
status disabled
--- End code ---
Must needs install PostgreSQL92 or it will default to install 8.1
--- Code: ---yum --enablerepo=pgdg9 install postgresql92 postgresql92-server postgresql92-libs
--- End code ---
--- Code: ---/etc/init.d/postgresql-9.2 initdb
--- End code ---
--- Code: ---/etc/init.d/postgresql-9.2 start
--- End code ---
--- Code: ---mkdir -p /etc/e-smith/templates/var/lib/pgsql/data
mkdir -p /etc/e-smith/templates-custom/var/lib/pgsql/data
cp /var/lib/pgsql/9.2/data/postgresql.conf /etc/e-smith/templates/var/lib/pgsql/data
cp /var/lib/pgsql/9.2/data/pg_hba.conf /etc/e-smith/templates/var/lib/pgsql/data
cp /var/lib/pgsql/9.2/data/postgresql.conf /etc/e-smith/templates-custom/var/lib/pgsql/data
cp /var/lib/pgsql/9.2/data/pg_hba.conf /etc/e-smith/templates-custom/var/lib/pgsql/data
--- End code ---
Restart Service:
--- Code: ---/etc/init.d/postgresql-9.2 restart
--- End code ---
Login as Postgres:
--- Code: ---su postgres
--- End code ---
Going to change Superuser password:
--- Code: ---psql -U postgres -d template1
--- End code ---
ERROR
--- Code: ---bash: psql: command not found
--- End code ---
Stuck here on a fresh system.
On the other SME 8 system, which have a lot of contribs, it is still trying to install "pam".
Additionally:
--- Code: ---yum --enablerepo=centosplus install postgresql postgresql-contrib postgresql-devel postgresql-docs postgresql-pl postgresql-python postgresql-test
--- End code ---
Returns
--- Code: ---Setting up Install Process
No package postgresql available.
No package postgresql-contrib available.
No package postgresql-devel available.
No package postgresql-docs available.
No package postgresql-pl available.
No package postgresql-python available.
No package postgresql-test available.
Nothing to do
--- End code ---
I'm not sure what else I did, but installing 8.1 is a no-go as well?. Did I mess up my repository somehow? Can I reset repositories in SME?
If either system establishes PostgreSQL 9.2, I would be fine. I'm assuming PostgreSQL does not have to be local in order to be used, similar to MySQL.
newburns:
I found out:
I can't reinstall PostgreSQL 8.1 on the heavily modded system because of the following code:
--- Code: ---db yum_repositories setprop base `db yum_repositories show base | grep -i exclude | awk -F"=" '{print $1" "$2",postgresql*"}'`
db yum_repositories setprop updates `db yum_repositories show updates | grep -i exclude | awk -F"=" '{print $1" "$2",postgresql*"}'`
signal-event yum-modify
--- End code ---
I'm not sure how to revert the code, or even if I want to, but that was taken from
--- Quote from: Stefano on November 09, 2011, 11:34:13 AM ---Re: Need to update postgresql 8.1.15 to 9.0.3 - Please Help
--- End quote ---
newburns:
I can't figure this out. I need PostgreSQL 9.1 or later.
I installed PostgreSQL 8.1 per wiki, not knowing it had to be version 9.1 or later for my application to work.
I proceeded to install 9.2 per the instructions on http://forums.contribs.org/index.php?topic=47374.0
I then proceeded to change the repo information since the instructions listed are outdated.
--- Code: ---db yum_repositories set pgdg9 repository \
Name 'PostgreSQL 9' \
BaseURL 'http://yum.postgresql.org/9.2/redhat/rhel-5-i386' \
GPGCheck yes \
GPGKey file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-92 \
Visible no \
status disabled
--- End code ---
From there, I tried install postgresql and postgresql92 that list installation and dependency for "pam", and installing postgresql-contribs include "uuid" in addition.
Any help at all PLEASE> I can't figure this out. (But I'm trying)
Would installing 9.1 be better?
newburns:
I have reset the "base" and "update" repository.
Reinstalled Postgresql 8.1
Tried
--- Code: ---yum --enablerepo=pgdg9
--- End code ---
--- Code: -----> Finished Dependency Resolution
postgresql91-plpython-9.1.8-2PGDG.rhel5.i386 from pgdg9 has depsolving problems
--> Missing Dependency: libpython2.4.so.1.0 is needed by package postgresql91-plpython-9.1.8-2PGDG.rhel5.i386 (pgdg9)
postgresql91-plperl-9.1.8-2PGDG.rhel5.i386 from pgdg9 has depsolving problems
--> Missing Dependency: libperl.so is needed by package postgresql91-plperl-9.1.8-2PGDG.rhel5.i386 (pgdg9)
Error: Missing Dependency: libperl.so is needed by package postgresql91-plperl-9.1.8-2PGDG.rhel5.i386 (pgdg9)
Error: Missing Dependency: libpython2.4.so.1.0 is needed by package postgresql91-plpython-9.1.8-2PGDG.rhel5.i386 (pgdg9)
--- End code ---
Also, upon
--- Code: ---yum --enablerepo=pgdg9 install postgresql91
--- End code ---
The resulting dependencies seemed to be installed already, with the same versions it is requesting to update.
ie.
--- Code: --- pam i386 0.99.6.2-12.el5 base 983 k
--- End code ---
is already installed
Navigation
[0] Message Index
Go to full version