Command I use to initialize the database with: /usr/bin/initdb -D /abc/def/pgsql_data Response: The files belonging to this database system will be owned by user "my_user". This user must also own the server process. The database cluster will be initialized with locale C. initdb: directory "/abc/def/pgsql_data" exists but is not empty If you want to create a new database system, either remove or empty the directory "/abc/def/pgsql_data" or run initdb with an argument other than "/abc/def/pgsql_data". As I stated in my original email there is a subdirectory in: "/abc/def/pgsql_data" called "lost+found". 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: Joshua D. Drake [mailto:jd@xxxxxxxxxxxxxxxxx] Sent: Thursday, August 23, 2007 11:59 AM To: Campbell, Lance Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: Installing Postgres -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Campbell, Lance wrote: > This is not an ownership issue. It does try to install PostgreSQL. It > complains because there is a file or directory in the directory where I > am installing PostgreSQL to. The same thing will happen if I create a > directory called XYZ and place a file or directory inside of XYZ and > then try to install the database. *sigh* How about an actual error message and the *exact* command you are typing. Sincerely, Joshua D. Drake > > 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: Joshua D. Drake [mailto:jd@xxxxxxxxxxxxxxxxx] > Sent: Thursday, August 23, 2007 11:48 AM > To: Campbell, Lance > Cc: pgsql-admin@xxxxxxxxxxxxxx > Subject: Re: Installing Postgres > > Campbell, Lance wrote: >> 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 > > It is probably an ownership issue. If this is linux the mount is > probably owned by root. Create a sub directory in pgsql_data that is > owned by postgres called pgsql and install it in there. > > Sincerely, > > Joshua D. Drake > >> 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 > > > > > > - -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 PostgreSQL solutions since 1997 http://www.commandprompt.com/ UNIQUE NOT NULL Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGzbzBATb/zqfZUUQRAr7DAJwJXFJr5Olz8Ebs2Ku08Sv9izXymACgqUOv f/ZsOvjGr4rpHj7KjcSUzAI= =Z3Iu -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org