Getting Started With Postgres on Red Hat 7.0

by: Kevin Kemp

March 14, 2001

I have read several posts and noticed the large number of questions about Postgres so I decided to start from the beginning on how to get a PostgreSQL Database up and running. I am also going to try to cover some of the most common questions about startup and configuration.

I will be making the following assumptions about your system setup:
1) You have Redhat 7.0 installed
2) PostgreSQL is not currently installed
3) You have Gnome installed (I like Gnome)
4) You have linuxconf installed
5) You have root privileges

The items I will be covering include:
1) Installation of PostgreSQL Server and Client
2) The Postmaster configuration and option descriptions
3) User and Database Creation locally
4) Access from another computer

Step 1: Use CD's or Download files from the Redhat site or a mirror site

1) Required Files:
A) postgresql-server-7.0.2-17.i386.rpm
B) postgresql-7.0.2-17.i386.rpm
C) php-pgsql-4.0.1pl2-9.i386.rpm

2) Optional Files:
A) postgresql-devel-7.0.2-17.i386.rpm
B) postgresql-jdbc-7.0.2-17.i386.rpm
C) postgresql-odbc-7.0.2-17.i386.rpm
D) postgresql-perl-7.0.2-17.i386.rpm
E) postgresql-python-7.0.2-17.i386.rpm
F) postgresql-tcl-7.0.2-17.i386.rpm (I highly recommend this)
G) postgresql-tk-7.0.2-17.i386.rpm (This is part of the above)
H) phpPgAdmin_2-2-1-pl1.tar.gz (Download from http://www.greatbridge.org/project/phppgadmin/projdisplay.php)

Step 2: Install the files

1) Use GnoRPM or command line rpm -i to all of the .rpm files
2) Move phpPgAmin to the desired Folder. (I like the directory /Programming/phpprogs)
3) At a command line type tar -xzf phpPgAdmin_2-2-1-pl1.tar.gz

Comment and Contribute

0 Comments (click to add your comment)

Your comment has been submitted and is pending approval.

Author:

Kevin Kemp

Comment:

Name/nickname:
Email:

Comment:

(Maximum characters: 1200). You have characters left.