PostgreSQL

General Discussion of atomic repo and development projects.

Ask for help here with anything else not covered by other forums.
Galactic Zero
Forum Regular
Forum Regular
Posts: 471
Joined: Mon Dec 06, 2004 10:43 pm

PostgreSQL

Unread post by Galactic Zero »

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.
Franklyn Halamka
Still learning my way around Linux Security.
http://www.galacticzero.net
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:

Unread post by scott »

Yeah I do actually, in the base/updates channels. Those are really from Whitebox linux, but they should work on your system
Galactic Zero
Forum Regular
Forum Regular
Posts: 471
Joined: Mon Dec 06, 2004 10:43 pm

Unread post by Galactic Zero »

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/atomi ... eleasever/
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/atomi ... eleasever/
baseurl=http://archive.atomicrocketturtle.com/a ... eleasever/
baseurl=http://www.atomicrocketturtle.com/atomi ... eleasever/

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

# 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/atomi ... eleasever/

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

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

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.
Franklyn Halamka
Still learning my way around Linux Security.
http://www.galacticzero.net
Galactic Zero
Forum Regular
Forum Regular
Posts: 471
Joined: Mon Dec 06, 2004 10:43 pm

Unread post by Galactic Zero »

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/atomi ... eleasever/
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/atomi ... eleasever/
baseurl=http://archive.atomicrocketturtle.com/a ... eleasever/
baseurl=http://www.atomicrocketturtle.com/atomi ... eleasever/

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

# 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/atomi ... eleasever/

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

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

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.
Franklyn Halamka
Still learning my way around Linux Security.
http://www.galacticzero.net
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:

Unread post by scott »

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?)
Galactic Zero
Forum Regular
Forum Regular
Posts: 471
Joined: Mon Dec 06, 2004 10:43 pm

Unread post by Galactic Zero »

Nope.... :shock:
Franklyn Halamka
Still learning my way around Linux Security.
http://www.galacticzero.net
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:

Unread post by scott »

[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
Galactic Zero
Forum Regular
Forum Regular
Posts: 471
Joined: Mon Dec 06, 2004 10:43 pm

Unread post by Galactic Zero »

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.
Franklyn Halamka
Still learning my way around Linux Security.
http://www.galacticzero.net
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:

Unread post by scott »

run setup, goto System Services, and tag the ones you want to start up
Galactic Zero
Forum Regular
Forum Regular
Posts: 471
Joined: Mon Dec 06, 2004 10:43 pm

Unread post by Galactic Zero »

Call me dense..

run setup? which setup? Apache, PSA?

Thanks.
Franklyn Halamka
Still learning my way around Linux Security.
http://www.galacticzero.net
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:

Unread post by scott »

as in /usr/sbin/setup
Galactic Zero
Forum Regular
Forum Regular
Posts: 471
Joined: Mon Dec 06, 2004 10:43 pm

Unread post by Galactic Zero »

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

What would it be called?

Thanks for your help.
Franklyn Halamka
Still learning my way around Linux Security.
http://www.galacticzero.net
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:

Unread post by scott »

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
Galactic Zero
Forum Regular
Forum Regular
Posts: 471
Joined: Mon Dec 06, 2004 10:43 pm

Unread post by Galactic Zero »

Thanks Scott for your help.. The program I needed to run was rhdb.. now how to figure they came up with that....
Franklyn Halamka
Still learning my way around Linux Security.
http://www.galacticzero.net
Post Reply