Heya Scott,

Do you have RPM's for Postgresql for 3ES and PSA 7.1.x?

If so, which channel should I use to get them.

[root@gz root]# rpm -qa |grep postgresql
rh-postgresql-devel-(none)-7.3.6-7
rh-postgresql-libs-(none)-7.3.6-7
rh-postgresql-python-(none)-7.3.6-7
rh-postgresql-(none)-7.3.6-7
[root@gz root]#

My CP says that the server isn't installed...???

postgresql-server Component was not installed


Thanks.

Yeah I do actually, in the base/updates channels. Those are really from Whitebox linux, but they should work on your system

Hum.. not picking them up..

Here are my yum and souces entries:

YUM:

# THIS CONTAINS MY PSA COMPATIBLE RPMS
[atomic-psa]
name=Atomic Rocket Turtle - $releasever - Atomic PSA
baseurl=ftp://ftp.shinn.net/pub/Linux/atomic/psa/$releasever/
baseurl=http://www.atomicrocketturtle.com/atomic/psa/$releasever/
baseurl=http://shinn.net/pub/Linux/atomic/psa/$releasever/

# THIS CHANNEL CONTAINS MY PSA COMPATIBLE RPMS (php, mysql, qmail-scanner, etc)
[atomic]
name=Atomic Rocket Turtle - $releasever - Atomic PSA-Compatible RPMS
baseurl=http://3es.atomicrocketturtle.com/atomic/art/$releasever/
baseurl=http://archive.atomicrocketturtle.com/atomic/art/$releasever/
baseurl=http://www.atomicrocketturtle.com/atomic/art/$releasever/

# [psa-7.0]
# name=Atomic Rocket Turtle - $releasever - SW-Soft PSA 7.0 RPMS
# baseurl=http://3es.atomicrocketturtle.com/atomic/psa-7.0/$releasever/
# baseurl=http://archive.atomicrocketturtle.com/atomic/psa-7.0/$releasever/
# baseurl=http://www.atomicrocketturtle.com/atomic/psa-7.0/$releasever/

# THIS CONTAINS ONLY SW-SOFT's PSA 7.1.x RPMS
# USE THIS CHANNEL IF YOU USE PSA 7.1.x
[atomic-psa71]
name=Atomic Rocket Turtle - $releasever - Atomic PSA 7.1
baseurl=http://shinn.net/pub/Linux/atomic/psa71/$releasever/
baseurl=ftp://ftp.shinn.net/pub/Linux/atomic/psa71/$releasever/
baseurl=http://www.atomicrocketturtle.com/atomic/psa71/$releasever/

[base]
name=Atomic Rocket Turtle - $releasever - Base OS RPMS mirror
baseurl=http://3es.atomicrocketturtle.com/3rd-party/base/$releasever/

[updates]
name=Atomic Rocket Turtle - $releasever - OS Update RPMS mirror
baseurl=http://3es.atomicrocketturtle.com/3rd-party/updates/$releasever/

UP2DATE:

# THIS CONTAINS MY PSA COMPATIBLE RPMS
yum atomic-psa http://www.atomicrocketturtle.com/atomic/psa/3ES/

# THIS CONTAINS ONLY GAMERA non server specific RPMS
# yum atomic-gamera http://www.atomicrocketturtle.com/atomic/gamera/3ES/

# THIS CONTAINS ONLY SW-SOFT's PSA 7.1.x RPMS
# USE THIS CHANNEL IF YOU USE PSA 7.1.x
yum atomic-psa71 http://www.atomicrocketturtle.com/atomic/psa71/3ES/

What would I be missing?

Thanks.

Hum.. not picking them up..

Here are my yum and souces entries:

YUM:

# THIS CONTAINS MY PSA COMPATIBLE RPMS
[atomic-psa]
name=Atomic Rocket Turtle - $releasever - Atomic PSA
baseurl=ftp://ftp.shinn.net/pub/Linux/atomic/psa/$releasever/
baseurl=http://www.atomicrocketturtle.com/atomic/psa/$releasever/
baseurl=http://shinn.net/pub/Linux/atomic/psa/$releasever/

# THIS CHANNEL CONTAINS MY PSA COMPATIBLE RPMS (php, mysql, qmail-scanner, etc)
[atomic]
name=Atomic Rocket Turtle - $releasever - Atomic PSA-Compatible RPMS
baseurl=http://3es.atomicrocketturtle.com/atomic/art/$releasever/
baseurl=http://archive.atomicrocketturtle.com/atomic/art/$releasever/
baseurl=http://www.atomicrocketturtle.com/atomic/art/$releasever/

# [psa-7.0]
# name=Atomic Rocket Turtle - $releasever - SW-Soft PSA 7.0 RPMS
# baseurl=http://3es.atomicrocketturtle.com/atomic/psa-7.0/$releasever/
# baseurl=http://archive.atomicrocketturtle.com/atomic/psa-7.0/$releasever/
# baseurl=http://www.atomicrocketturtle.com/atomic/psa-7.0/$releasever/

# THIS CONTAINS ONLY SW-SOFT's PSA 7.1.x RPMS
# USE THIS CHANNEL IF YOU USE PSA 7.1.x
[atomic-psa71]
name=Atomic Rocket Turtle - $releasever - Atomic PSA 7.1
baseurl=http://shinn.net/pub/Linux/atomic/psa71/$releasever/
baseurl=ftp://ftp.shinn.net/pub/Linux/atomic/psa71/$releasever/
baseurl=http://www.atomicrocketturtle.com/atomic/psa71/$releasever/

[base]
name=Atomic Rocket Turtle - $releasever - Base OS RPMS mirror
baseurl=http://3es.atomicrocketturtle.com/3rd-party/base/$releasever/

[updates]
name=Atomic Rocket Turtle - $releasever - OS Update RPMS mirror
baseurl=http://3es.atomicrocketturtle.com/3rd-party/updates/$releasever/

UP2DATE:

# THIS CONTAINS MY PSA COMPATIBLE RPMS
yum atomic-psa http://www.atomicrocketturtle.com/atomic/psa/3ES/

# THIS CONTAINS ONLY GAMERA non server specific RPMS
# yum atomic-gamera http://www.atomicrocketturtle.com/atomic/gamera/3ES/

# THIS CONTAINS ONLY SW-SOFT's PSA 7.1.x RPMS
# USE THIS CHANNEL IF YOU USE PSA 7.1.x
yum atomic-psa71 http://www.atomicrocketturtle.com/atomic/psa71/3ES/

What would I be missing?

Thanks.

I seem to remember that they changed the name of postgres in 3ES. You'll have to "yum search" it (didja know you could search with yum?)

Nope....

[root@3es root]# yum search postgres
Gathering header information file(s) from server(s)
Server: Red Hat Linux 3ES - i386 - Base
Server: Red Hat Linux 3ES - Updates
Finding updated packages
Downloading needed headers

Looking in available packages for a providing package
Available package: libdbi-dbd-pgsql.i386 0:0.6.5-5 from base matches with
PostgreSQL plugin for libdbi
Available package: rh-postgresql-test.i386 0:7.3.6-7 from updates matches with
The test suite distributed with PostgreSQL.
Available package: rh-postgresql-test.i386 0:7.3.6-7 from updates matches with
rh-postgresql-test
Available package: qt-PostgreSQL.i386 1:3.1.2-13.4 from updates matches with
PostgreSQL driver for Qt's SQL classes (QSQL)
Available package: qt-PostgreSQL.i386 1:3.1.2-13.4 from updates matches with
PostgreSQL drivers for Qt's SQL classes.
Available package: qt-PostgreSQL.i386 1:3.1.2-13.4 from updates matches with
qt-PostgreSQL
Available package: rh-postgresql-tcl.i386 0:7.3.6-7 from updates matches with
A Tcl client library for PostgreSQL.
Available package: rh-postgresql-tcl.i386 0:7.3.6-7 from updates matches with
rh-postgresql-tcl
Available package: freeradius-postgresql.i386 0:1.0.1-1.RHEL3 from updates matches with
postgresql bindings for freeradius
Available package: freeradius-postgresql.i386 0:1.0.1-1.RHEL3 from updates matches with
freeradius-postgresql
Available package: postgresql-odbc.i386 0:7.3-3 from base matches with
PostgreSQL ODBC driver.
Available package: postgresql-odbc.i386 0:7.3-3 from base matches with
postgresql-odbc
Available package: rh-postgresql-pl.i386 0:7.3.6-7 from updates matches with
The PL procedural languages for PostgreSQL.
Available package: rh-postgresql-pl.i386 0:7.3.6-7 from updates matches with
rh-postgresql-pl
Available package: rh-postgresql-docs.i386 0:7.3.6-7 from updates matches with
Extra documentation for PostgreSQL
Available package: rh-postgresql-docs.i386 0:7.3.6-7 from updates matches with
rh-postgresql-docs
Available package: rh-postgresql-jdbc.i386 0:7.3.6-7 from updates matches with
Files needed for Java programs to access a PostgreSQL database.
Available package: rh-postgresql-jdbc.i386 0:7.3.6-7 from updates matches with
rh-postgresql-jdbc
18 results returned
Looking in installed packages for a providing package
Installed package: rh-postgresql-libs.i386 0:7.3.6-7 matches with
rh-postgresql-libs
Installed package: rh-postgresql-contrib.i386 0:7.3.6-7 matches with
rh-postgresql-contrib
Installed package: rh-postgresql-server.i386 0:7.3.6-7 matches with
rh-postgresql-server
Installed package: rh-postgresql.i386 0:7.3.6-7 matches with
rh-postgresql
Installed package: rh-postgresql-python.i386 0:7.3.6-7 matches with
rh-postgresql-python
Installed package: rh-postgresql-devel.i386 0:7.3.6-7 matches with
rh-postgresql-devel
6 results returned

Once you said search and that 3es has named postgresql differently, I remember the results of my rpm -qa grep and did a yum search rh-postgresql and low and behold, a listing of postgre stuff. Installed rh-postgresql-server and it is as right as rain.

Now, how do I setup both tomcat and postgresql to start on a server up. They are there, and I have to start them manually on a server reboot.

Thanks.

run setup, goto System Services, and tag the ones you want to start up

Call me dense..

run setup? which setup? Apache, PSA?

Thanks.

as in /usr/sbin/setup

Ok, found the one for tomcat4 but didn't see the one for postgresql..

What would it be called?

Thanks for your help.

Like I pasted earlier, postgres under 3ES is "rh-postgresql...." I dont personally use postgres on my servers (or tomcat) so you'll need to figure out the nitty gritty on your own. I just know they use a different naming convention on 3ES than they do in RH9

Thanks Scott for your help.. The program I needed to run was rhdb.. now how to figure they came up with that....