On Mon, 15 Mar 1999, Tom Lane wrote:
> Date: Mon, 15 Mar 1999 10:09:08 -0500
> From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> To: Eric J McKeown <ericm(at)palaver(dot)net>
> Cc: pgsql-sql(at)hub(dot)org, pgsql-docs(at)hub(dot)org
> Subject: Re: [SQL] install problem
> Eric J McKeown <ericm(at)palaver(dot)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.
> regards, tom lane
Eric McKeown, Web Developer
ericm(at)palaver(dot)net | (219) 253-8131
Palaver | http://www.palaver.net
In response to
pgsql-docs by date
|Next:||From: Bruce Momjian||Date: 1999-03-17 21:36:21|
|Subject: SGML and HTML|
|Previous:||From: Tom Lane||Date: 1999-03-15 15:09:08|
|Subject: Re: [SQL] install problem|
pgsql-sql by date
|Next:||From: Tim Perdue||Date: 1999-03-16 00:39:52|
|Subject: Re: [SQL] Re: [HACKERS] URGENT -|
|Previous:||From: Bruce Momjian||Date: 1999-03-15 15:45:28|
|Subject: Re: [SQL] How match percent sign in SELECT using LIKE?|