Обсуждение: Dropping database in alternative space

Поиск
Список
Период
Сортировка

Dropping database in alternative space

От
Warren Little
Дата:
I created a database in an alternate location using the
initlocation procedure.  I can access the database just
fine and do all the standard updates and deletes, but when
I try and drop the database I get the following error message

-bash-2.05b$ dropdb prodcopy
ERROR:  Postmaster environment variable 'PGDATA2' not set
dropdb: database removal failed

The PGDATA2 variable is set in my environment.
The postmaster was started with -D $PGDATA, could this be
the problem?

--
Warren Little
Senior Vice President
Secondary Marketing
Security Lending Wholesale, LC
www.securitylending.com
Tel: 866-369-7763
Fax: 866-849-8082

Re: Dropping database in alternative space

От
Tom Lane
Дата:
Warren Little <wlittle@securitylending.com> writes:
> -bash-2.05b$ dropdb prodcopy
> ERROR:  Postmaster environment variable 'PGDATA2' not set
> dropdb: database removal failed

> The PGDATA2 variable is set in my environment.

... but, evidently, not in the *postmaster's* environment.

            regards, tom lane