PostgreSQL Parallel Queries

Parallel query execution is an exciting new feature introduced in the latest version of PostgreSQL (9.6). Unfortunately this feature is not enabled by default, but this tutorial will show you how to enable it. What are Parallel Queries "Parallel query is a method used to increase the execution speed…

Read this article

Getting Started With Using PostgreSQL in PHP

The first thing you need to do is install PHP and support for PostgreSQL. For ubuntu 16.04 you would need to run: sudo apt-get install php7.0 php7.0-pgsql -y If you haven't already installed a PostgreSQL server and configured it with a password and to allow remote connections,…

Read this article

Configuring PostgreSQL After Installation

Set A Password Login as the default user. sudo -u postgres psql In the CLI, enter: ALTER USER postgres with encrypted password 'my_password'; Use the command \q to exit out of the CLI utility. Ctrl + D also works and is easier to remember, but clashes with byobu. Restart the…

Read this article

PostgreSQL Cheatsheet

CLI Utility Enter the CLI Utility sudo -u username psql The default user is postgres Exiting the CLI Utility \q It is easier just to use the keyboard shortcut Ctrl + D. Switching Database Technically this command does not "switch" database, you are just closing one connection and opening another. \connect…

Read this article

Debian 8 - Install PostgreSQL 9.x

From Debian Packages (9.4) sudo apt-get install postgresql-9.4 -y The output of psql -V will show you version 9.4.9. PostgreSQL Apt Repository (9.6) Use this method if you need the latest release (9.6) which brings with it features like support for parallel queries. echo…

Read this article