hi,
i can't drop a db. Here are the details:
RedHat version 5.0 Linux 2.0.31
i686 machine (micron millennia)
Postgres version 6.5.3
The first problem I encountered was on step 11b. for your install docs. I
was receiving this error message:
checking whether the C++ compiler (gcc ) works... no
configure: error: installation or configuration problem: C++ compiler
cannot create executables.
so, then altered the command to this:
./configure --without-CXX
this seemed to work. At least i didn't get any error messages.
then i successfully completed all the other steps. now when i try to drop
my test db using the following command:
dropdb test
i get this error message:
dropdb: command not found
i looked in /usr/local/pgsql/bin and there is no dropdb command. there is
a destroydb command. should i run that instead to drop my test database?
so, i'm able to create databases, i just can't drop them.
this is what my .bash_profile looks like:
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:/usr/local/pgsql/bin
MANPATH=$MANPATH:/usr/local/pgsql/man
PGLIB=/usr/local/pgsql/lib
PGDATA=/usr/local/pgsql/data
export PATH MANPATH PGLIB PGDATA
i still am unable to drop a db:
kris=> \q
[postgres@girly postgres]$ dropdb test
bash: dropdb: command not found
these are the commands i have available to me:
cleardbdir destroylang ipcclean pg_upgrade vacuumdb
createdb destroyuser pg_dump pg_version
createlang ecpg pg_dumpall postgres
createuser initdb pg_id postmaster
destroydb initlocation pg_passwd psql
any help would be most appreciated.
thanks!
kris austin
+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+
Kris Austin + Database Administration + Advance Publications Internet
http://www.advance.net + kaustin@advance.net + 201-459-2805
+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+
The love for all living creatures is the most noble attribute of man.
- Charles Darwin (1809-1882)