View Single Post

   
  #1 (permalink)  
Old 04-10-2008, 07:14 AM
Aaron Bono
 
Posts: n/a
Default 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

Reply With Quote