I am using AWS as my cloud environment. I installed PostgreSQL on the same drive as my root instance volume. I have attached and mounted the second drive to my instance. Now I want to move all my PostgreSQL data to the different drive. I am still in development mode so I can delete the old data if it makes transfer easier at this point of time. What is the best way to do this?
Is PostgreSQL tablespace something which I should look at?
Best Answer
The following should do it:
This is usually defined through a commandline parameter (
-D
) for your service or through thePGDATA
environment variable.