Thread: Fwd: Web Hosting support for pgsql in PHP
I moved a number of sites a few months ago to site5 web hosting but have run into an issue where they refuse to include the support for pgsql into the php environment. Although they did try to install it with pecl that failed with no pg_config and missing libpg-fe.h. It appears that the php modules do not install with out the developer tools installed, An I have just run into a road block attempting to get this done. They refuse. Note, I am not asking them to support a postgresql database, just include the support in PHP so I can access an existing database remotely.
I went to site5 for their shared support & expertise of wordpress and other hosting tools that I thought would be better supported in a shared cpannel environment with dedicated resources, than I could do on a dedicated server at say rackspace. Now I am questioning the decision.
Via my post here, I am wondering what others are doing for hosting options that include both wordpress & php-pgsql
Thanks in advance --
On Mon, Dec 30, 2013 at 1:20 PM, Jeff Silberberg <jms@dapage.net> wrote: > > > Good afternoon, > > I moved a number of sites a few months ago to site5 web hosting but > have run into an issue where they refuse to include the support for pgsql > into the php environment. Although they did try to install it with pecl > that failed with no pg_config and missing libpg-fe.h. It appears that the > php modules do not install with out the developer tools installed, An I > have just run into a road block attempting to get this done. They refuse. > Note, I am not asking them to support a postgresql database, just include > the support in PHP so I can access an existing database remotely. What kind of server are they using? Assuming it's debian / ubuntu all they need to do is install the following packages on your virtual server: php5-pgsql phppgadmin postgresql postgresql-client postgresql-common They sound lost.
On 30/12/2013 20:28, Scott Marlowe wrote: > On Mon, Dec 30, 2013 at 1:20 PM, Jeff Silberberg <jms@dapage.net> wrote: >> >> >> Good afternoon, >> >> I moved a number of sites a few months ago to site5 web hosting but >> have run into an issue where they refuse to include the support for pgsql >> into the php environment. Although they did try to install it with pecl >> that failed with no pg_config and missing libpg-fe.h. It appears that the >> php modules do not install with out the developer tools installed, An I >> have just run into a road block attempting to get this done. They refuse. >> Note, I am not asking them to support a postgresql database, just include >> the support in PHP so I can access an existing database remotely. > > What kind of server are they using? Assuming it's debian / ubuntu all > they need to do is install the following packages on your virtual > server: > > php5-pgsql > phppgadmin > postgresql > postgresql-client > postgresql-common > > They sound lost. From the OP's post on the pgsql-php list, it sounds like shared hosting via CPanel.... I've had pretty awful experience with Irish ISPs, who - if they support Postgres at all - generally provide ancient versions in their shared hosting offerings. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie
I used Site5 for the longest, maybe until 5 or 6 years ago. The problem with shared hosting is that many times they are unwilling to install software because they don't really know what it does or they don't want to support it. Basically they don't want to affect the rest of the server just by helping one person out. So installing that module might hurt another hosted site.
The reason I left them was because they had some crazy email filtering system. Basically they filtered it two or three times resulting in me not receiving emails. They would even block out emails from Facebook as well as other legitimate mail that I wanted to get.
Sure shared hosting is great, but you also have to settle for what they offer most of the time.
-Joseph
Jeff, > Via my post here, I am wondering what others are doing for hosting options > that include both wordpress & php-pgsql If shared hosting is acceptable for your databases, have you considered a VPS? -- G.
Well,
[~]# uname -a
Linux s17-dallas.accountservergroup.com 3.2.45-grsec #1 SMP Thu May 23 08:37:40 CDT 2013 x86_64 x86_64 x86_64 GNU/Linux
An it's Apache / Wordpress --
All I think they need to to do is pecl install pdo_pgsql-1.0.2
But that looks for pg_config and libpg-fe.h which means installing postgresql-devel as well.
They are not willing to this, as "it might break another customer" .
Anyway, I Am now looking for new host instead of fixing this one..
On Mon, Dec 30, 2013 at 3:28 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
On Mon, Dec 30, 2013 at 1:20 PM, Jeff Silberberg <jms@dapage.net> wrote:What kind of server are they using? Assuming it's debian / ubuntu all
>
>
> Good afternoon,
>
> I moved a number of sites a few months ago to site5 web hosting but
> have run into an issue where they refuse to include the support for pgsql
> into the php environment. Although they did try to install it with pecl
> that failed with no pg_config and missing libpg-fe.h. It appears that the
> php modules do not install with out the developer tools installed, An I
> have just run into a road block attempting to get this done. They refuse.
> Note, I am not asking them to support a postgresql database, just include
> the support in PHP so I can access an existing database remotely.
they need to do is install the following packages on your virtual
server:
php5-pgsql
phppgadmin
postgresql
postgresql-client
postgresql-common
They sound lost.
Jeff Silberberg <jms@dapage.net> wrote: > Anyway, I Am now looking for new host instead of fixing this one.. I'm working for internet24.de, a hosting - provider in germany. We are support PostgreSQL in our shared hostig ;-) Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°