Обсуждение: 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
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 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 iD8DBQFGzbpEATb/zqfZUUQRAjxKAJ43ucUbt5G5GmxzlqJ8tmHrOxfGfwCaAsj1 F4Rq/EaDnM7ZB691p2R+mAo= =U+lm -----END PGP SIGNATURE-----
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. 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 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 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 iD8DBQFGzbpEATb/zqfZUUQRAjxKAJ43ucUbt5G5GmxzlqJ8tmHrOxfGfwCaAsj1 F4Rq/EaDnM7ZB691p2R+mAo= =U+lm -----END PGP SIGNATURE-----
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 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 iD8DBQFGzbzBATb/zqfZUUQRAr7DAJwJXFJr5Olz8Ebs2Ku08Sv9izXymACgqUOv f/ZsOvjGr4rpHj7KjcSUzAI= =Z3Iu -----END PGP SIGNATURE-----
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". 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 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 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 iD8DBQFGzbzBATb/zqfZUUQRAr7DAJwJXFJr5Olz8Ebs2Ku08Sv9izXymACgqUOv f/ZsOvjGr4rpHj7KjcSUzAI= =Z3Iu -----END PGP SIGNATURE-----
-----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-----
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. Let me ask this of the listserv: Is it possible to install the PostgreSQL database in a directory and then move the directory later? Example: I install PostgreSQL to /abc/data can I move the files then to /def/data? 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 12:10 PM To: Campbell, Lance Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Installing Postgres -----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-----
-----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@commandprompt.com] > Sent: Thursday, August 23, 2007 12:10 PM > To: Campbell, Lance > Cc: pgsql-admin@postgresql.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@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 iD8DBQFGzcHKATb/zqfZUUQRAkfOAKCWDKaOqLYE8TRs8CBUW4njiRG3bgCcDW/o XHUFX4Mc79zybktslrF2km0= =jz63 -----END PGP SIGNATURE-----
"Joshua D. Drake" <jd@commandprompt.com> writes: > Campbell, Lance wrote: >> 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. Right. If the mount directory isn't root-owned, it *should* be --- your sysadmin erred by making it postgres-owned. The correct configuration is root-owned mount point, root-owned lost+found under it, also postgres-owned data directory under it. regards, tom lane
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@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Campbell, Lance
Sent: Thursday, August 23, 2007 11:22 AM
To: pgsql-admin@postgresql.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
"Campbell, Lance" <lance@uiuc.edu> writes: > 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. NO, NO, NO, NO, NO. You appear to be impervious to several people telling you this is a bad idea, but I will try one more time to explain why. The reason you see "lost+found" in that directory is that it is a volume mount point. Volume mount point directories should *always* be owned by root, for both reliability and security reasons. The setup you are proposing would have to have the mount point directory be postgres-owned. You will live to regret that if you insist on doing it that way (in fact, I'm astonished your sysadmin agreed to it in the first place ... he must be pretty new at his job). Stick with the extra level of directory. > It appears that > the PostgreSQL data directory contents can be moved. Yeah, they can. The argument here is about exactly where you are proposing to move them to. If it were an ordinary directory it'd be fine. regards, tom lane
Tom, In the end I set up the data directory as a subdirectory that had the current version number of PostgreSQL in the name. When I upgrade in the future to a new version of PostgreSQL I will create a new data subdirectory using the new version number in the name. I will then load that database from the prior version. It will make falling back on a prior version easier and more organized. I agree that using a subdirectory is a better strategy. It is nice to know that you can actually move the database by simply moving the files. That does assume you shut down the database first. 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: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Thursday, August 23, 2007 1:42 PM To: Campbell, Lance Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Installing Postgres "Campbell, Lance" <lance@uiuc.edu> writes: > 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. NO, NO, NO, NO, NO. You appear to be impervious to several people telling you this is a bad idea, but I will try one more time to explain why. The reason you see "lost+found" in that directory is that it is a volume mount point. Volume mount point directories should *always* be owned by root, for both reliability and security reasons. The setup you are proposing would have to have the mount point directory be postgres-owned. You will live to regret that if you insist on doing it that way (in fact, I'm astonished your sysadmin agreed to it in the first place ... he must be pretty new at his job). Stick with the extra level of directory. > It appears that > the PostgreSQL data directory contents can be moved. Yeah, they can. The argument here is about exactly where you are proposing to move them to. If it were an ordinary directory it'd be fine. regards, tom lane
Medi
Tom,
It is nice to know that you can actually move the database by simply
moving the files. That does assume you shut down the database first.
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: Tom Lane [mailto: tgl@sss.pgh.pa.us]
Sent: Thursday, August 23, 2007 1:42 PM
To: Campbell, Lance
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Installing Postgres
"Campbell, Lance" <lance@uiuc.edu> writes:
> 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.
NO, NO, NO, NO, NO.
You appear to be impervious to several people telling you this is a
bad idea, but I will try one more time to explain why. The reason you
see "lost+found" in that directory is that it is a volume mount point.
Volume mount point directories should *always* be owned by root, for
both reliability and security reasons. The setup you are proposing
would have to have the mount point directory be postgres-owned.
You will live to regret that if you insist on doing it that way
(in fact, I'm astonished your sysadmin agreed to it in the first
place ... he must be pretty new at his job).
Stick with the extra level of directory.
> It appears that
> the PostgreSQL data directory contents can be moved.
Yeah, they can. The argument here is about exactly where you are
proposing to move them to. If it were an ordinary directory it'd be
fine.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match