X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4C1133A3C45 for ; Tue, 26 Oct 2004 00:33:46 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 23588-05 for ; Mon, 25 Oct 2004 23:33:42 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id EBF1F3A3C07 for ; Tue, 26 Oct 2004 00:33:43 +0100 (BST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id i9PNXZA8002222; Mon, 25 Oct 2004 19:33:35 -0400 (EDT) To: Ben Kim Cc: pgsql-admin@postgresql.org Subject: Re: Question: drop database problem In-reply-to: References: Comments: In-reply-to Ben Kim message dated "Mon, 25 Oct 2004 14:44:38 -0500" Date: Mon, 25 Oct 2004 19:33:35 -0400 Message-ID: <2221.1098747215@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/340 X-Sequence-Number: 15333 Ben Kim writes: > pgsql=# drop database mydb; > ERROR: Postmaster environment variable 'PGDATA3' not set > The database owner is pgsql, and if I echo $PGDATA3 as the owner, it > returns a valid directory. Also, the datpath is correct. You have $PGDATA3 set in your interactive environment, but evidently not in the environment of the postmaster process. How are you starting the postmaster exactly, and where are you expecting it to get $PGDATA3 from? > Also, I have several databases sharing the datpath of PGDATA3. Is there a > system table associating the datpath and the actual OS path? No, just the environment variable. (This is all changing in 8.0 with tablespaces, thank goodness.) regards, tom lane