Return-Path: owner-postman Delivery-Date: Fri, 06 May 94 19:07:14 -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 RAA14816 for postgres-redist; Fri, 6 May 1994 17:28:01 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199405070028.RAA14816@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 RAA14806 for ; Fri, 6 May 1994 17:28:00 -0700 Received: from localhost (localhost [127.0.0.1]) by faerie.CS.Berkeley.EDU (8.6.4/8.1B) with SMTP id RAA24525; Fri, 6 May 1994 17:27:58 -0700 Message-Id: <199405070027.RAA24525@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: Mike_Spreitzer.PARC@xerox.com Cc: postgres@postgres.Berkeley.EDU Subject: Re: database template1 does not exist, bailing out Reply-To: aoki@postgres.Berkeley.EDU (Paul M. Aoki) In-reply-to: Your message of Fri, 6 May 1994 16:58:59 PDT <94May6.165919pdt.14541(2)@alpha.xerox.com> Date: Fri, 06 May 94 17:27:58 -0700 X-Sender: aoki@postgres.Berkeley.EDU Resent-To: postgres-redist@postgres.Berkeley.EDU X-Mts: smtp Resent-Date: Fri, 06 May 94 17:28:00 -0700 Resent-XMts: smtp Mike_Spreitzer.PARC@xerox.com writes: > postgres@saratoga % createuser spreitze > FATAL 1:May 6 23:36:18:database template1 does not exist, bailing out... > createuser: database access failed. > postgres@saratoga % pwd > /tmp_mnt/project/ubi/bayou/dbs/pg4.2b/src createuser is just a script that calls monitor, so it obeys the same environment variables (PGPORT, PGHOST, etc.) if monitor works and createuser doesn't, that would indeed be pretty strange. i've run into some strange situations with nfs on suns (using regular mounts, not even using automount) in the past. it got to the point where i just gave up and started running all tests on suns on local disk. the symptom was similar -- you'd start a postmaster, things ran fine interactively, then you do "bmake runtest" in regress and you'd get "database regress does not exist" or somesuch. moving onto a local filesystem cleared the problem up for me.. -- Paul M. Aoki | CS Div., Dept. of EECS, UCB | aoki@postgres.Berkeley.EDU | Berkeley, CA 94720 | ...!uunet!ucbvax!aoki =============================================================================== To add/remove yourself from the POSTGRES mailing list: send mail with the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU" If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and a human will deal with it. DO NOT post to the "postgres" mailing list. ===============================================================================