Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [206.210.65.6]) by hub.org (8.9.2/8.9.1) with ESMTP id KAA45498; Mon, 15 Mar 1999 10:10:17 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id KAA13203; Mon, 15 Mar 1999 10:09:08 -0500 (EST) To: Eric J McKeown cc: pgsql-sql@hub.org, pgsql-docs@hub.org Subject: Re: [SQL] install problem In-reply-to: Your message of Sun, 14 Mar 1999 23:00:29 -0500 (EST) <199903150400.XAA74226@hub.org> Date: Mon, 15 Mar 1999 10:09:08 -0500 Message-ID: <13201.921510548@sss.pgh.pa.us> From: Tom Lane Eric J McKeown 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