Topic: PostgreSQL 9.2

[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: [Select]

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

It took quite a while to get that far. From there I issue

Code: [Select]

yum --enablerepo=pgdg9 install postgresql
Which returns

Code: [Select]

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]:

Initially I see "pam", and that got me scared. So I stopped.

When issuing this command:

Code: [Select]

yum --enablerepo=pgdg9 install postgresql92 postgresql92-devel postgresql92-server postgresql92-libs
Returns

Code: [Select]

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]:


[newburns]

I get different results on a Fresh system 

First -->

Code: [Select]

wget http://yum.postgresql.org/9.2/redhat/rhel-5-i386/pgdg-redhat92-9.2-7.noarch.rpm

Code: [Select]

yum localinstall pgdg-redhat92-9.2-7.noarch.rpm

Code: [Select]

rm  /etc/yum.repos.d/pgdg-92-redhat.repoSet new repository

Code: [Select]

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
Must needs install PostgreSQL92 or it will default to install 8.1

Code: [Select]

yum --enablerepo=pgdg9 install postgresql92 postgresql92-server postgresql92-libs

Code: [Select]

/etc/init.d/postgresql-9.2 initdb

Code: [Select]

/etc/init.d/postgresql-9.2 start

Code: [Select]

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
Restart Service:

Code: [Select]

/etc/init.d/postgresql-9.2 restart
Login as Postgres:

Code: [Select]

su postgres
Going to change Superuser password:

Code: [Select]

psql -U postgres -d template1
ERROR

Code: [Select]

bash: psql: command not found
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: [Select]

yum --enablerepo=centosplus install postgresql postgresql-contrib postgresql-devel postgresql-docs postgresql-pl postgresql-python postgresql-test
Returns

Code: [Select]

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
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: [Select]

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-modifyI'm not sure how to revert the code, or even if I want to, but that was taken from

Re: Need to update postgresql 8.1.15 to 9.0.3 - Please Help

[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: [Select]

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 disabledFrom 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: [Select]

yum --enablerepo=pgdg9

Code: [Select]

--> 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)
Also, upon

Code: [Select]

yum --enablerepo=pgdg9 install postgresql91The resulting dependencies seemed to be installed already, with the same versions it is requesting to update.
ie.

Code: [Select]

pam                    i386      0.99.6.2-12.el5            base         983 kis already installed