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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Separating Databases on Different Partitions



Is there a way to get Postgres to store each database in a separate directory?  I first hoped I could just use symbolic links under the data directory but I have no idea which files are assigned to which database.

The reason I am wanting to do this is that I have a database set up for each user on my server.  I need to put their database under their home directory somewhere so I know how much disk space each user account is taking.  I also need to put the database under the /home partition as it has a lot more space than the partition containing the data directory.

Thanks,
Aaron



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group