pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedInstalling Postgres
17+ messages / 8 participants
[nested] [flat]
* Installing Postgres
@ 2002-08-05 23:32 Mauro <mauroduarte@ig.com.br>
0 siblings, 1 reply; 17+ messages in thread
From: mauroduarte@ig.com.br @ 2002-08-05 23:32 UTC (permalink / raw)
To: pgsql-admin
Hi,
I'm having problems with users authentication in Postgres with linux.
I have a user postgres and others. If in my pg_hba.conf I put
passsword in AUTH_TYPE no users can log in with a message of
authentication failed for user 'username', if I put trust every user
log in without prompt of password and when I put crypt, again every
user log in without prompt of password. I stop and start postgresql
with no errors...
Any ideas ?
Regards,
Mauro
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Installing Postgres
@ 2002-08-06 23:21 Lee Harr <missive@frontiernet.net>
parent: Mauro <mauroduarte@ig.com.br>
0 siblings, 0 replies; 17+ messages in thread
From: Lee Harr @ 2002-08-06 23:21 UTC (permalink / raw)
To: pgsql-admin
In article <b5f11c7e.0208051532.7639f184@posting.google.com>, Mauro wrote:
> Hi,
>
> I'm having problems with users authentication in Postgres with linux.
> I have a user postgres and others. If in my pg_hba.conf I put
> passsword in AUTH_TYPE no users can log in with a message of
> authentication failed for user 'username', if I put trust every user
> log in without prompt of password and when I put crypt, again every
> user log in without prompt of password. I stop and start postgresql
> with no errors...
>
Do the users have passwords?
Did you do something like:
ALTER USER steve WITH PASSWORD 'ht6r&kww';
^ permalink raw reply [nested|flat] 17+ messages in thread
* Installing PostGres
@ 2005-04-19 10:00 Nikhil Pant <nikhilp@tatainteractive.com>
0 siblings, 1 reply; 17+ messages in thread
From: Nikhil Pant @ 2005-04-19 10:00 UTC (permalink / raw)
To: pgsql-admin
Could you tell me whether Novell supports postgres 8.0? Could you tell me the procedure if it does?
DISCLAIMER and CONFIDENTIALITY CAUTION:
This e-mail and any attached files are confidential, proprietary, and may also be legally privileged information, and are intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient of this e-mail, please send it back to the person who sent it to you and delete the e-mail and any attached files and destroy any copies of it; you may call us immediately at + 91 22 5643 8000 or email us at IT-Security@tatainteractive.com
Tata Interactive Systems and/or any of its sister companies owns no responsibility for the views presented in the e-mail and any attached files unless the sender mentions so, with due authority of Tata Interactive Systems.
Unauthorized reading, reproduction, publication, use, dissemination, forwarding, printing or copying of this e-mail and its attachments is prohibited.
We have checked this message for any known viruses; however we decline any liability, in case of any damage caused by a non-detected virus.
For more details about our company, visit http://www.tatainteractive.com.
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Installing PostGres
@ 2005-04-23 11:38 Geoffrey <esoteric@3times25.net>
parent: Nikhil Pant <nikhilp@tatainteractive.com>
0 siblings, 0 replies; 17+ messages in thread
From: Geoffrey @ 2005-04-23 11:38 UTC (permalink / raw)
To: pgsql-admin
Nikhil Pant wrote:
> Could you tell me whether Novell supports postgres 8.0? Could you tell me the procedure if it does?
SuSE 9.3 Professional comes with Postgresql 8.0.1, so I would suspect
they do support it. I'm not sure what version comes with their higher
end (server) products.
Here's a link to the list of packages for 9.3 pro:
http://www.novell.com/products/linuxpackages/professional/diff_cd_dvd.html
I would check there website for more info regarding what comes with
there Enterprise systems:
http://www.novell.com/products/linuxenterpriseserver/packages.html
--
Until later, Geoffrey
^ permalink raw reply [nested|flat] 17+ messages in thread
* Installing Postgres
@ 2007-08-23 16:22 Campbell, Lance <lance@uiuc.edu>
0 siblings, 2 replies; 17+ messages in thread
From: Campbell, Lance @ 2007-08-23 16:22 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Installing Postgres
@ 2007-08-23 16:48 Joshua D. Drake <jd@commandprompt.com>
parent: Campbell, Lance <lance@uiuc.edu>
1 sibling, 1 reply; 17+ messages in thread
From: Joshua D. Drake @ 2007-08-23 16:48 UTC (permalink / raw)
To: Campbell, Lance <lance@uiuc.edu>; +Cc: pgsql-admin
-----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-----
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Installing Postgres
@ 2007-08-23 16:50 Campbell, Lance <lance@uiuc.edu>
parent: Joshua D. Drake <jd@commandprompt.com>
0 siblings, 1 reply; 17+ messages in thread
From: Campbell, Lance @ 2007-08-23 16:50 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; +Cc: pgsql-admin
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-----
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Installing Postgres
@ 2007-08-23 16:58 Joshua D. Drake <jd@commandprompt.com>
parent: Campbell, Lance <lance@uiuc.edu>
0 siblings, 1 reply; 17+ messages in thread
From: Joshua D. Drake @ 2007-08-23 16:58 UTC (permalink / raw)
To: Campbell, Lance <lance@uiuc.edu>; +Cc: pgsql-admin
-----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-----
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Installing Postgres
@ 2007-08-23 17:03 Campbell, Lance <lance@uiuc.edu>
parent: Joshua D. Drake <jd@commandprompt.com>
0 siblings, 1 reply; 17+ messages in thread
From: Campbell, Lance @ 2007-08-23 17:03 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; +Cc: pgsql-admin
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-----
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Installing Postgres
@ 2007-08-23 17:10 Joshua D. Drake <jd@commandprompt.com>
parent: Campbell, Lance <lance@uiuc.edu>
0 siblings, 1 reply; 17+ messages in thread
From: Joshua D. Drake @ 2007-08-23 17:10 UTC (permalink / raw)
To: Campbell, Lance <lance@uiuc.edu>; +Cc: pgsql-admin
-----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-----
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Installing Postgres
@ 2007-08-23 17:15 Campbell, Lance <lance@uiuc.edu>
parent: Joshua D. Drake <jd@commandprompt.com>
0 siblings, 1 reply; 17+ messages in thread
From: Campbell, Lance @ 2007-08-23 17:15 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; +Cc: pgsql-admin
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-----
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Installing Postgres
@ 2007-08-23 17:20 Joshua D. Drake <jd@commandprompt.com>
parent: Campbell, Lance <lance@uiuc.edu>
0 siblings, 1 reply; 17+ messages in thread
From: Joshua D. Drake @ 2007-08-23 17:20 UTC (permalink / raw)
To: Campbell, Lance <lance@uiuc.edu>; +Cc: 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@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-----
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Installing Postgres
@ 2007-08-23 17:42 Tom Lane <tgl@sss.pgh.pa.us>
parent: Joshua D. Drake <jd@commandprompt.com>
0 siblings, 0 replies; 17+ messages in thread
From: Tom Lane @ 2007-08-23 17:42 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; +Cc: Campbell, Lance <lance@uiuc.edu>; pgsql-admin
"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
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Installing Postgres
@ 2007-08-23 17:48 Campbell, Lance <lance@uiuc.edu>
parent: Campbell, Lance <lance@uiuc.edu>
1 sibling, 1 reply; 17+ messages in thread
From: Campbell, Lance @ 2007-08-23 17:48 UTC (permalink / raw)
To: Campbell, Lance <lance@uiuc.edu>; 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@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
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Installing Postgres
@ 2007-08-23 18:41 Tom Lane <tgl@sss.pgh.pa.us>
parent: Campbell, Lance <lance@uiuc.edu>
0 siblings, 1 reply; 17+ messages in thread
From: Tom Lane @ 2007-08-23 18:41 UTC (permalink / raw)
To: Campbell, Lance <lance@uiuc.edu>; +Cc: pgsql-admin
"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
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Installing Postgres
@ 2007-08-23 19:38 Campbell, Lance <lance@uiuc.edu>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 17+ messages in thread
From: Campbell, Lance @ 2007-08-23 19:38 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Installing Postgres
@ 2007-08-24 18:48 Medi Montaseri <montaseri@gmail.com>
parent: Campbell, Lance <lance@uiuc.edu>
0 siblings, 0 replies; 17+ messages in thread
From: Medi Montaseri @ 2007-08-24 18:48 UTC (permalink / raw)
To: Campbell, Lance <lance@uiuc.edu>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; pgsql-admin
Just dont get into the habbit of moving db files around like too
much....filesystems will spead your files all over the place and your
database will slow down....
Medi
On 8/23/07, Campbell, Lance <lance@uiuc.edu> wrote:
>
> 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
>
^ permalink raw reply [nested|flat] 17+ messages in thread
end of thread, other threads:[~2007-08-24 18:48 UTC | newest]
Thread overview: 17+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-08-05 23:32 Installing Postgres Mauro <mauroduarte@ig.com.br>
2002-08-06 23:21 ` Lee Harr <missive@frontiernet.net>
2005-04-19 10:00 Installing PostGres Nikhil Pant <nikhilp@tatainteractive.com>
2005-04-23 11:38 ` Re: Installing PostGres Geoffrey <esoteric@3times25.net>
2007-08-23 16:22 Installing Postgres Campbell, Lance <lance@uiuc.edu>
2007-08-23 16:48 ` Joshua D. Drake <jd@commandprompt.com>
2007-08-23 16:50 ` Campbell, Lance <lance@uiuc.edu>
2007-08-23 16:58 ` Joshua D. Drake <jd@commandprompt.com>
2007-08-23 17:03 ` Campbell, Lance <lance@uiuc.edu>
2007-08-23 17:10 ` Joshua D. Drake <jd@commandprompt.com>
2007-08-23 17:15 ` Campbell, Lance <lance@uiuc.edu>
2007-08-23 17:20 ` Joshua D. Drake <jd@commandprompt.com>
2007-08-23 17:42 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-08-23 17:48 ` Campbell, Lance <lance@uiuc.edu>
2007-08-23 18:41 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-08-23 19:38 ` Campbell, Lance <lance@uiuc.edu>
2007-08-24 18:48 ` Medi Montaseri <montaseri@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox