Return-Path: owner-postman Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.3/8.6.3) with SMTP id LAA10856 for postgres-dist; Mon, 8 Nov 1993 11:49:37 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199311081949.LAA10856@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.3/8.6.3) with ESMTP id LAA10847 for ; Mon, 8 Nov 1993 11:49:37 -0800 Received: from localhost (localhost [127.0.0.1]) by faerie.CS.Berkeley.EDU (8.6.3/8.1B) with SMTP id LAA03364; Mon, 8 Nov 1993 11:49:18 -0800 Message-Id: <199311081949.LAA03364@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: gvkravet@king.mcs.drexel.edu (Victor Kravets) Cc: postgres@postgres.Berkeley.EDU Subject: Re: createdb problem In-reply-to: Your message of Mon, 8 Nov 93 14:17:16 EST <9311081917.AA14137@mcs.drexel.edu> Date: Mon, 08 Nov 93 11:49:17 -0800 X-Sender: aoki@postgres.Berkeley.EDU Resent-To: postgres-dist@postgres.Berkeley.EDU X-Mts: smtp Resent-Date: Mon, 08 Nov 93 11:49:37 -0800 Resent-XMts: smtp gvkravet@king.mcs.drexel.edu (Victor Kravets) writes: > queen% postmaster & > [1] 13362 > queen% createdb foo > FATAL 1:Nov 8 11:04:42:process userid (745) != database owner (8) > /usr/local/postgres/bin/createdb: database creation failed on foo. first, if you are still defining POSTGRESHOME, it sounds like you're running 4.0.1. 4.1 is available. second, somebody installed postgres such that the files in POSTGRESHOME/data/base are owned by the user with uid 8 (probably "postgres"). you have to start the postmaster as that user. -- Paul M. Aoki | CS Div., Dept. of EECS, UCB | aoki@postgres.Berkeley.EDU | Berkeley, CA 94720 | ...!uunet!ucbvax!aoki