PostgreSQL

From DreamFactory
Jump to: navigation, search
(Created page with "PostgreSQL Linux 1. [Install DreamFactory](Install-on-Linux). (The below steps assume a DreamFactory install in `~/dsp/` with its PHP installed in `~/dsp/php/`.) 2. Chec...")
 
Line 1: Line 1:
PostgreSQL
 
 
 
Linux
 
Linux
  
 
   1. [Install DreamFactory](Install-on-Linux). (The below steps assume a DreamFactory install in `~/dsp/` with its PHP installed in `~/dsp/php/`.)
 
   1. [Install DreamFactory](Install-on-Linux). (The below steps assume a DreamFactory install in `~/dsp/` with its PHP installed in `~/dsp/php/`.)
   2. Check `~/dsp/php/etc/php.ini` to ensure the values `extension=pgsql.so` and `extension=pdo_pgsql.so` are present and uncommented. (In the Bitnami installer version 1.8.2-1 they already are.)
+
   2. Check `~/dsp/php/etc/php.ini` to ensure the values `extension=pgsql.so` and `extension=pdo_pgsql.so` are present and uncommented. (In the Bitnami installer they already are.)
 
   3. Check `~/dsp/php/lib/php/extensions/` to ensure `pgsql.so` and `pdo_pgsql.so` are present. (These are included in the Bitnami package.)
 
   3. Check `~/dsp/php/lib/php/extensions/` to ensure `pgsql.so` and `pdo_pgsql.so` are present. (These are included in the Bitnami package.)
 
   4. If you made any changes/additions in steps ii and iii, restart your Apache server.
 
   4. If you made any changes/additions in steps ii and iii, restart your Apache server.
Line 19: Line 17:
  
 
   1. [Install DreamFactory](Install-Mac-OS-X). (The below steps assume a DreamFactory install in `/Applications/dsp/` with its PHP installed in `/Applications/dsp/php/`.)
 
   1. [Install DreamFactory](Install-Mac-OS-X). (The below steps assume a DreamFactory install in `/Applications/dsp/` with its PHP installed in `/Applications/dsp/php/`.)
   2. Check `/Applications/dsp/php/etc/php.ini` to ensure the values `extension=pgsql.so` and `extension=pdo_pgsql.so` are present and uncommented. (In the Bitnami installer version 1.8.2-1 they already are.)
+
   2. Check `/Applications/dsp/php/etc/php.ini` to ensure the values `extension=pgsql.so` and `extension=pdo_pgsql.so` are present and uncommented. (In the Bitnami installer they already are.)
 
   3. Check `/Applications/dsp/php/lib/php/extensions/` to ensure `pgsql.so` and `pdo_pgsql.so` are present. (These are included in the Bitnami package.)
 
   3. Check `/Applications/dsp/php/lib/php/extensions/` to ensure `pgsql.so` and `pdo_pgsql.so` are present. (These are included in the Bitnami package.)
 
   4. If you made any changes/additions in steps ii and iii, restart your Apache server.
 
   4. If you made any changes/additions in steps ii and iii, restart your Apache server.
Line 34: Line 32:
  
 
   1. [Install DreamFactory](Install-Microsoft-Windows). (The below steps assume a DreamFactory install in `C:\dsp\` with its PHP installed in `C:\dsp\php\`.)
 
   1. [Install DreamFactory](Install-Microsoft-Windows). (The below steps assume a DreamFactory install in `C:\dsp\` with its PHP installed in `C:\dsp\php\`.)
   2. Check `C:\dsp\php\php.ini` to ensure the value `extension=php_pdo_pgsql.dll` is present and uncommented. (In the Bitnami installer version 1.8.2-1 it already is.)
+
   2. Check `C:\dsp\php\php.ini` to ensure the value `extension=php_pdo_pgsql.dll` is present and uncommented. (In the Bitnami installer it already is.)
 
   3. Check `C:\dsp\php\ext\` to ensure `php_pdo_pgsql.dll` is present. (This is included in the Bitnami package.)
 
   3. Check `C:\dsp\php\ext\` to ensure `php_pdo_pgsql.dll` is present. (This is included in the Bitnami package.)
 
   4. If you made any changes/additions in steps ii and iii, restart your Apache server.
 
   4. If you made any changes/additions in steps ii and iii, restart your Apache server.

Revision as of 13:48, 27 February 2016

Linux

 1. [Install DreamFactory](Install-on-Linux). (The below steps assume a DreamFactory install in `~/dsp/` with its PHP installed in `~/dsp/php/`.)
 2. Check `~/dsp/php/etc/php.ini` to ensure the values `extension=pgsql.so` and `extension=pdo_pgsql.so` are present and uncommented. (In the Bitnami installer they already are.)
 3. Check `~/dsp/php/lib/php/extensions/` to ensure `pgsql.so` and `pdo_pgsql.so` are present. (These are included in the Bitnami package.)
 4. If you made any changes/additions in steps ii and iii, restart your Apache server.
 5. Login to your DreamFactory Admin Console and create a new [service](Services). 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 `;port=####` (where #### is the actual port number) to the end of your connection string
 6. Click over to the "API Docs" tab, expand your new service, and perform a simple GET request to verify connectivity.

Mac

 1. [Install DreamFactory](Install-Mac-OS-X). (The below steps assume a DreamFactory install in `/Applications/dsp/` with its PHP installed in `/Applications/dsp/php/`.)
 2. Check `/Applications/dsp/php/etc/php.ini` to ensure the values `extension=pgsql.so` and `extension=pdo_pgsql.so` are present and uncommented. (In the Bitnami installer they already are.)
 3. Check `/Applications/dsp/php/lib/php/extensions/` to ensure `pgsql.so` and `pdo_pgsql.so` are present. (These are included in the Bitnami package.)
 4. If you made any changes/additions in steps ii and iii, restart your Apache server.
 5. Login to your DreamFactory Admin Console and create a new [service](Services). 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 `;port=####` (where #### is the actual port number) to the end of your connection string
 6. Click over to the "API Docs" tab, expand your new service, and perform a simple GET request to verify connectivity.

Windows

 1. [Install DreamFactory](Install-Microsoft-Windows). (The below steps assume a DreamFactory install in `C:\dsp\` with its PHP installed in `C:\dsp\php\`.)
 2. Check `C:\dsp\php\php.ini` to ensure the value `extension=php_pdo_pgsql.dll` is present and uncommented. (In the Bitnami installer it already is.)
 3. Check `C:\dsp\php\ext\` to ensure `php_pdo_pgsql.dll` is present. (This is included in the Bitnami package.)
 4. If you made any changes/additions in steps ii and iii, restart your Apache server.
 5. Login to your DreamFactory Admin Console and create a new [service](Services). 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 `;port=####` (where #### is the actual port number) to the end of your connection string
 6. Click over to the "API Docs" tab, expand your new service, and perform a simple GET request to verify connectivity.