postgresql create database different directory

I also intend to run only one cluster on this machine, and wanted it to use the standard port (5432). New clusters will be automatically initialized to use a new port one number higher than the highest existing Postgres port (5433 for the second cluster, 5434 for the third cluster, etc.).

PostgreSQL uses the default port number 5432.This was important, because I had already run a load script overnight to restore a database dumped from a prior version of Postgres/PostGIS. An existing cluster will be added to the list of clusters, rather than reinitialized.Some important points about pg_createcluster: pg_createcluster is used to create a cluster.pg_dropcluster is used (surprise!) to drop an existing cluster.pg_lsclusters is used to list clusters available (whether running or not) on the server.The PostgreSQL documentation on how to customize server start was pretty obtuse.įortunately, Debian-based distros ship with some utilities that allow you to create multiple data clusters, and integrates them all into a multicluster management architecture: But at system boot, the server automatically started using the default data cluster, not the one I had created.

I didn’t have any trouble using initdb to initialize the cluster in the desired location. But it’s fairly common to run a server with a small root partition, and have the database cluster, which can grow very large, on a separate data partition. When you install Postgres on a Debian-based Linux distro (in my case, Linux Mint 18), the installer will automatically create a database cluster with a data directory in /var/lib/postgresql/9.5/main.

Postgresql create database different directory