Richard, I was able to prove that it works. Thanks for your time. Lance Campbell Project Manager/Software Architect Web Services at Public Affairs University of Illinois 217.333.0382 http://webservices.uiuc.edu -----Original Message----- From: Richard Huxton [mailto:dev@xxxxxxxxxxxx] Sent: Thursday, August 23, 2007 12:26 PM To: Campbell, Lance Cc: pgsql-performance@xxxxxxxxxxxxxx Subject: Re: Installing PostgreSQL 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 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
