Hi All, is there an RPM for 4-1 for postgresql? I did a yum, and the latest is only 7-4 Installing: postgresql-server i386 7.4.8-1.RHEL4.1 base 3.0 M and I need at least 8-* Any ideas where to find an RPM for CentOS4-1? Cheers. Mark Sargent.
On Sun, 2006-04-09 at 22:02 +0900, Mark Sargent wrote:> Hi All, > > is there an RPM for 4-1 for postgresql? I did a yum, and the latest is > only 7-4 > > Installing: > postgresql-server i386 7.4.8-1.RHEL4.1 base 3.0 M > > and I need at least 8-* > > Any ideas where to find an RPM for CentOS4-1? >---- you should upgrade your CentOS4 to 4.3 via yum check http://dev.centos.org I think there are rpms for postgresql-8.1 Craig
Mark Sargent wrote:> Hi All, > > is there an RPM for 4-1 for postgresql? I did a yum, and the latest is > only 7-4 > > Installing: > postgresql-server i386 7.4.8-1.RHEL4.1 base 3.0 M > > and I need at least 8-* > > Any ideas where to find an RPM for CentOS4-1? > > Cheers. > > Mark Sargent. > > _______________________________________________ > CentOS mailing list > CentOS at centos.org > http://lists.centos.org/mailman/listinfo/centos > >you can use the www.postgresql.org redhat binaries : http://www.postgresql.org/ftp/binary/v8.1.3/linux/rpms/redhat/rhel-es-4/ if you use php or perl o dovecot or any other dependency to postgresql you must rebuild those rpms with the postgresql 8.1.3 installed and do this every time there's an update for those rebuilded packages leonel
On Sun, 2006-04-09 at 22:02 +0900, Mark Sargent wrote:> Hi All, > > is there an RPM for 4-1 for postgresql? I did a yum, and the latest is > only 7-4 > > Installing: > postgresql-server i386 7.4.8-1.RHEL4.1 base 3.0 M > > and I need at least 8-* > > Any ideas where to find an RPM for CentOS4-1? >There are postgres 8 rpms in the CentOS testing tree. http://lists.centos.org/pipermail/centos-devel/2005-December/002017.html The latest version in there now is: postgresql-server-8.1.2 Thanks, Johnny Hughes -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 189 bytes Desc: This is a digitally signed message part URL: <http://lists.centos.org/pipermail/centos/attachments/20060409/a7531d87/attachment-0001.sig>
Johnny Hughes wrote:>There are postgres 8 rpms in the CentOS testing tree. > >http://lists.centos.org/pipermail/centos-devel/2005-December/002017.html > >The latest version in there now is: > >postgresql-server-8.1.2 >Hi All, I have just tried this with limited success, [racket at ibmlap ~]$ sudo /usr/bin/yum --enablerepo c4-testing install postgresql-8.1.0-4.c4 Setting up Install Process Setting up repositories dag 100% |=========================| 1.1 kB 00:00 c4-testing 100% |=========================| 951 B 00:00 update 100% |=========================| 951 B 00:00 base 100% |=========================| 1.1 kB 00:00 addons 100% |=========================| 951 B 00:00 extras 100% |=========================| 1.1 kB 00:00 Reading repository metadata in from local files primary.xml.gz 100% |=========================| 11 kB 00:00 update : ################################################## 23/23 Added 1 new packages, deleted 0 old in 0.96 seconds primary.xml.gz 100% |=========================| 35 kB 00:00 extras : ################################################## 159/159 Added 26 new packages, deleted 0 old in 2.45 seconds Parsing package install arguments Resolving Dependencies --> Populating transaction set with selected packages. Please wait. ---> Downloading header for postgresql to pack into transaction set. postgresql-8.1.0-4.c4.i38 100% |=========================| 109 kB 00:01 ---> Package postgresql.i386 0:8.1.0-4.c4 set to be updated --> Running transaction check --> Processing Dependency: libpq.so.4 for package: postgresql --> Restarting Dependency Resolution with new changes. --> Populating transaction set with selected packages. Please wait. ---> Package postgresql-libs.i386 0:8.1.2-1.c4 set to be updated --> Running transaction check Dependencies Resolved ============================================================================ Package Arch Version Repository Size ============================================================================Installing: postgresql i386 8.1.0-4.c4 c4-testing 2.7 M Installing for dependencies: postgresql-libs i386 8.1.2-1.c4 c4-testing 178 k Transaction Summary ============================================================================Install 2 Package(s) Update 0 Package(s) Remove 0 Package(s) Total download size: 2.8 M Is this ok [y/N]: y Downloading Packages: (1/2): postgresql-8.1.0-4 100% |=========================| 2.7 MB 00:24 (2/2): postgresql-libs-8. 100% |=========================| 178 kB 00:01 Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction Installing: postgresql-libs ######################### [1/2] Installing: postgresql ######################### [2/2] Installed: postgresql.i386 0:8.1.0-4.c4 Dependency Installed: postgresql-libs.i386 0:8.1.2-1.c4 Complete! Then I did a whereis/which after running updatedb, and was expecting to find pgsql in /usr/local/ or elsewhere, but nothing. [racket at ibmlap ~]$ rpm -qa | grep postgresql* postgresql-8.1.0-4.c4 postgresql-libs-8.1.2-1.c4 [racket at ibmlap usr]$ sudo find / -name postgresql Password: /usr/bin/find: /proc/3991/task: No such file or directory /home/racket/downloads/postgresql [racket at ibmlap pgsql]$ rpm -qi | grep postgresql* rpmq: no arguments given for query Perhaps I'm still doing something fundamentally wrong? Cheers. Mark Sargent.
Message: 19 Date: Sun, 16 Apr 2006 18:38:27 +0900 From: Mark Sargent <powderkeg at snow.email.ne.jp> Subject: Re: [CentOS] RPM for postgresql 8-* for CentOS4? To: CentOS mailing list <centos at centos.org> Message-ID: <44421093.7010403 at snow.email.ne.jp> Content-Type: text/plain; charset=ISO-8859-1; format=flowed> furthermore, I installed postgresql-server and then did another > updatedb and ran rpm -qa and rpm -qi,...> [racket at ibmlap pgsql]$ rpm -qa | grep postgresql* > [racket at ibmlap pgsql]$ > > Sorry, I'm a little lost with this. Cheers. > > Mark Sargent.Try $ rpm -qz postgres* You should be running 8.1.3 which corrects a remote exploit problem: --> # Fix bug that allowed any logged-in user to SET ROLE to any other database user id (CVE-2006-0553) Due to inadequate validity checking, a user could exploit the special case that SET ROLE normally uses to restore the previous role setting after an error. This allowed ordinary users to acquire superuser status, for example. The escalation-of-privilege risk exists only in 8.1.0-8.1.2. However, in all releases back to 7.3 there is a related bug in SET SESSION AUTHORIZATION that allows unprivileged users to crash the server, if it has been compiled with Asserts enabled (which is not the default). Thanks to Akio Ishida for reporting this problem. --> Binaries for RH-EL4 are available through postgresql.org at http://www.postgresql.org/ftp/binary/v8.1.3/linux/rpms/redhat/rhel-es-4/. These work fine on CentOS as far as I can determine. You must install compat-postgresql-libs-3-4.c4.centos to maintain CentOS-4.3 software with dependencies on older versions of PostgeSQL. -- *** e-mail is NOT a secure channel *** James B. Byrne mailto:ByrneJB.<token>@Harte-Lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada L8E 3CE delivery <token> = hal