Re: [postgresql-l] Installing postgreSQL on Fedora Core 6 (fwd)

All,

I'm forwarding this from another list; technically it's a bugs or
interfaces question, but someone is recommending an old version of PG
because of a percieved deficiency in interfaces supporitng the 8.2
protocol. I thought the protocol itself was unchanged since 7x? Take a
look and see what you think.

Thanks,
-J

---------- Forwarded message ----------
Date: Wed, 28 Mar 2007 07:04:17 -0700 (PDT)
From: Todd Lewis via postgresql-l <postgresql-l(at)Groups(dot)ITtoolbox(dot)com>
To: josh(at)globalherald(dot)net
Subject: Re: [postgresql-l] Installing postgreSQL on Fedora Core 6

//*-------------------------------------------------------------
What factors have influenced your BI & ETL purchasing decisions?
Share your thoughts: http://www.ittoolbox.com/da/502823
-------------------------------------------------------------*//

I'd
download the source and compile it instead of using the distribution that comes
with FC6. The distribution that comes with FC6 is a base generic compilation and
may not meet your needs in this project.

http://www.postgresql.org/

I'd
recommend the 8.1.x branch. the 8.2.x branch has introduced some nice
functionality, but program interfaces like php, perl, etc have not updated themselves to take advantage of some of these features. I know the perl DBI module has connection issues since they are still trying to be compatible with older versions of postgres.

This is straight out of the INSTALL for postgre. The short version.

./configure
gmake
su
gmake install
adduser postgres
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su - postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 &
/usr/local/pgsql/bin/createdb test
/usr/local/pgsql/bin/psql test

I usually use at least compiling with perl. Perl is good for your back end maintenance scripts that you need to run if you want to keep your performance levels up on the DB.
./configure --with-perl

You'll have to make changes to apache configuration files to include php as a module.

----- Original Message ----
From: Mohammed Aslam via postgresql-l
To: todd(dot)lewis(at)yahoo(dot)com
Sent: Wednesday, March 28, 2007 3:23:13 AM
Subject: [postgresql-l] Installing postgreSQL on Fedora Core 6

Dear Professionals.

I am trying to find PostgreSQL in Fedora Core6 OS. but i did not find in the service it means i did not install the postgresql.

if i want to install latest version of postgreSQL which support Fedora Core 6, and please would be all right with you if you can explain me step by setp, Installation & configuration Postgresql.

i am plaining to develop PHP Application,using backend postgresq & Apache..

please if any one can help me in this case i am very much thanks full
Thank you.. wait for step by step configuration.

Best regards.
Mohammed

____________________________________________________________________________________
We won't tell. Get more on shows you hate to love
(and love to hate): Yahoo! TV's Guilty Pleasures list.
http://tv.yahoo.com/collections/265

//*-------- INTERESTED IN THIS MESSAGE? RELATED CONTENT --------
Business Benefits of Clustered Storage (White Papers)
http://www.ittoolbox.com/da/510782
On PostgreSQL Support (Blogs)
http://www.ittoolbox.com/da/510959
Database (Wiki)
http://www.ittoolbox.com/da/228583
Capture the Hierarchy detail of purchase requsition (Groups)
http://www.ittoolbox.com/da/510960
-------------------------------------------------------------*//

//*------------------ RESOURCES FOR THIS GROUP -----------------
View Online: http://ITtoolbox.com/da/80167/postgresql-l
Manage Account/Group Tips: http://ITtoolbox.com/da/228578
Wiki: http://ITtoolbox.com/da/80166/postgresql-l
Leave This Group: mailto:leave-postgresql-l(at)Groups(dot)ITtoolbox(dot)com
Copyright (c) ITtoolbox and message author. No redistribution.
-------------------------------------------------------------*//