Skip site navigation (1) Skip section navigation (2)

Re: Another Data directory for second database - feasible?

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: "Tomeh, Husam" <htomeh(at)firstam(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Another Data directory for second database - feasible?
Date: 2005-04-22 17:03:53
Message-ID: 1114189433.13303.65.camel@state.g2switchworks.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Fri, 2005-04-22 at 11:10, Tomeh, Husam wrote:
>  I have a postgres installation with one database on a server. I'd need
> to create another database; however, I'm curious if there's a way to
> create the second database in a different directory than the existing
> one. Is that feasible and how? Or does postgres only point to one data
> directory?  Thanks in advance.

If you're using 8.0, you can use tablespaces.  See:

http://www.postgresql.org/docs/8.0/static/manage-ag-tablespaces.html

If you're using 7.4 or before, you can use alternate locations.  See:

http://www.postgresql.org/docs/7.4/static/manage-ag-alternate-locs.html

In response to

pgsql-admin by date

Next:From: Michael FuhrDate: 2005-04-22 17:15:06
Subject: Re: Another Data directory for second database - feasible?
Previous:From: Michael FuhrDate: 2005-04-22 17:03:45
Subject: Re: Reindex from command line linux

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group