Re: Installing Postgres

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Campbell, Lance
Sent: Thursday, August 23, 2007 11:22 AM
To: pgsql-admin@xxxxxxxxxxxxxx
Subject: 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

 


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux