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