PostgreSQL with different data directories

Question

Today I installed PostgreSQL to work with. When I was reading the documentation, I found there can be more than one data directory present. Is it more than one data directory for single installation ? Or I understood wrongly ?

In my installation, data directory is in

C:\Program Files\PostgreSQL\8.3\data

if it can be more than one data directory for single installation, how will be the directory structure ?

Frank Heikens · Accepted Answer · 2012-10-17 15:10:59Z

5

I think you mean a tablespace, please check the manual: CREATE TABLESPACE

answered Oct 17, 2012 at 15:10

Frank Heikens

129k26 gold badges157 silver badges153 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Craig Ringer · Accepted Answer · 2012-10-17 22:33:14Z

4

There can be only one data directory for each PostgreSQL cluster. A cluster is a postmaster listening on a port, managing several databases from a single data directory. You can have multiple clusters by starting multiple postmasters with pg_ctl or via a system service, each listening on a different port and using a different data dir.

If you have multiple clusters on a machine you have multiple data directories. It's unusual to need to do this, but it is possible.

It would be immensely helpful if you'd link to the documents you're talking about when asking questions about them.

answered Oct 17, 2012 at 22:33

Craig Ringer

329k83 gold badges742 silver badges820 bronze badges

Collectives™ on Stack Overflow

PostgreSQL with different data directories

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related