Hi All We are running an old version of PostgreSQL on a Linux Server. We have created a few databases on the file system defined in the postgresql.conf, but now I would like to create another database within the same cluster but on a different file system. Is this possible and if so, how do we go about it.
In a nutshell: I have the following statement defined in the postgresql.conf file - data_directory = '/opt/pgdata_postgres' I have created the following database datadb1, datadb2 (plus all default databases) Now I want to create a third database datadb3, but it needs to be created on file system "/opt/pgdata1_postgres" and not on '/opt/pgdata_postgres' Is this possible Regards Ian
