CODEWITHSUNDEEP
postgresql
Srikanth Mudale
Srikanth Mudale

Reputation: 205

Store postgres database at some other location other than data folder

Is there any way of storing database other than the fixed data directory in postgres? I have a situation where I need to store database at any location irrespective of data directory.

Upvotes: 3

Views: 1094

Answers (2)

jcaron
jcaron

Reputation: 17710

You can add a tablespace.

A tablespace is basically a location to store databases and/or tables. You create a tablespace using CREATE TABLESPACE:

CREATE TABLESPACE mytablespace LOCATION '/path/to/some/location';

You can then create tables directly in that tablespace:

CREATE TABLE whatever (thing integer) TABLESPACE mytablespace;

Or set the default tablespace:

SET default_tablespace = mytablespace;

You can also set the default tablespace at database creation time:

CREATE DATABASE mydatabase TABLESPACE mytablespace;

Upvotes: 2

SMBee
SMBee

Reputation: 11

You are looking for the 'Data Directory' in linux for example its in

/usr/local/pgsql/data

if you install from source code. Each distribution is different though, try reading up on

File Locations in postgres and Creating a Database Cluster

also try using the query

show data_directory;

in windows try looking around

C:\Program Files (x86)\PostgreSQL\[VERSION]\data\global

Upvotes: 0

Related Questions