Postgres Pro
Downloads
Home   >   mailing lists

Creating a new database on a different file system - Mailing list pgsql-general

From Ian Dauncey
Subject Creating a new database on a different file system
Date
Msg-id AS8PR08MB829778001E6F10552A6C4CEBC0DF2@AS8PR08MB8297.eurprd08.prod.outlook.com
Whole thread Raw
Responses Re: Creating a new database on a different file system
Re: Creating a new database on a different file system
List pgsql-general
Tree view

Hi All

 

We are running an old version of PostgreSQL on a Linux Server.

We have created a few databases on the file system defined in the postgresql.conf, but now I would like to create another database within the same cluster but on a different file system.

Is this possible and if so, how do we go about it.

 

In a nutshell:

 

I have the following statement defined in the postgresql.conf file - data_directory = '/opt/pgdata_postgres'

 

I have created the following database datadb1, datadb2 (plus all default databases)

 

Now I want to create a third database datadb3, but it needs to be created on file system “/opt/pgdata1_postgres”  and not on ‘/opt/pgdata_postgres'

 

Is this possible

 

Regards

Ian

 

 

pgsql-general by date:

Previous
From: Sebastien Flaesch
Date:
Subject: Re: After upgrading libpq, the same function(PQftype) call returns a different OID
Next
From: Luca Ferrari
Date:
Subject: Re: Creating a new database on a different file system