Koozali.org: home of the SME Server
Obsolete Releases => SME 7.x Contribs => Topic started by: copiamundi on April 06, 2011, 03:18:59 AM
-
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.
-
not tested, should work:
login as root
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
-
I tried twice, and the same error on final : "Cannot find a valid baseurl for repo: pgdg9".
Thanks a lot.
-
sorry, my bad
it should be:
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..
-
sorry, my bad
it should be:
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
-
what's the command you are using?
-
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,
-
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
-
Hi Marco, thank you for the hint
@dexter: let's do it in the SME's way:
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
-
Hi Marco, thank you for the hint
@dexter: let's do it in the SME's way:
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,
-
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
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 (http://wiki.contribs.org/Postgres)
Regards
-
what's the output of
rpm -q --whatrequires postgresql-python
?
-
what's the output of
rpm -q --whatrequires postgresql-python
?
no package requires postgresql-python
-
then
rpm -e postgresql-python
and try again with postgres update via yum
-
then
rpm -e postgresql-python
and try again with postgres update via yum
Tx. It seems to be OK
Updating:
postgresql i386 9.0.0-1PGDG.el4 pgdg9 1.2 M
postgresql-contrib i386 9.0.0-1PGDG.el4 pgdg9 411 k
postgresql-devel i386 9.0.0-1PGDG.el4 pgdg9 1.5 M
postgresql-docs i386 9.0.0-1PGDG.el4 pgdg9 8.7 M
postgresql-libs i386 9.0.0-1PGDG.el4 pgdg9 195 k
postgresql-server i386 9.0.0-1PGDG.el4 pgdg9 4.6 M
postgresql-test i386 9.0.0-1PGDG.el4 pgdg9 1.3 M
Transaction Summary
=============================================================================
Install 3 Package(s)
Update 7 Package(s)
Remove 0 Package(s)
Total download size: 18 M
Is this ok [y/N]:
Exiting on user cancel
[root@sme ~]#
Should I upgrade ?!
-
Should I upgrade ?!
well.. it's up to you :-)
do you must/need to upgrade?
as I said before, read carefully postgres upgrade procedure, as it's not straight-forward (I had some troubles from 8 to 8.4 IIRC)