Skip site navigation (1) Skip section navigation (2)

Re: Installing Postgres

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: "Campbell, Lance" <lance(at)uiuc(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Installing Postgres
Date: 2007-08-23 17:20:10
Message-ID: 46CDC1CA.4030103@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-admin
-----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(at)commandprompt(dot)com] 
> Sent: Thursday, August 23, 2007 12:10 PM
> To: Campbell, Lance
> Cc: pgsql-admin(at)postgresql(dot)org
> Subject: Re: [ADMIN] 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(at)commandprompt(dot)com] 
>> Sent: Thursday, August 23, 2007 11:59 AM
>> To: Campbell, Lance
>> Cc: pgsql-admin(at)postgresql(dot)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(at)commandprompt(dot)com] 
>>> Sent: Thursday, August 23, 2007 11:48 AM
>>> To: Campbell, Lance
>>> Cc: pgsql-admin(at)postgresql(dot)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

iD8DBQFGzcHKATb/zqfZUUQRAkfOAKCWDKaOqLYE8TRs8CBUW4njiRG3bgCcDW/o
XHUFX4Mc79zybktslrF2km0=
=jz63
-----END PGP SIGNATURE-----

In response to

Responses

pgsql-admin by date

Next:From: Kevin KempterDate: 2007-08-23 17:23:40
Subject: Re: determining which table is being vacuumed by autovacuum (SOLVED)
Previous:From: Campbell, LanceDate: 2007-08-23 17:15:27
Subject: Re: Installing Postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group