PostgreSQL Installation

Revision as of 19:49, 5 May 2016

Linux

1. Install DreamFactory. (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. 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. (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. 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. (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. 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.