-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Campbell, Lance wrote: > Joshua, > As I stated in my original email I know I can install the database in a > subdirectory of /abc/def/pgsql_data. I know that. You can not install into a mount point. That is your problem. That is what the lost+found is telling you, that it is a mount point. You *must* install into a directory on the mount point. Which is why I gave you the solution I did. > > Let me ask this of the listserv: Is it possible to install the > PostgreSQL database in a directory and then move the directory later? Yes, if you follow what I said above. > > Example: I install PostgreSQL to /abc/data can I move the files then to > /def/data? If data is *not a mount point* yes, but you will want to move the whole directory (with special cases for pg_log, and pg_xlog). 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 12:10 PM > To: Campbell, Lance > Cc: pgsql-admin@xxxxxxxxxxxxxx > Subject: Re: Installing Postgres > > Campbell, Lance wrote: >> 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". > > My solution still applies: > > mkdir pgsql_data/pgsql > chown -R postgres.postgres pgsql_data/pgsql > initdb -D pgsql_data/pgsql/data > > 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:59 AM >> To: Campbell, Lance >> Cc: pgsql-admin@xxxxxxxxxxxxxx >> Subject: Re: Installing Postgres > >> 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 iD8DBQFGzcHKATb/zqfZUUQRAkfOAKCWDKaOqLYE8TRs8CBUW4njiRG3bgCcDW/o XHUFX4Mc79zybktslrF2km0= =jz63 -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
