Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 425419FA366 for ; Thu, 23 Aug 2007 14:10:08 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 60637-01 for ; Thu, 23 Aug 2007 14:10:02 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id A671F9FA362 for ; Thu, 23 Aug 2007 14:10:03 -0300 (ADT) Received: from [192.168.1.50] (or-67-76-146-141.sta.embarqhsd.net [67.76.146.141]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l7NHA4Wr017389 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Thu, 23 Aug 2007 10:10:04 -0700 Message-ID: <46CDBF6F.7050507@commandprompt.com> Date: Thu, 23 Aug 2007 10:10:07 -0700 From: "Joshua D. Drake" User-Agent: Thunderbird 1.5.0.12 (X11/20070604) MIME-Version: 1.0 To: "Campbell, Lance" CC: pgsql-admin@postgresql.org Subject: Re: Installing Postgres References: <46CDBA44.2080802@commandprompt.com> <46CDBCC1.2010009@commandprompt.com> In-Reply-To: X-Enigmail-Version: 0.94.2.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV 0.91.1/4032/Wed Aug 22 13:15:27 2007 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Thu, 23 Aug 2007 10:10:05 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/293 X-Sequence-Number: 26624 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 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@commandprompt.com] > Sent: Thursday, August 23, 2007 11:59 AM > To: Campbell, Lance > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] 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@commandprompt.com] >> Sent: Thursday, August 23, 2007 11:48 AM >> To: Campbell, Lance >> Cc: pgsql-admin@postgresql.org >> Subject: Re: [ADMIN] 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 iD8DBQFGzb9vATb/zqfZUUQRAvBUAJ0afVRD/Tt2vR0LBo6LcQyEvbYKvACgjUns iL7APXC+v3e6YslHCUbCjak= =MxlM -----END PGP SIGNATURE-----