CentOS/RH/Amazon RPMs for pgsql-http https://github.com/pramsey/pgsql-http and postgresql 9.2 (>=9.2.17), 9.3 (>= 9.3.4), 9.4 (>=9.4.1), and 9.6 (>=9.6.2) from the official repositories
Tested on CentOS 6.4 (unofficial curl packages), CentOS 7.1 and Amazon Linux 2014.03 (x86_64 in all cases)
pgsql-http is a HTTP client for PostgreSQL, able to retrieve a web page from inside the database.
Use postgresql92* packages for PostgreSQL 9.2 (>= 9.2.17), postgresql93* packages for PostgreSQL 9.3 (>= 9.3.4), posgresql94* packages for PostgreSQL 9.4 (>= 9.4.1) or posgresql96* packages for PostgreSQL 9.6 (>= 9.6.2), in all cases from the official repositories (and not from your distribution repositories!)
To build:
- postgresql92-devel >= 9.2.17, postgresql93-devel >= 9.3.4, postgresql94-devel >= 9.4.1 or postgresql96-devel >= 9.6.2
- curl-devel >= 0.7.20
- automake
- gcc
- git
- rpm-build
To install the RPM for PostgreSQL
- postgresql92 >= 9.2.17, postgresql93 >= 9.3.4, postgresql94 >= 9.4.1 or postgresql96 >= 9.6.2
- postgresql92-server >= 9.2.17, postgresql93-server >= 9.3.4, postgresql94-server >= 9.4.1 or postgresql96-server >= 9.6.2
- postgresql92-libs => 9.2.17, postgresql93-libs >= 9.3.4, postgresql94-libs >= 9.4.1 or postgresql96-libs >= 9.6.2
Clone the repo:
[email protected]:juliogonzalez/pgsql-http-rpm.git
cd pgsql-http-rpm
Build the RPMs:
./pgsql-http-rpm -p 9.2 # for PostgreSQL 9.2
or
./pgsql-http-rpm -p 9.3 # for PostgreSQL 9.3
or
./pgsql-http-rpm -p 9.4 # for PostgreSQL 9.4
or
./pgsql-http-rpm -p 9.4 # for PostgreSQL 9.6
And install:
rpm -Uvh RPMS/$HOSTTYPE/postgresql-92-pgsql-http-1.1.2-1*.$HOSTTYPE.rpm # for PostgreSQL 9.2
or
rpm -Uvh RPMS/$HOSTTYPE/postgresql-93-pgsql-http-1.1.2-1*.$HOSTTYPE.rpm # for PostgreSQL 9.3
or
rpm -Uvh RPMS/$HOSTTYPE/postgresql-94-pgsql-http-1.1.2-1*.$HOSTTYPE.rpm # for PostgreSQL 9.4
or
rpm -Uvh RPMS/$HOSTTYPE/postgresql-96-pgsql-http-1.1.2-1*.$HOSTTYPE.rpm # for PostgreSQL 9.6