PHPBuilder.com, the best resource for PHP tutorials, templates, PHP manuals, content management systems, scripts, classes and more.

Linux Today
Enterprise Linux Today
Apache Today
JustLinux.com
Linux Planet
PHPBuilder
All Linux Devices
Hiermenus
DatabaseJournal
Technology Jobs

IT
Developer
Internet News
Small Business
Personal Technology
International

Search internet.com
Advertise
Corporate Info
Newsletters
Tech Jobs
E-mail Offers

Covalent Extends Apache 2.0 to Microsoft ASP.NET
ShopWorX - Support for Windows
PHP Security Advisory: Vulnerability in PHP versions 4.2.0 and 4.2.1
Network Risk Assessment
Full-Featured, Java-Based Apache GUI

Partners & Affiliates

Interfacing with MS Access
Cross-platform and Portable Development With PHP
Abstracting Oracle Connectivity with PHP/OCI8
Template Framework For Static Sites
Secure programming with PHP

UI Designer for Eco-Friendly Energy Company!!!!
Aquent
US-CA-Van Nuys

Post A Job | Post A Resume

Getting Started with Postgres on Redhat7.0

Kevin Kemp picture of Kevin Kemp

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

[ Next Page ]

Comments:
Postgres & PHP	Jim Morrissey	02/12/06 08:35
RE: Setup linux Postgres but Windows 2k Client	devendra	12/20/05 07:17
How to connect postgresql	Prasobh T.K	11/28/05 03:32
RE: returning newly created primary key	Mile Zajkovski	11/16/05 09:15
Difference between Oracle and Postgres	Amol Kelkar	07/28/05 06:50
Postgres SQL and Java aplicatio liking	prasad	07/13/05 03:21
Stored Procedures which returns identity seed	Renjitha	05/05/05 07:35
password authontication	Ramzi	05/04/05 05:34
LINUX+POSTGRES+PHP	aminata	03/15/05 12:11
regarding configuring &starting Postgresql	hemant ambulgekar	03/15/05 07:36
problem on quick starting postmaster	shenxiuer	03/07/05 04:02
php problem	wahid	01/17/05 06:44
which mail server can work with php & how	shubhra	12/31/04 01:29
RE: Postgres+Windows+PHP	Drew McLain	03/12/04 10:56
How to Install Postgres in client mode	Bimal Kanti Dutta	11/03/02 12:32
RE: Migration from IRIX to Linux	David Bryan	10/26/02 21:56
how to store and access a bmp file in postgre	revathi	10/26/02 08:34
synonym	MichelRueher	10/10/02 14:55
Changing default user's passwd	Reshat Sabiq	09/11/02 13:24
RE: error when connecting to db	Fabio	08/29/02 05:31
error when connecting to db	christian fanzott	08/02/02 04:40
Material ?	Flavio Petit	07/19/02 19:42
just what I needed!	Richard	07/11/02 22:50
Newbie Stupid Question	Marsie	07/11/02 09:04
RE: how to migrate data from postgre to oracle	Denver G. Vender	06/21/02 03:52
how to migrate data from postgre to oracle	vinod	06/13/02 14:34
RE: libcrypto.so and libssl.so	Mike	06/13/02 09:51
Postgres Permissions	Mesonas	06/13/02 07:07
Using ODBC over LAN to Linux?postGreSQL	Andy Welch	06/12/02 21:09
examples won't compile on redhat6.2	Joel Chen	05/30/02 20:07
Passwords	Gustavo Felisberto	05/20/02 10:33
Migration from IRIX to Linux	Jim	05/06/02 10:41
problemas al intalar postgres	Romeo Belleza	05/02/02 17:41
POSTGRES and HOST Language Interface	B.Vijayakumar	04/08/02 00:49
RE: Como desarrollo en WEb con Postgres	Ra�l Giucich	04/02/02 07:33
Como desarrollo en WEb con Postgres	Postgres Web Enable	03/26/02 13:31
postgres user	Kristy	03/17/02 10:49
Postgres responding very slow on redhat7.0	Mohit	03/08/02 05:32
RE: GUI windows interface for Postgres?	Hano de la Rouviere	03/05/02 14:19
RE: Compiling php with postgresql.	�ngelo	02/28/02 14:07
libcrypto.so and libssl.so	Steve	02/21/02 17:57
RE: Setup linux Postgres but Windows 2k Client	Frank Seesink	02/21/02 16:25
RE: Postgres+Windows+PHP	Frank Seesink	02/21/02 15:47
How to select Date Data type from Postgres	Sunil B. Javeri	02/15/02 07:06
how to pg_dump	senthil kumar	02/15/02 03:00
how to php use mail server and mail facili	senthil kumar	02/15/02 02:52
RE: GUI windows interface for Postgres?	Ted Striker	02/14/02 16:46
returning newly created primary key	Brian	02/14/02 01:39
Setup linux Postgres but Windows 2k Client	Kok Leong	02/07/02 21:10
RE: The JDBC of Postgresql did not work!	Chris Carter	02/07/02 00:48
php + postgres	Souhir	01/29/02 04:54
About Postgres	Arthur	01/24/02 06:16
GUI windows interface for Postgres?	David Paper	01/23/02 13:21
copy file to email and check send message	Duong Tran	01/18/02 21:32
applet and postgres	aditya	01/18/02 12:28
Connecting	Frank	01/04/02 06:20
download postgresql	shailesh	12/16/01 05:15
RE: How can add information to a database	A K Maiti	12/06/01 00:15
windows INSTALLATION!	kamatis	12/05/01 22:12
What's phppgadmin?	dangyadang	12/03/01 19:29
Does Postgres support multiprocessing?	Sergio	12/01/01 06:40
postmaster -i problems	Justin	11/30/01 15:17
how to install php with java support	david	11/29/01 01:48
Postgres+Windows+PHP	Alexandro Laurent	11/26/01 12:49
RE: Interface for Windows to admin Postgres	Patrick Muldoon	11/25/01 19:30
RE: LINUX+POSTGRES+PHP	killerapp	11/21/01 13:28
RE: conversion from Ms-Access to postgresql	Miron	11/16/01 18:11
RE: Postgres	Julio Cesar Campos Borges	11/14/01 11:57
Question	Julio Cesar Campos Borges	11/13/01 09:47
LINUX+POSTGRES+PHP	nirmal	11/08/01 07:04
Any Good Books For Starters	Austin Joseph	11/03/01 07:12
RE: conversion from Ms-Access to postgresql	Jesper Hertel	10/31/01 16:13
Re: postmaster won't run	Anatharyll	10/29/01 05:01
error logging	ramesh	10/19/01 08:20
error on loging	ramesh	10/19/01 07:50
Re: postmaster won't run	Graham	10/12/01 08:19
Can't even install	Brent	09/28/01 14:54
Interface for Windows to admin Postgres	Mario	09/26/01 18:06
RE: The JDBC of Postgresql	D Tim Cummings	09/10/01 20:38
Recovering a deleted table	Ethan Galloway	09/06/01 10:12
RE: is there a table viewer for Postgres	Sherif Zaroubi	09/06/01 07:50
conversion from Ms-Access to postgresql	phani	09/06/01 01:18
RE: Postgres from PHP on RedHat 7.1	Mike Fox	09/05/01 07:26
is there a table viewer for Postgres	Kiran	08/25/01 10:51
Postgres for windows EASY	John Schuhr	08/14/01 12:02
How to cancel a query running?	Point	08/06/01 04:07
RE: diff. between mySQL and postgreSQL	Ericson	07/26/01 10:35
Postgres from PHP on RedHat 7.1	Lee Chua	07/13/01 22:17
how to format the time in query in postgres	kevin	07/09/01 12:48
RE: how to create a table in postgress?	Brendan Green	07/04/01 15:25
The JDBC of Postgresql	dangyadang	07/03/01 04:24
how to create a table in postgress?	NATARAJ	06/19/01 23:58
retrieving metadata from postgres	Jiby	06/18/01 02:14
RE: diff. between mySQL and postgreSQL	vher	06/13/01 19:15
Postgres	patrick	06/08/01 15:32
information	harpreet singh s	06/05/01 21:16
Compiling php with postgresql.	clark	05/31/01 10:29
How can add information to a database	Francisco	04/27/01 12:24
RE: great, kevin! now, about odbc?	Kevin	04/27/01 06:51
RE: Interesting, but...	Kevin	04/25/01 22:43
RE: great, kevin! now, about odbc?	Kevin	04/25/01 22:39
RE: problem starting postmaster	Kevin	04/25/01 22:11
RE: Excellent article	Kevin	04/25/01 22:09
RE: Postgres for windows, yes:	Kevin	04/25/01 22:07
great, kevin! now, about odbc?	Clayton Vernon	04/23/01 18:56
problem starting postmaster	Tim Caulder	04/23/01 09:53
Excellent article	Jeremy Pavier	04/21/01 11:23
RE: how to compile	Kevin	04/21/01 10:52
Postgres for windows, yes:	Matt	04/21/01 09:26
Interesting, but...	Sasa Markovic	04/20/01 03:34
how to compile	kasturi	04/20/01 02:09
RE: php = 4.0.1pl2 is needed ..???	Kevin	04/16/01 07:57
RE: Thanks - well-aimed article	Kevin	04/16/01 07:55
Postgresql and SSL ???	Maikel Verheijen	04/13/01 09:57
php = 4.0.1pl2 is needed ..???	Casey Chambliss	04/11/01 18:22
Thanks - well-aimed article	Lee	04/05/01 01:38
RE: Running postgresql from a startup script	Michael Svazas	04/04/01 20:29
RE: Postgres for windows please	Rafael A. Borghi	03/30/01 14:43
pgsql-php	lehel	03/29/01 05:11
Running postgresql from a startup script	Eric	03/27/01 23:20
RE: What is it??	Steve Brett	03/21/01 11:12
RE: Less GUI fluff.... More useful info	Brett Jones	03/20/01 13:43
RE: Postgres for windows please	jerry	03/19/01 06:03
RE: pgsql 7.1� Benefits	Dirk	03/18/01 10:08
RE: pgsql 7.1� Benefits	Kevin	03/16/01 21:57
RE: Less GUI fluff.... More useful info	Kevin	03/16/01 21:53
Less GUI fluff.... More useful info	Brett Jones	03/15/01 22:16
RE: pgsql 7.1� Benefits	Brad Hubbard	03/15/01 17:22
RE: What is it??	Andrew Dickinson	03/15/01 16:17
RE: What is it??	bmpc	03/15/01 15:56
RE: Postgres for windows please	Phill Kenoyer	03/15/01 14:07
RE: What is it??	Kevin Monroe	03/15/01 11:53
RE: Postgres for windows please	Simon Willison	03/15/01 09:46
What is it??	ciaranmg	03/15/01 06:38
Postgres for windows please	Chris	03/15/01 04:50
pgsql 7.1� Benefits	Tom Anderson	03/14/01 23:29
If you are looking for help, please post on the appropriate forum here. Your questions will be answered much more quickly. Add A Comment: Name: Email: Subject: Message: To reduce spam posts, messages are now manually approved You are not [logged in]. That means your account will not get credit for this post.

Add A Comment: