Re: [CentOS] RPM for postgresql 8-* for CentOS4?

Hi All,

furthermore, I installed postgresql-server and then did another updatedb and ran rpm -qa and rpm -qi,

[racket@ibmlap pgsql]$ sudo /usr/bin/yum --enablerepo c4-testing install postgresql-server 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 Parsing package install arguments Resolving Dependencies --> Populating transaction set with selected packages. Please wait. ---> Downloading header for postgresql-server to pack into transaction set. postgresql-server-8.1.2-1 100% |=========================| 84 kB 00:01 ---> Package postgresql-server.i386 0:8.1.2-1.c4 set to be updated --> Running transaction check --> Processing Dependency: postgresql = 8.1.2-1.c4 for package: postgresql-server --> Restarting Dependency Resolution with new changes. --> Populating transaction set with selected packages. Please wait. ---> Package postgresql.i386 0:8.1.2-1.c4 set to be updated --> Running transaction check

Dependencies Resolved

============================================================================= Package Arch Version Repository Size ============================================================================= Installing: postgresql-server i386 8.1.2-1.c4 c4-testing 3.8 M Updating for dependencies: postgresql i386 8.1.2-1.c4 c4-testing 2.7 M

Transaction Summary ============================================================================= Install 1 Package(s) Update 1 Package(s) Remove 0 Package(s) Total download size: 6.5 M Is this ok [y/N]: y Downloading Packages: (1/2): postgresql-8.1.2-1 100% |=========================| 2.7 MB 00:16 (2/2): postgresql-server- 100% |=========================| 3.8 MB 00:18 Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction Updating : postgresql ######################### [1/3] Installing: postgresql-server ######################### [2/3] Cleanup : postgresql ######################### [3/3]

Installed: postgresql-server.i386 0:8.1.2-1.c4 Dependency Updated: postgresql.i386 0:8.1.2-1.c4 Complete! [racket@ibmlap pgsql]$ sudo updatedb Password:

[racket@ibmlap pgsql]$ whereis pgsql pgsql: /usr/lib/pgsql /usr/share/pgsql

[racket@ibmlap pgsql]$ cd /usr/share/pgsql

[racket@ibmlap pgsql]$ ls conversion_create.sql pg_service.conf.sample psqlrc.sample timezone information_schema.sql postgres.bki recovery.conf.sample pg_hba.conf.sample postgres.description sql_features.txt pg_ident.conf.sample postgresql.conf.sample system_views.sql

[racket@ibmlap pgsql]$ whereis postgresql postgresql:

[racket@ibmlap pgsql]$ which pgsql /usr/bin/which: no pgsql in (/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/usr/lib/jre/bin:/home/racket/bin:/home/racket/downloads/skype/skype-1.2.0.18:/usr/local/mysql/bin:/home/racket/bin:/home/racket/downloads/skype/skype-1.2.0.18/skype:/home/racket/bin:/home/racket/downloads/skype/skype-1.2.0.18:/usr/local/mysql/bin:/usr/lib/jre/bin)

[racket@ibmlap pgsql]$ which postgresql /usr/bin/which: no postgresql in (/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/usr/lib/jre/bin:/home/racket/bin:/home/racket/downloads/skype/skype-1.2.0.18:/usr/local/mysql/bin:/home/racket/bin:/home/racket/downloads/skype/skype-1.2.0.18/skype:/home/racket/bin:/home/racket/downloads/skype/skype-1.2.0.18:/usr/local/mysql/bin:/usr/lib/jre/bin)

[racket@ibmlap pgsql]$ rpm -qa | grep postgresql*

[racket@ibmlap pgsql]$ rpm -qi postgresql Name : postgresql Relocations: (not relocatable) Version : 8.1.2 Vendor: CentOS Release : 1.c4 Build Date: Thu 26 Jan 2006 06:47:30 AM JST Install Date: Sun 16 Apr 2006 06:08:42 PM JST Build Host: insanity.cognitive-dissonance.org Group : Applications/Databases Source RPM: postgresql-8.1.2-1.c4.src.rpm Size : 10486980 License: BSD Signature : DSA/SHA1, Thu 26 Jan 2006 08:32:24 AM JST, Key ID 5c37c0b17203f491Packager : Jim Perrin jperrin@centos.org URL : http://www.postgresql.org/ Summary : PostgreSQL client programs and libraries. Description : PostgreSQL is an advanced Object-Relational database management system (DBMS) that supports almost all SQL constructs (including transactions, subselects and user-defined types and functions). The postgresql package includes the client programs and libraries that you'll need to access a PostgreSQL DBMS server. These PostgreSQL client programs are programs that directly manipulate the internal structure of PostgreSQL databases on a PostgreSQL server. These client programs can be located on the same machine with the PostgreSQL server, or may be on a remote machine which accesses a PostgreSQL server over a network connection. This package contains the docs in HTML for the whole package, as well as command-line utilities for managing PostgreSQL databases on a PostgreSQL server.

If you want to manipulate a PostgreSQL database on a remote PostgreSQL server, you need this package. You also need to install this package if you're installing the postgresql-server package.

[racket@ibmlap pgsql]$ rpm -qi postgresql-server Name : postgresql-server Relocations: (not relocatable) Version : 8.1.2 Vendor: CentOS Release : 1.c4 Build Date: Thu 26 Jan 2006 06:47:30 AM JST Install Date: Sun 16 Apr 2006 06:09:42 PM JST Build Host: insanity.cognitive-dissonance.org Group : Applications/Databases Source RPM: postgresql-8.1.2-1.c4.src.rpm Size : 10086308 License: BSD Signature : DSA/SHA1, Thu 26 Jan 2006 08:32:27 AM JST, Key ID 5c37c0b17203f491Packager : Jim Perrin jperrin@centos.org URL : http://www.postgresql.org/ Summary : The programs needed to create and run a PostgreSQL server. Description : The postgresql-server package includes the programs needed to create and run a PostgreSQL server, which will in turn allow you to create and maintain PostgreSQL databases. PostgreSQL is an advanced Object-Relational database management system (DBMS) that supports almost all SQL constructs (including transactions, subselects and user-defined types and functions). You should install postgresql-server if you want to create and maintain your own PostgreSQL databases and/or your own PostgreSQL server. You also need to install the postgresql package. [racket@ibmlap pgsql]$ rpm -qa | grep postgresql* [racket@ibmlap pgsql]$

Sorry, I'm a little lost with this. Cheers.

Mark Sargent.