We need the pg_user/password question in initdb. This is a know bug.
Only the postgres user can read pg_user currently.
Forwarded message:
> From owner-pgsql-questions@hub.org Sat Feb 7 16:47:03 1998
> Message-Id: <199802072132.QAA28359@hub.org>
> Subject: [QUESTIONS] 6.3 question
> To: pgsql-questions@postgreSQL.org (Postgress Questions Mailing List)
> Date: Sat, 7 Feb 1998 16:32:33 -0500 (EST)
> From: "Stan Brown" <stanb@awod.com>
> X-Mailer: ELM [version 2.4 PL24]
> Mime-Version: 1.0
> Content-Type: text/plain; charset=US-ASCII
> Content-Transfer-Encoding: 7bit
> Sender: owner-pgsql-questions@hub.org
> Precedence: bulk
>
> I have got 6.3 compiled on a deifferent machine than my main postgres
> server. Now I am trying to set ub the database. When I do a \dt. I get
> the folwoing error message:
>
> stan=> \dt
> ERROR: pg_user: Permission denied.
>
> What don't I have set up corectly yet?
>
> This was as a normal user after having done a:
>
> CREATE DATABASE sta;
> CREATE USER stan;
>
> as the postgres super user.
>
> --
> Stan Brown stanb@netcom.com 770-996-6955
> Factory Automation Systems
> Atlanta Ga.
> --
> Look, look, see Windows 95. Buy, lemmings, buy!
> Pay no attention to that cliff ahead... Henry Spencer
> (c) 1998 Stan Brown. Redistribution via the Microsoft Network is prohibited.
>
>
--
Bruce Momjian
maillist@candle.pha.pa.us