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

Sun Apr 16 09:38:27 UTC 2006
Mark Sargent <powderkeg at snow.email.ne.jp>

Hi All,

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


[racket at 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 at ibmlap pgsql]$ sudo updatedb Password:

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

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

[racket at 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 at ibmlap pgsql]$ whereis postgresql
postgresql:

[racket at 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 at 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 at ibmlap pgsql]$ rpm -qa | grep postgresql*

[racket at 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 at 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 at 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 at 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 at ibmlap pgsql]$ rpm -qa | grep postgresql*
[racket at ibmlap pgsql]$

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

Mark Sargent.