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

[copiamundi]

  I need to update from Postgresql 8.1.15 to 9.0.3. i need help with that, like a tutorial or something.
 I used this how to: http://wiki.contribs.org/Postgres, and was perfect, it works, but need to be 9.0.3.
  I am new in SME, and I need help with that.
 
Thanks.

[Stefano]

not tested, should work:

login as root

Code: [Select]

mkdir pgdg
cd pgdg
wget http://yum.pgsqlrpms.org/reporpms/9.0/pgdg-redhat-9.0-2.noarch.rpm
yum localinstall pgdg-redhat-9.0-2.noarch.rpm
rm  /etc/yum.repos.d/pgdg-90-redhat.repo

db yum_repositories set pgdg9 repository \
 BaseURL http://yum.pgsqlrpms.org/9.0/redhat/rhel-4-i386 \
 GPGCheck yes \
 GPGKey file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG \
 Name Postgresql 9.0 \
 Visible no \
 status disabled

signal-event yum-modify

yum --enablerepo=pgdg9 update

please read PG documentation as the upgrade maybe not straight forward

HTH

[copiamundi]

 
 I tried twice, and the same error on final : "Cannot find a valid baseurl for repo: pgdg9".
 
   Thanks a lot.

[Stefano]

sorry, my bad

it should be:

Code: [Select]

db yum_repositories set pgdg9 repository \
 BaseURL http://yum.pgsqlrpms.org/9.0/redhat/rhel-4-i386 \
 GPGCheck yes \
 GPGKey file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG \
 Name 'Postgresql 9.0' \
 Visible no \
 status disabled

I forgot to quote the name

try again, let us know..

[dexter]

sorry, my bad

it should be:

Code: [Select]

db yum_repositories set pgdg9 repository \
 BaseURL http://yum.pgsqlrpms.org/9.0/redhat/rhel-4-i386 \
 GPGCheck yes \
 GPGKey file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG \
 Name 'Postgresql 9.0' \
 Visible no \
 status disabled

I forgot to quote the name

try again, let us know..

I've tryed. It goes well until:

"Missing Dependency: libpq.so.4 is needed by package postgresql-python"

Can you help?

Regards,

Andrej

[Stefano]

what's the command you are using?

[dexter]

what's the command you are using?

1. I've localy instal rpm
2. Add repository for postgres as you stated in second "corrected" post
3. Run "signal-event yum-modify"
4. Run "yum --enablerepo=pgdg9 update"

and with this update I get an error:

"Missing Dependency: libpq.so.4 is needed by package postgresql-python"

Regards,

[cmarco]

Hi everyone, I'm quiet new with SME but I've made some install of Postgres on CentOS.

Googling around I've found this note (taken from http://davidghedini.blogspot.com/2010/10/install-postgresql-9-on-centos.html)

[snip] ... edit CentOS-Base.repo and add 'exclude=postgresql*'  to the [base] and [updates] sections: [snip]

Now I don't know if you can directly modifiy the file or not, maybe Stefano could step in 

HTH

Marco

[Stefano]

Hi Marco, thank you for the hint

@dexter: let's do it in the SME's way:

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-modify
yum --enablerepo=pgdg9 update

not tested, should work, let us know, thank you

[dexter]

Hi Marco, thank you for the hint

@dexter: let's do it in the SME's way:

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-modify
yum --enablerepo=pgdg9 update

not tested, should work, let us know, thank you

Marco Tx, for RE. Here is what I get after I was following your instructions:

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
yum --enablerepo=pgdg9 update


[root@sme ~]# yum --enablerepo=pgdg9 update
Loading "protect-packages" plugin
Loading "fastestmirror" plugin
Loading "installonlyn" plugin
Loading "smeserver" plugin
Setting up Update Process
Setting up repositories
pgdg9                     100% |=========================| 1.9 kB    00:00
Loading mirror speeds from cached hostfile
Reading repository metadata in from local files
Excluding Packages from CentOS - os
Finished
Excluding Packages from CentOS - updates
Finished
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package postgresql-test.i386 0:9.0.0-1PGDG.el4 set to be updated
---> Package postgresql.i386 0:9.0.0-1PGDG.el4 set to be updated
---> Package postgresql-libs.i386 0:9.0.0-1PGDG.el4 set to be updated
---> Package postgresql-server.i386 0:9.0.0-1PGDG.el4 set to be updated
---> Package postgresql-devel.i386 0:9.0.0-1PGDG.el4 set to be updated
---> Package postgresql-plpython.i386 0:9.0.0-1PGDG.el4 set to be updated
---> Package postgresql-docs.i386 0:9.0.0-1PGDG.el4 set to be updated
---> Package postgresql-plperl.i386 0:9.0.0-1PGDG.el4 set to be updated
---> Package postgresql-pltcl.i386 0:9.0.0-1PGDG.el4 set to be updated
---> Package postgresql-contrib.i386 0:9.0.0-1PGDG.el4 set to be updated
--> Running transaction check
--> Processing Dependency: libpq.so.4 for package: postgresql-python
--> Finished Dependency Resolution
Error: Missing Dependency: libpq.so.4 is needed by package postgresql-python
[root@sme ~]#

Regards,

[Stefano]

dexter

is your SME 7.5.1 or 8.b6?
do you have already installed postgres on your server? if so, what version are you running at the moment?

[dexter]

dexter

is your SME 7.5.1 or 8.b6?
do you have already installed postgres on your server? if so, what version are you running at the moment?

SME 7.5.1

Yes I am running PG 8. Installed as you can read here: http://wiki.contribs.org/Postgres

Regards

[Stefano]

what's the output of

Code: [Select]

rpm -q --whatrequires postgresql-python
?

[dexter]

what's the output of

Code: [Select]

rpm -q --whatrequires postgresql-python
?

no package requires postgresql-python

[Stefano]

then

Code: [Select]

rpm -e postgresql-python

and try again with postgres update via yum