Tom, In the end I set up the data directory as a subdirectory that had the current version number of PostgreSQL in the name. When I upgrade in the future to a new version of PostgreSQL I will create a new data subdirectory using the new version number in the name. I will then load that database from the prior version. It will make falling back on a prior version easier and more organized. I agree that using a subdirectory is a better strategy. It is nice to know that you can actually move the database by simply moving the files. That does assume you shut down the database first. Thanks, Lance Campbell Project Manager/Software Architect Web Services at Public Affairs University of Illinois 217.333.0382 http://webservices.uiuc.edu -----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Sent: Thursday, August 23, 2007 1:42 PM To: Campbell, Lance Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: Installing Postgres "Campbell, Lance" <lance@xxxxxxxx> writes: > The solution, based on emails I have received, is to install PostgreSQL > into a subdirectory called "data". I then move the contents of "data" > back a directory. This way I am able to have the files in the directory > I want them in. Even though the directory I wanted them in contains a > subdirectory. This is how you get around the issue. NO, NO, NO, NO, NO. You appear to be impervious to several people telling you this is a bad idea, but I will try one more time to explain why. The reason you see "lost+found" in that directory is that it is a volume mount point. Volume mount point directories should *always* be owned by root, for both reliability and security reasons. The setup you are proposing would have to have the mount point directory be postgres-owned. You will live to regret that if you insist on doing it that way (in fact, I'm astonished your sysadmin agreed to it in the first place ... he must be pretty new at his job). Stick with the extra level of directory. > It appears that > the PostgreSQL data directory contents can be moved. Yeah, they can. The argument here is about exactly where you are proposing to move them to. If it were an ordinary directory it'd be fine. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
