PostgreSQL is available to download and install for free from https://www.postgresql.org/download/. Install PostgreSQL on Windows https://www.postgresql.org/download/windows/ Install the database software using Windows Installer given there. On a Windows machine, PostgreSQL. read more…
Continue Reading
Connecting to PostgreSQL – Basics
Here, we will take a look at the basic method of connecting to the PostgreSQL cluster running on the local server using command psql. Connection to a PostgreSQL database can. read more…
Continue Reading
Creating and Managing Users/Roles
The entity of the user is almost the same as the entity of the role in PostgreSQL. The commands to create these are CREATE USER and CREATE RULE. CREATE USER is. read more…
Continue Reading
Creating and Managing Databases
A PostgreSQL cluster can have many databases, in addition to default databases created as part of the cluster creation. A new database inside the PostgreSQL cluster can be created in. read more…
Continue Reading
Restricting Role access to Databases
A user or role is created at the PostgreSQL cluster level and it is available or visible inside all the databases. By default, the new role will be able to. read more…
Continue Reading
Creating and Managing Cluster with native commands
PostgreSQL has 2 important native binary executables or commands, initdb and pg_ctl to create and manage the PostgreSQL clusters. Then, there is another executable, pg_controldata, to view a lot of. read more…
Continue Reading
Creating and Managing Cluster with pg wrappers (Ubuntu only)
There are few Ubuntu-specific wrapper binaries/commands which wrap the PostgreSQL’s inbuilt commands initdb (initialize a new cluster) and pg_ctl (control the cluster). We will go through initdb and pg_ctl in. read more…
Continue Reading
Installing PostgreSQL
PostgreSQL is available to download and install for free from https://www.postgresql.org/download/. Install PostgreSQL on Windows https://www.postgresql.org/download/windows/ Install the database software using Windows Installer given there. On a Windows machine, PostgreSQL. read more…
Continue Reading
Overview of PostgreSQL
PostgreSQL is an open-source object-relational database system. In many aspects, it is similar to other RDBMS systems. But it is quite different too in many aspects. It has been used. read more…
Continue Reading
Connecting from psql in different ways
One can connect to the database in various ways from psql. One can pass the whole connection string or connection details on the psql command line. Let’s go through such. read more…
Continue Reading
Connecting using Environment Variables
All connection parameters can be defined as operating system environment variables and then just ‘psql’ can be run to connect to the database. A full list of such variables is. read more…
Continue Reading