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

Re: Installing Postgres

From: "Campbell, Lance" <lance(at)uiuc(dot)edu>
To: "Campbell, Lance" <lance(at)uiuc(dot)edu>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: Installing Postgres
Date: 2007-08-23 17:48:17
Message-ID: B10E6810AC2A2F4EA7550D072CDE8760197D2F@SAB-FENWICK.sab.uiuc.edu (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Campbell, Lance
Sent: Thursday, August 23, 2007 11:22 AM
To: pgsql-admin(at)postgresql(dot)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

 

In response to

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2007-08-23 18:41:52
Subject: Re: Installing Postgres
Previous:From: Tom LaneDate: 2007-08-23 17:42:50
Subject: Re: Installing Postgres

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