Board logo

installing postgreSQL
e=mc2 - 10-16-2006 at 06:32 PM

Hello, we have just recently installed BQ/centOS from you and it is working pretty good for the most part. I have some minor technical setup questions that I will ask in other (more relevant) threads..

but this one is about PostgreSQL... i have been looking around here (and on google) and not sure what to think about it. I know that the centOS/BQ CD that we got from you and installed on this server contains mySQL but I have some questions...

#1 can postgreSQL work on this server along with mySQL or do I need to only have one or the other?

#2 I have seen where a few people have been having problems with postgreSQL, is it stable for this OS/control panel and can I install/operate it without problems??

#3 is there, or can you provide me with an install package so that I can install postgreSQL in this server?

...I like mySQL, but the reason that I want to use postgreSQl is that I have a perl script/website that I want to install and use called 'sql-ledger' and it requires postgreSQL. I am having a heck of a time trying to install this on another server and so I thought I would try to put it on the centOS/BQ machine.

any input would be greatly appreciated - thanks.

brian - 10-16-2006 at 10:51 PM

quote:

#1 can postgreSQL work on this server along with mySQL or do I need to only have one or the other?


Yes you can run both.

quote:

#2 I have seen where a few people have been having problems with postgreSQL, is it stable for this OS/control panel and can I install/operate it without problems??


People by default are (sorry to say) very stupid.

PostgreSQL is extremely stable, and depends on who you talk to, is considered better then MySQL.

Every one has their own opinion. Mine is I never used PostgreSQL, so I have none.

quote:

#3 is there, or can you provide me with an install package so that I can install postgreSQL in this server?


Easiest way is via Yum. or goto PostgreSQL's site and read the how to install. They provide wonder documentation from what I am told.

Or as I said use Yum.

yum install postgresql-server

It should download the client too. There are a lot of addons. You can do:

yum search postgresql | less

and look through them. Some may not be postgresql addons though. But read the description, and it should assist you!

teligo - 10-16-2007 at 03:11 PM

I installed postgres by yum, postgres 7 was installed. It works by itself but PHP do not load the posgres extension, I installed you PHP5, mySQL 5 package.
So I installed by RPM postgres 8 and PHP-pgsql 5 but PHP still do not load the posgres extension.
Do yuo have any help?
Thank you.
Carlo