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