PostgreSQL

From DreamFactory
Jump to: navigation, search
(Replaced content with "== Driver == The PostgreSQL PHP driver should be available in your package manager, or downloadable from php pecl. For example if you are following the ../../../APT/Ubu...")
 
Line 1: Line 1:
== Linux ==
+
== Driver ==
 +
The PostgreSQL PHP driver should be available in your package manager, or downloadable from php pecl.
  
# [[DreamFactory/Installation#Linux|Install DreamFactory]]. (The below steps assume a DreamFactory install in <code>~/df/</code> with its PHP installed in <code>~/df/php/</code>.)
+
For example if you are following the [[../../../APT/Ubuntu_16.04/Modules/PostgreSQL| Ubuntu 16.04]] instructions, this package is named php7.1-pgsql.
# Check <code>~/df/php/etc/php.ini</code> to ensure the values <code>extension=pgsql.so</code> and <code>extension=pdo_pgsql.so</code> are present and uncommented. (In the Bitnami installer they already are.)
+
# Check <code>~/df/php/lib/php/extensions/</code> to ensure <code>pgsql.so</code> and <code>pdo_pgsql.so</code> are present. (These are included in the Bitnami package.)
+
# If you made any changes/additions in steps ii and iii, restart your Apache server.
+
# Login to your DreamFactory Admin Console and create a new service in the Services tab. Enter the following, then click Save at the bottom of the page.
+
#* Type: Remote SQL DB
+
#* Username and Password: valid credentials to your PostgreSQL DB
+
#* SQL Vendor: PostgreSQL
+
#* Host: hostname or IP of your PostgreSQL server (localhost if appropriate)
+
#* Database Name: name of the PostgreSQL DB
+
#* Connection String: if using a port other than the default (5432), add <code>;port=####</code> (where #### is the actual port number) to the end of your connection string
+
# Click over to the “API Docs” tab, expand your new service, and perform a simple GET request to verify connectivity.
+
 
+
== Mac ==
+
 
+
# [[DreamFactory/Installation#Mac_OS_X|Install DreamFactory]]. (The below steps assume a DreamFactory install in <code>/Applications/df/</code> with its PHP installed in <code>/Applications/df/php/</code>.)
+
# Check <code>/Applications/df/php/etc/php.ini</code> to ensure the values <code>extension=pgsql.so</code> and <code>extension=pdo_pgsql.so</code> are present and uncommented. (In the Bitnami installer they already are.)
+
# Check <code>/Applications/df/php/lib/php/extensions/</code> to ensure <code>pgsql.so</code> and <code>pdo_pgsql.so</code> are present. (These are included in the Bitnami package.)
+
# If you made any changes/additions in steps ii and iii, restart your Apache server.
+
# Login to your DreamFactory Admin Console and create a new service in the Services tab. Enter the following, then click Save at the bottom of the page.
+
#* Type: Remote SQL DB
+
#* Username and Password: valid credentials to your PostgreSQL DB
+
#* SQL Vendor: PostgreSQL
+
#* Host: hostname or IP of your PostgreSQL server (localhost if appropriate)
+
#* Database Name: name of the PostgreSQL DB
+
#* Connection String: if using a port other than the default (5432), add <code>;port=####</code> (where #### is the actual port number) to the end of your connection string
+
# Click over to the “API Docs” tab, expand your new service, and perform a simple GET request to verify connectivity.
+
 
+
== Windows ==
+
 
+
# [[DreamFactory/Installation#Windows_2|Install DreamFactory]]. (The below steps assume a DreamFactory install in <code>C:\df\</code> with its PHP installed in <code>C:\df\php\</code>.)
+
# Check <code>C:\df\php\php.ini</code> to ensure the value <code>extension=php_pdo_pgsql.dll</code> is present and uncommented. (In the Bitnami installer it already is.)
+
# Check <code>C:\df\php\ext\</code> to ensure <code>php_pdo_pgsql.dll</code> is present. (This is included in the Bitnami package.)
+
# If you made any changes/additions in steps ii and iii, restart your Apache server.
+
# Login to your DreamFactory Admin Console and create a new service in the Services tab. Enter the following, then click Save at the bottom of the page.
+
#* Type: Remote SQL DB
+
#* Username and Password: valid credentials to your PostgreSQL DB
+
#* SQL Vendor: PostgreSQL
+
#* Host: hostname or IP of your PostgreSQL server (localhost if appropriate)
+
#* Database Name: name of the PostgreSQL DB
+
#* Connection String: if using a port other than the default (5432), add <code>;port=####</code> (where #### is the actual port number) to the end of your connection string
+
# Click over to the “API Docs” tab, expand your new service, and perform a simple GET request to verify connectivity.
+

Latest revision as of 18:25, 28 February 2018

Driver

The PostgreSQL PHP driver should be available in your package manager, or downloadable from php pecl.

For example if you are following the Ubuntu 16.04 instructions, this package is named php7.1-pgsql.