Thread

[QUESTIONS] 6.3 question (fwd)

Bruce Momjian <maillist@candle.pha.pa.us> — 1998-02-07T21:51:41Z

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