existing but not-existing database.

Started by Marcosalmost 26 years ago1 messagesgeneral
Jump to latest
#1Marcos
marcos@second.ival.es

hi,

i created a database called todojamon. (i wanted to make up of an
old database trying to copy the same directoy to ../base/todojamon as
before). but it does not work. i deleted the directory. now i want to
restart the procedure creating a new database called todojamon. but it
answers

psql todojamon

FATAL 1: Database 'todojamon' does not exist.
We know this because the directory
'/usr/local/pgsql/data/base/todojamon' does not exist.
You can create a database with the SQL command CREATE
DATABASE.
To see what databases exist, look at the subdirectories of
'/usr/local/pgsql/data/base/'.
Connection to database 'todojamon' failed.
FATAL 1: Database 'todojamon' does not exist.
We know this because the directory
'/usr/local/pgsql/data/base/todojamon' does not exist.
You can create a database with the SQL command CREATE
DATABASE.
To see what databases exist, look at the subdirectories of
'/usr/local/pgsql/data/base/'.

if

psql template1

[inside postgres]
template1=> create database todojamon;
ERROR: createdb: database 'todojamon' already exists
ERROR: createdb: database 'todojamon' already exists

how can i delete todojamon database??

thanks in advance.

marcos
marcos@ival.es