Thread: problem with dropping database

problem with dropping database

From
alihavai@lut.fi.remove (Antti Lihavainen)
Date:
I created a new database with alternate location (create database
java_general with location = 'JAVA_GENERAL_DB';). Now I can't drop
this database:

--- clip ---
bash-2.05$ dropdb java_general
ERROR:  Postmaster environment variable 'JAVA_GENERAL_DB' not set
dropdb: database removal failed
--- clip ---

The env var is set afaik:

bash-2.05$ echo $JAVA_GENERAL_DB
/home/www/html/somewhere/somedir/


Any ideas?

--

Antti


Re: problem with dropping database

From
Oliver Elphick
Date:
On Mon, 2002-02-25 at 13:54, Antti Lihavainen wrote:
>
> I created a new database with alternate location (create database
> java_general with location = 'JAVA_GENERAL_DB';). Now I can't drop
> this database:
>
> --- clip ---
> bash-2.05$ dropdb java_general
> ERROR:  Postmaster environment variable 'JAVA_GENERAL_DB' not set
> dropdb: database removal failed
> --- clip ---
>
> The env var is set afaik:
>
> bash-2.05$ echo $JAVA_GENERAL_DB
> /home/www/html/somewhere/somedir/
>
>
> Any ideas?

I guess the environment variable is not set in the postmaster's
environment.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "But God commendeth his love toward us, in that, while
      we were yet sinners, Christ died for us."
                                   Romans 5:8