CONTINUAL INTEGRATION

Problem scenario
You are running Ubuntu Linux, and you want to create a .php script to be ran at the command prompt like this:

php good.php

You want this to open a PosgreSQL connection and issue a DDL command to create a database.  This is not a PHP web page.

Solution
This solution is only slightly more complicated than using PHP to run a basic SQL query in a Postgres database.

1.  Go to the command prompt of PSQL.  These commands may help you:

sudo -i -u postgres
psql

2.  Create a role from the psql command prompt.  Here is an example:

create role orangeuser;

3.  Alter the role to have the login trait and superuser attribute.

alter role orangeuser login superuser;
\q

4.  Install php5-pgsql or php7.0-pgsql.  It depends on your version of PHP.  Use this command to find out what version of PHP you have:  php --version

To install the php pgsql package on Ubuntu, you should run a command like one of these as root:  
apt-get install php5-pgsql
apt-get install php7.0-pgsql

5.  Create a .php file (e.g., cool.php) with the following as the content:

/* This assumes your server with PHP has access to the server with Postgres.  The IP address in the script is the local loopback.  You may have to change the IP address for this to work.  Naturally you will have to change the database name, the user and password in the PHP script to the credentials for your Postgres instance. */

<?php
   $host        = "host=127.0.0.1";
   $port        = "port=5432";
   $dbname      = "dbname=contint";
   $credentials = "user=jdoe password=softpassword";

   $db = pg_connect( "$host $port $dbname $credentials"  );
   pg_query("CREATE DATABASE foobar");

?>

 6.  Run it like this:  php cool.php

If you want to write a front-end web page to execute a SQL command, see this posting:
How Can You Accept User Input with PHP and Use It in a SQL Command?

Problem scenario
You are trying to use a .php script on the back end to connect to your PostgreSQL database.  However, you get an error like this when you try to run it:

'PHP Warning:  pg_connect(): Unable to connect to PostgreSQL server: FATAL:  role  "funuser" is not permitted to log in in /tmp/d.php on line 7'

How can your .php script log into the Postgres database?

Solution
The user must have the ability to log in.  Log into the PostgreSQL database.  Run this command (where "funuser" is the database role that is hardcoded in the PHP script for the login to work):

alter role funuser login;

Problem scenario
You are trying to use a .php script on the back end to connect to your PostgreSQL database.  However, you get an error like this when you try to run it:  'PHP Fatal error:  Call to undefined function pg_connect() in '

Solution
Install php5-pgsql.  For Ubuntu you would run a command like this:  sudo apt-get install php5-pgsql