Return-Path: mao
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA08248; Thu, 18 Jul 91 18:37:09 -0700
Message-Id: <9107190137.AA08248@postgres.Berkeley.EDU>
From: mao@postgres.Berkeley.EDU (Mike Olson)
Subject: Re: hanging createdb
To: postgres@postgres.berkeley.edu
In-Reply-To: Your message of "Thu, 18 Jul 91 18:08:03 PST."
             <9107190108.AA07829@postgres.Berkeley.EDU> 
Date: Thu, 18 Jul 91 18:36:36 PDT

> I installed Postgres on my machine (Sun 4/370, SunOs 4.1.1), but when I run
> createdb dbname, it hangs.

this appears to happen when you're running createdb, but there's no entry
for you in the pg_user relation.  to fix this, run the following sequence
of commands as user postgres:

	% grep mao /etc/passwd
	mao:*:1806:6:Mike Olson,608-3E,6428072,:/u/mao:/bin/csh
	% monitor template1
	[ ... ]
	Go
	* append pg_user (usename = "mao", usesysid = 1806,
			  usecreatedb = "t"::bool, usetrace = "t"::bool,
			  usesuper = "f"::bool, usecatupd = "t"::bool)
	\g
	APPEND
	* \q
	[ ... ]

replace "mao" with your user name, and 1806 with your uid from /etc/passwd.

let me know if this fixes your problem.  sorry to those of you who have been
hanging on this -- we had a hard time reproducing the problem here, since all
of us are in pg_user all the time.
					mike olson
					postgres research group
					uc berkeley
					mao@postgres.berkeley.edu