Solution:
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. It appears that the PostgreSQL data directory contents can be moved. It is just important to make sure the database is shutdown before moving the data directory contents! Thanks for all of the feedback from everyone.
Thanks,
Lance Campbell
Project Manager/Software Architect
Web Services at Public Affairs
University of Illinois
217.333.0382
http://webservices.uiuc.edu
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Campbell, Lance
Sent: Thursday, August 23, 2007 11:22 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Installing Postgres
OS: redhat linux
Version of PostgreSQL: 8.2.4
I had a group that now manages our server set up a directory/partition for us to put postgreSQL into. The directory is called pgsql_data. The directory is more than a regular directory. It contains a subdirectory called “lost+found”. I would assume this is a logical partition. I tried installing postgreSQL directly into this directory but it failed since there is a file in this directory, “lost+found”. Is there a way around this? Worst case scenario I will create a subdirectory called data and put the install in there. I would have preferred to put it directly into the pgsql_data. There would be no other files that would have gone into the directory/partition other than postgreSQL. Would it be possible for me to install postgreSQL into a sub directory of pgsql_data and then move the files up a directory into pgsql_data?
Thanks,
Lance Campbell
Project Manager/Software Architect
Web Services at Public Affairs
University of Illinois
217.333.0382
http://webservices.uiuc.edu