From: | Ben Kim <bkim(at)coe(dot)tamu(dot)edu> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Question: drop database problem |
Date: | 2004-10-25 19:44:38 |
Message-ID: | Pine.GSO.4.10.10410251417070.26498-100000@edsun.coe.tamu.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Dear list,
I'm using Postgresql 7.2 on Solaris.
I have this error message when I try to drop a database. I couldn't find a
mention anywhere on this error. Could someone advise how to circumvent
this error?
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.
select * from pg_database; shows
datname ... datpath
-----------------+...+---------
mydb PGDATA3
In the $PGDATA3/data/base/ directory, I confirmed that one of the
directories is being used, by bulk inserting some test data into mydb
database.
Also, I have several databases sharing the datpath of PGDATA3. Is there a
system table associating the datpath and the actual OS path? (like mydb ->
$PGDATA3/data/base/335253, etc.)
dropdb gives the same result.
ERROR: Postmaster environment variable 'PGDATA3' not set
dropdb: database removal failed
Thanks in advance.
Ben Kim
Database Developer/Systems Administrator
College of Education
Texas A&M University
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-10-25 23:33:35 | Re: Question: drop database problem |
Previous Message | Andy Marangakis | 2004-10-25 18:48:54 | runaway processes, data corruption |