pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
install problem
3+ messages / 2 participants
[nested] [flat]

* install problem
@ 1999-03-14 06:54 Eric J McKeown <ericm@palaver.net>
  0 siblings, 0 replies; 3+ messages in thread

From: Eric J McKeown @ 1999-03-14 06:54 UTC (permalink / raw)
  To: pgsql-sql

Hello folks,

I'm attempting to install Postgres 6.4.2, and everything has gone
beautifully up until the time I try to run initdb.  I'm installing
everything into /home/local/pgsql, and postgres exists as a user, and
postgres owns and has appropriate permissions on /home/local/pgsql and all
files/directories below there.  However, when I attempt to run initdb, I
get this message every time:

Only the unix superuser may initialize a database with a different
Postgres superuser.  (You must be able to create files that belong
to the specified unix user).

I've checked the FAQ, but it doesn't seem to cover this one.  I also have
set up proper paths for the postgres user, so I'm pretty sure that can't
be the problem.  This one has me confused, but I'm willing to bet it's
something someone here has seen many times before (I'm hoping anyway ;)).

TIA.

__________________________________
Eric McKeown, Web Developer 
ericm@palaver.net | (219) 253-8131
Palaver | http://www.palaver.net




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [SQL] install problem
@ 1999-03-15 15:09 Tom Lane <tgl@sss.pgh.pa.us>
  1999-03-15 15:47 ` Re: [SQL] install problem Eric J McKeown <ericm@palaver.net>
  0 siblings, 1 reply; 3+ messages in thread

From: Tom Lane @ 1999-03-15 15:09 UTC (permalink / raw)
  To: Eric J McKeown <ericm@palaver.net>; +Cc: pgsql-sql@hub.org; pgsql-docs@hub.org

Eric J McKeown <ericm@palaver.net> writes:
> when I attempt to run initdb, I get this message every time:
> Only the unix superuser may initialize a database with a different
> Postgres superuser.  (You must be able to create files that belong
> to the specified unix user).

Eric, check the setting of your USER environment variable.  It must be
set and set correctly, because that's what initdb looks at (ditto for
the Postgres regression tests, BTW, and perhaps other stuff).  At least
on my system, USER is not updated by "su", for example.

> I've checked the FAQ, but it doesn't seem to cover this one.

This oughta be mentioned in the documentation somewhere :-(

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [SQL] install problem
  1999-03-15 15:09 Re: [SQL] install problem Tom Lane <tgl@sss.pgh.pa.us>
@ 1999-03-15 15:47 ` Eric J McKeown <ericm@palaver.net>
  0 siblings, 0 replies; 3+ messages in thread

From: Eric J McKeown @ 1999-03-15 15:47 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql@hub.org; pgsql-docs@hub.org

On Mon, 15 Mar 1999, Tom Lane wrote:

> Date: Mon, 15 Mar 1999 10:09:08 -0500
> From: Tom Lane <tgl@sss.pgh.pa.us>
> To: Eric J McKeown <ericm@palaver.net>
> Cc: pgsql-sql@hub.org, pgsql-docs@hub.org
> Subject: Re: [SQL] install problem
> 
> Eric J McKeown <ericm@palaver.net> writes:
> > when I attempt to run initdb, I get this message every time:
> > Only the unix superuser may initialize a database with a different
> > Postgres superuser.  (You must be able to create files that belong
> > to the specified unix user).
> 
> Eric, check the setting of your USER environment variable.  It must be
> set and set correctly, because that's what initdb looks at (ditto for
> the Postgres regression tests, BTW, and perhaps other stuff).  At least
> on my system, USER is not updated by "su", for example.

I figured this one out yesterday, but failed to post that to the group.
When I ran initdb --help, I got a full list of options to initdb, and
specifying postgres as the user with the -u option (I think that was the
one) did the trick.

> 
> > I've checked the FAQ, but it doesn't seem to cover this one.
> 
> This oughta be mentioned in the documentation somewhere :-(

I'd be happy to write a little something up for the FAQ if need be.

Thx.

> 
> 			regards, tom lane
> 

__________________________________
Eric McKeown, Web Developer 
ericm@palaver.net | (219) 253-8131
Palaver | http://www.palaver.net




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~1999-03-15 15:47 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-03-14 06:54 install problem Eric J McKeown <ericm@palaver.net>
1999-03-15 15:09 Re: [SQL] install problem Tom Lane <tgl@sss.pgh.pa.us>
1999-03-15 15:47 ` Eric J McKeown <ericm@palaver.net>

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