Skip site navigation (1) Skip section navigation (2)

Re: [SQL] install problem

From: Eric J McKeown <ericm(at)palaver(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-sql(at)hub(dot)org, pgsql-docs(at)hub(dot)org
Subject: Re: [SQL] install problem
Date: 1999-03-15 15:47:27
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-docspgsql-sql
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 |

In response to

pgsql-docs by date

Next:From: Bruce MomjianDate: 1999-03-17 21:36:21
Subject: SGML and HTML
Previous:From: Tom LaneDate: 1999-03-15 15:09:08
Subject: Re: [SQL] install problem

pgsql-sql by date

Next:From: Tim PerdueDate: 1999-03-16 00:39:52
Subject: Re: [SQL] Re: [HACKERS] URGENT -
Previous:From: Bruce MomjianDate: 1999-03-15 15:45:28
Subject: Re: [SQL] How match percent sign in SELECT using LIKE?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group