Campbell, Lance wrote:
Richard, So what you are saying is that if you install PostgeSQL into a data directory /abc/data you could then stop the database, move the files into /def/data, and then start the database making sure to point to the new data directory. PostgreSQL is therefore referencing its files relative to the "data" directory the files are in. Is this a correct observation?
Yes - provided: 1. Ownership and permissions on the destination directory are correct 2. You remember to stop the server when copying -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings