I have an existing database located on /loc/data. I want to move the data directory to it's own partition. What are the steps to accomplish this task? I have tried numerous configurations such as stopping the db, moving the db to /data then exporting PGDATA to /data. The server will not connect thorugh PGADMIN.
How do I get PGADMIN to see the PGDATA files? What are all of the config files if any that need to be changed? Do I need to run initdb? I did try this and recieved an error that there was data in the directory. Do I need to initdb then move the data over?
Please advise, Missymadi