existing but not-existing database.

From: Marcos Lloret <marcos(at)second(dot)ival(dot)es>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: existing but not-existing database.
Date: 2000-06-08 11:32:54
Message-ID: 393F8465.D91CE0E5@second.ival.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)ival(dot)es

Responses

Browse pgsql-general by date

  From Date Subject
Next Message mikeo 2000-06-08 12:20:10 Re: Re: [SQL] oracle rownum equivalent?
Previous Message Paulo Jan 2000-06-08 11:15:41 Re: existing but not-existing database.