PostgreSQ L> PHP Connection

Connection to PostgreSQL for PHP Applications

Follow the instruction below to learn how to connect your PHP application, hosted within GPUonCLOUD Cloud, to the PostgreSQL database server.

Create Environment

1. Log into the GPUonCLOUD.

2. Create PHP environment with PostgreSQL database:


3. Check your e-mail - your inbox should have a message with database login and password.

Now, you can upload your PHP application package and deploy it to the environment.

Database Connection

  1. Click Config button for your Apache server.


2. Navigate to etc folder and open php.ini file.

3. Add line after, like it is shown in the image below:

4. Save the changes and Restart nodes for Apache server.


5. There are 2 main PG functions for connection:

    • Connection to your postgresql database:

pg_connect ("host=host_address port=5432 dbname=postgres user=webadmin password=password");

  • host - Postgres server address that you received by email (note that it must be without http://): 

  • port - by default 5432

  • dbname - name of your database

  • user - by default is "webadmin"

  • password - the password that you received via email

  • Closing connection to postgresql database: pg_close()

All Postgres functions you can see here.

6. You need to write necessary functions in every *.php page, which should be connected to the database.

Connection Check Up

  • check the connection using this code:


$dbconn = pg_connect(" port=5432 dbname=postgres-demo user=webadmin password=password");

//connect to a database named "postgres" on the host "host" with a username and password

if (!$dbconn){

echo "<center><h1>Doesn't work =(</h1></center>";


 echo "<center><h1>Good connection</h1></center>";



  • execute simple request and output it into table:


$conn = pg_connect(" port=5432 dbname=postgres-demo user=webadmin password=password");

if (!$conn) {

 echo "An error occured.\n";



$result = pg_query($conn, "SELECT * FROM test_table");

if (!$result) {

 echo "An error occured.\n";



while ($row = pg_fetch_row($result)) {

echo "value1: $row[0]  value2: $row[1]";

echo "<br />\n";



Now, you can use connection to PostgreSQL database for your PHP application.



  • Connection to PostgreSQL for PHP Applications, Create Environment, Database Connection, Connection Check Up
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

PHP Accelerators

A PHP accelerator is a PHP extension designed to improve the performance of software applications...

PHP security settings

PHP.INI Security Settings There are several PHP functions, which are recommended to be properly...

Deploy PHP Project > via Archive / URL

Upload and Deploy Your PHP Application In GPUonCLOUD there is the automatic function of the...

Ion cube Loader

Running Encoded PHP Scripts with ionCube Loader Encoding application sources is a common...

MariaDB > PHP connection

Connection to MySQL/MariaDB for PHP MySQL and MariaDB are highly popular open source...