Re: Web Hosting support for pgsql in PHP

Good afternoon,

I move a number 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 --

http://www.site5.com/p/php-hosting/

http://php.net/pg_connect

On 27/12/2013 19:04, Jeff Silberberg wrote:
>
> Good afternoon,
>
> I move a number 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

I run websites (mostly Drupal-based) on a Debian server, and PostgreSQL
is accessible just fine from PHP without the development packages:

apt-get install php5-pgsql

- and it just works.

I know it can be harder in a shared hosting environment.... here in
Ireland, at least, ISPs don't usually include Postgres support with
cheap shared hosting packages (via CPanel, etc), or if they do it's for
versions that are years out of date.

I haven't looked at WordPress in years, but my memory is that its
support of PostgreSQL wasn't great.... I had to install MySQL just
because a client specifically wanted a WordPress site. :-(

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie

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.

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 --

http://www.site5.com/p/php-hosting/

http://php.net/pg_connect

On Mon, Dec 30, 2013 at 1:20 PM, Jeff Silberberg <jms(at)dapage(dot)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(at)dapage(dot)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(at)iol(dot)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(dot)marlowe(at)gmail(dot)com>wrote:

> On Mon, Dec 30, 2013 at 1:20 PM, Jeff Silberberg <jms(at)dapage(dot)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.
>

Jeff Silberberg <jms(at)dapage(dot)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°