Return-Path: owner-postman 
Delivery-Date: Fri, 08 Apr 94 20:28:45 -0700
Return-Path: owner-postman
Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id RAA05571 for postgres-redist; Fri, 8 Apr 1994 17:44:41 -0700
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199404090044.RAA05571@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from faerie.CS.Berkeley.EDU (faerie.CS.Berkeley.EDU [128.32.149.14]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with ESMTP id RAA05562 for <postgres@postgres.Berkeley.EDU>; Fri, 8 Apr 1994 17:44:40 -0700
Received: from localhost (localhost [127.0.0.1]) by faerie.CS.Berkeley.EDU (8.6.4/8.1B) with SMTP id RAA12526; Fri, 8 Apr 1994 17:44:36 -0700
Message-Id: <199404090044.RAA12526@faerie.CS.Berkeley.EDU>
X-Authentication-Warning: faerie.CS.Berkeley.EDU: Host localhost didn't use HELO protocol
From: aoki@postgres.Berkeley.EDU (Paul M. Aoki)
To: jsrobin@afterlife.ncsc.mil
Cc: postgres@postgres.Berkeley.EDU
Subject: Re: postgres 4.2 beta installation 
Reply-To: aoki@postgres.Berkeley.EDU (Paul M. Aoki)
In-reply-to: Your message of Fri, 8 Apr 1994 19:06:00 -0400 
	     <199404082306.TAA21800@afterlife.ncsc.mil> 
Date: Fri, 08 Apr 94 17:44:36 -0700
X-Sender: aoki@postgres.Berkeley.EDU
Resent-To: postgres-redist@postgres.Berkeley.EDU
X-Mts: smtp
Resent-Date: Fri, 08 Apr 94 17:44:41 -0700
Resent-XMts: smtp

"John S. Robinson" <jsrobin@afterlife.ncsc.mil> writes:
> In each case, initdb completes successfully. In each case when
> 	postmaster is run it core dumps. In each case if I run postmaster
> 	by specifying its full path length, postmaster will run. 

i have no idea what executables you have where in your $PATH, but
the fact that an absolute pathname for postmaster works makes me
wonder..

> In most cases when I attempt to run createdb, I am given an error
> 	message stating that the database model template1 does not exist
> 	(even though initdb completed without complaint).

this indicates that the postmaster is looking in the wrong place 
for its database directory.  this is not detected until runtime.
for example:

faerie:postgres (11)> setenv PGDATA /no/such/directory
faerie:postgres (12)> postmaster&
[1] 12232
faerie:postgres (13)> monitor template1
FATAL 1:Apr  8 16:41:19:database template1 does not exist, bailing out...
faerie:postgres (14)> 

if your environment is such that initdb and the postmaster are working 
in different places (for example, you set PGDATA in one shell and set 
it to something else in another; or if you ran initdb and *then* set
PGDATA) you have an obvious problem.

untangling environment dependencies and inconsistencies is so much
fun.  someone else is having an awful time with the same kind of hair;
the output from regression plainly indicate that the 4.2 regression 
tests are being run on a set of 4.1 binaries/databases (4.1 is also 
installed).  for example, it doesn't understand the new define 
{function,operator, aggregate} syntax or the new array syntax, and 
gives the *exact same* error messages that my copy of 4.1 gives when
presented with the same syntax..  you would like to believe that it's
easy to figure out what's going on in this kind of case, but sometimes 
it isn't..
--
  Paul M. Aoki  |  CS Div., Dept. of EECS, UCB  |  aoki@postgres.Berkeley.EDU
                |  Berkeley, CA 94720           |  ...!uunet!ucbvax!aoki

