PostgreSQL

From DreamFactory
Jump to: navigation, search
m (Converted from Markdown to MediaWiki)
Line 1: Line 1:
Linux
+
== Linux ==
  
  1. [Install DreamFactory](Install-on-Linux). (The below steps assume a DreamFactory install in `~/dsp/` with its PHP installed in `~/dsp/php/`.)
+
# [[Install-on-Linux|Install DreamFactory]]. (The below steps assume a DreamFactory install in <code>~/dsp/</code> with its PHP installed in <code>~/dsp/php/</code>.)
  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.)
+
# Check <code>~/dsp/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.)
  3. Check `~/dsp/php/lib/php/extensions/` to ensure `pgsql.so` and `pdo_pgsql.so` are present. (These are included in the Bitnami package.)
+
# Check <code>~/dsp/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.)
  4. If you made any changes/additions in steps ii and iii, restart your Apache server.
+
# 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.
+
# Login to your DreamFactory Admin Console and create a new [[Services|service]]. Enter the following, then click Save at the bottom of the page.
    * Type: Remote SQL DB
+
#* Type: Remote SQL DB
    * Username and Password: valid credentials to your PostgreSQL DB
+
#* Username and Password: valid credentials to your PostgreSQL DB
    * SQL Vendor: PostgreSQL
+
#* SQL Vendor: PostgreSQL
    * Host: hostname or IP of your PostgreSQL server (localhost if appropriate)
+
#* Host: hostname or IP of your PostgreSQL server (localhost if appropriate)
    * Database Name: name of the PostgreSQL DB
+
#* 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
+
#* 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
  6. Click over to the "API Docs" tab, expand your new service, and perform a simple GET request to verify connectivity.
+
# Click over to the “API Docs” tab, expand your new service, and perform a simple GET request to verify connectivity.
  
Mac
+
== 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/`.)
+
# [[Install-Mac-OS-X|Install DreamFactory]]. (The below steps assume a DreamFactory install in <code>/Applications/dsp/</code> with its PHP installed in <code>/Applications/dsp/php/</code>.)
  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.)
+
# Check <code>/Applications/dsp/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.)
  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.)
+
# Check <code>/Applications/dsp/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.)
  4. If you made any changes/additions in steps ii and iii, restart your Apache server.
+
# 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.
+
# Login to your DreamFactory Admin Console and create a new [[Services|service]]. Enter the following, then click Save at the bottom of the page.
    * Type: Remote SQL DB
+
#* Type: Remote SQL DB
    * Username and Password: valid credentials to your PostgreSQL DB
+
#* Username and Password: valid credentials to your PostgreSQL DB
    * SQL Vendor: PostgreSQL
+
#* SQL Vendor: PostgreSQL
    * Host: hostname or IP of your PostgreSQL server (localhost if appropriate)
+
#* Host: hostname or IP of your PostgreSQL server (localhost if appropriate)
    * Database Name: name of the PostgreSQL DB
+
#* 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
+
#* 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
  6. Click over to the "API Docs" tab, expand your new service, and perform a simple GET request to verify connectivity.
+
# Click over to the “API Docs” tab, expand your new service, and perform a simple GET request to verify connectivity.
  
Windows
+
== 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\`.)
+
# [[Install-Microsoft-Windows|Install DreamFactory]]. (The below steps assume a DreamFactory install in <code>C:\dsp\</code> with its PHP installed in <code>C:\dsp\php\</code>.)
  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.)
+
# Check <code>C:\dsp\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.)
  3. Check `C:\dsp\php\ext\` to ensure `php_pdo_pgsql.dll` is present. (This is included in the Bitnami package.)
+
# Check <code>C:\dsp\php\ext\</code> to ensure <code>php_pdo_pgsql.dll</code> 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.
+
# 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.
+
# Login to your DreamFactory Admin Console and create a new [[Services|service]]. Enter the following, then click Save at the bottom of the page.
    * Type: Remote SQL DB
+
#* Type: Remote SQL DB
    * Username and Password: valid credentials to your PostgreSQL DB
+
#* Username and Password: valid credentials to your PostgreSQL DB
    * SQL Vendor: PostgreSQL
+
#* SQL Vendor: PostgreSQL
    * Host: hostname or IP of your PostgreSQL server (localhost if appropriate)
+
#* Host: hostname or IP of your PostgreSQL server (localhost if appropriate)
    * Database Name: name of the PostgreSQL DB
+
#* 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
+
#* 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
  6. Click over to the "API Docs" tab, expand your new service, and perform a simple GET request to verify connectivity.
+
# Click over to the “API Docs” tab, expand your new service, and perform a simple GET request to verify connectivity.

Revision as of 19:41, 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.