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.