Topic: install postgresql on SME Help?

[Kevin Baker]

Has anyone successfully installed postgresql on SME?

I can not seem to find a simple procedure to install it on either sme or just straight Red Hat.

Also how would I install gcc or cc?  Apparently I need them to complile the PG source.

[Kevin Baker]

Four hours later I got it....

For anyone else out there, this is the easiest way I can find.

AbriaSoft.com has a sort of turn key system for installing Apache/MySQL/PHP.  They recently released a version of their installer that includes PostgreSQL.

Download this package, its a tar file.  You will need to create an account.
http://www.abriasoft.com/products/product16.php
Its the merlin server.  Download the free version.

Do Not Install it!!! It will totally mess up e-smith.  Untar the file, in the Abria*/merlin folder there are a bunch of rpms for postgresql.  Install the dev,clients, and server.... that's it.


Seems long... but the alternative is trying to get gcc working on the e-smith server to install source.

Anyway..... it actually puts a postgresql script in the "/etc/rc.d/init.d"  so that's that.... just run the script of restart if you want.

[Jáder Marasca]

I just downloaded the RPM files for postgresql from rpmfind.net !!
It installed fine!

But I have not tryed to install GCC... just PostgreSQL !

Do you really want to install GCC and other things or just need PG ?

[Dan Brown]

Kevin, was there a problem with the RedHat postgresql RPMs at rpmfind.net?  Sounds like you're taking the long way to do this.

[Kevin Baker]

That's funny  It must have been real late.  I was all over the rpmfind.net sight trying to get the rpms for gcc, to complile the postgresql src, but didn't think to search for postgresql there.

Daaahhhh.  Note to self do not do work at 4 in the morning.

Anyway thanks.

[Jáder Marasca]

No problems!

You´re welcome!
And go to bed earlier!  

Jáder

[Kevin Baker]

ok, now I am running into the php issue with PostgreSQL.  I have noticed another thread, but I have a slightly different issue.

I cannot get php-pgsql installed into the current version of PHP.  I am running SME 5.1.  I would like to upgrade it but do not have access to the CD rom as it is a hosted machine.  If I have to I can to upgrade to 5.5, but is there possibly another way?

[Jáder Marasca]

The family Brown attacks again:

http://www.familybrown.org/howtos/php-upgrade-howto-sme512.html

Send your (and mine) best regards to Dan Brown and his brothers!

[Dan Brown]

Actually, it's only one brother.  In addition to the RPMs specified in that HOWTO, you'll also need the php-pgsql one, also in my contrib directory on ftp.e-smith.org.

[Kevin Baker]

Which postgresql server rpm should I use from the rpmfind.net?  

I noticed that there is no Red Hat 7.3 rpm.

[Jáder Marasca]

For SME 5.5 you can use : postgresql-7.1.3-2.i386.rpm
For SME 5.1.2 you must find the RPM on RedHat CDs! I don´t think 7.1.3 will work because of dependencies!

[John Alamo]

Hi all ..

I grabbed postgresql-7.1.3-2.i386.rpm as well as doing a compile of the latest version (7.3.1) -- I can log into 7.3.1 at the console (using psql) but when trying to access via phpPgAdmin I get the following message:

     You do not have postgresql support built into your PHP Web Server.
     phpPgAdmin requires postgresql support to function properly!
     Please check the PHP documentation for corrective action.

I looked at the ./configure line of the current php and it shows '--with-pgsql=shared'  and php-pgsql-4.1.2-2es3 is already installed from the original 5.5 install.. but yet I still get the message that there is no support (?)

Any help would be greatly appreciated.

[Jáder Marasca]

I´m sorry... I´m a tech guy... not a programmer , just a installer.
I don´t have a clue about why 7.3.1 don´t work with SME (and show this error message) but 7.1.3 works.

I´ll forward your question to a friend of mine who is programming in PHP + PgSQL.
Maybe it tooks a time to answer, so please be patiente!

Jáder

[Dan Brown]

John, what does a phpinfo page say about postgres support?

[John Alamo]

Sorry for the delay in reply .. I haven't had time to address the problem.

Currently here is my system setup:

a phpinfo() shows:

Configure command includes '--with-pgsql=shared' however at this time, nothing else shows ..

The system is currently running e-smith 5.6b7

# rpm -qa | grep php
php-ldap-4.1.2-7.3.4
e-smith-php-1.7.1-01
php-pgsql-4.1.2-7.3.4
php-4.1.2-7.3.4
php-mysql-4.1.2-7.3.4
php-imap-4.1.2-7.3.4

pgsql.so shows up in /usr/lib/php4 (not sure if this is important)

# rpm -qa | grep postgres
postgresql-7.2.1-5
postgresql-libs-7.2.1-5
postgresql-server-7.2.1-5

after installing php-pgsql-4.1.2-7.3.4 I started postgres as well as stop and started httpd (apache)

# ps -aux | grep postgres
postgres 12309  0.0  0.6  8116 1732 pts/0    S    Jan17   0:00 /usr/bin/postmast
postgres 12311  0.0  0.6  9108 1708 pts/0    S    Jan17   0:00 postgres: stats b
postgres 12312  0.0  0.6  8152 1740 pts/0    S    Jan17   0:00 postgres: stats c

if I do a su - postgres I can access the database using pgsql ..

however, phpPgAdmin shows the following when attempting to start it:

You do not have postgresql support built into your PHP Web Server.
phpPgAdmin requires postgresql support to function properly!
Please check the PHP documentation for corrective action.

Any additional ideas would be greatly appreciated.. it would be great to get Postgres/PHP working on this server.