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