Thread: Installing PostgreSQL
Should installation questions be sent here or to the admin listserv?
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
Campbell, Lance wrote: > Should installation questions be sent here or to the admin listserv? Probably the pgsql-general/admin/novice lists > OS: redhat linux RHES? > Version of PostgreSQL: 8.2.4 OK > 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. No - if you get filesystem corruption any recovered disk-blocks are put into files here. All your disk partitions will have such a directory. > 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. That's what you want to do. Apart from anything else it lets you set ownership & permission of the directory. > 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? Just symlink your directory to the correct place if that's what you want. Partition at: /mnt/pg_disk Directory is: /mnt/pg_disk/data symlink to: /var/db/data -- Richard Huxton Archonet Ltd
Richard, So what you are saying is that if you install PostgeSQL into a data directory /abc/data you could then stop the database, move the files into /def/data, and then start the database making sure to point to the new data directory. PostgreSQL is therefore referencing its files relative to the "data" directory the files are in. Is this a correct observation? 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: Richard Huxton [mailto:dev@archonet.com] Sent: Thursday, August 23, 2007 12:08 PM To: Campbell, Lance Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Installing PostgreSQL Campbell, Lance wrote: > Should installation questions be sent here or to the admin listserv? Probably the pgsql-general/admin/novice lists > OS: redhat linux RHES? > Version of PostgreSQL: 8.2.4 OK > 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. No - if you get filesystem corruption any recovered disk-blocks are put into files here. All your disk partitions will have such a directory. > 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. That's what you want to do. Apart from anything else it lets you set ownership & permission of the directory. > 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? Just symlink your directory to the correct place if that's what you want. Partition at: /mnt/pg_disk Directory is: /mnt/pg_disk/data symlink to: /var/db/data -- Richard Huxton Archonet Ltd
On Thu, 23 Aug 2007, Campbell, Lance wrote: > Should installation questions be sent here or to the admin listserv? admin or general would be more appropriate for this type of question. > 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. It's a partition of some sort. lost+found shows up in the root directory of any partition you create, it's where damaged files found by fsck go. See http://tldp.org/LDP/Linux-Filesystem-Hierarchy/html/lostfound.html for more information. > 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. You will have to create subdirectory in this new partition in order for initdb to have a place it can work in. What you should probably do here is have your administrator rename the mount point to something more generic, like "data" or "postgres", to avoid confusion here; then you'd have PGDATA pointing to data/pgsql_data or postgres/pgsql_data which won't be as confusing. -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
Campbell, Lance wrote: > Richard, > So what you are saying is that if you install PostgeSQL into a data > directory /abc/data you could then stop the database, move the files > into /def/data, and then start the database making sure to point to the > new data directory. PostgreSQL is therefore referencing its files > relative to the "data" directory the files are in. > > Is this a correct observation? Yes - provided: 1. Ownership and permissions on the destination directory are correct 2. You remember to stop the server when copying -- Richard Huxton Archonet Ltd
Richard, I was able to prove that it works. Thanks for your time. Lance Campbell Project Manager/Software Architect Web Services at Public Affairs University of Illinois 217.333.0382 http://webservices.uiuc.edu -----Original Message----- From: Richard Huxton [mailto:dev@archonet.com] Sent: Thursday, August 23, 2007 12:26 PM To: Campbell, Lance Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Installing PostgreSQL Campbell, Lance wrote: > Richard, > So what you are saying is that if you install PostgeSQL into a data > directory /abc/data you could then stop the database, move the files > into /def/data, and then start the database making sure to point to the > new data directory. PostgreSQL is therefore referencing its files > relative to the "data" directory the files are in. > > Is this a correct observation? Yes - provided: 1. Ownership and permissions on the destination directory are correct 2. You remember to stop the server when copying -- Richard Huxton Archonet Ltd