On Sun, 2006-04-16 at 18:38 +0900, Mark Sargent wrote:
> 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@xxxxxxxxxx>
> 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@xxxxxxxxxx>
> 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.
-----
nowhere do you actually say what you are trying to do.
Are you trying to start postgresql server?
/sbin/service postgresql start
Are you trying to get postgresql server to start on each boot?
/sbin/chkconfig postgresql on
Are you trying to use the client application?
/usr/bin/psql [options]
Are you trying to locate the configuration files?
/var/lib/pgsql/data
Craig
