existing but not-existing database.

Поиск
Список
Период
Сортировка
От Marcos Lloret
Тема existing but not-existing database.
Дата
Msg-id 393F8465.D91CE0E5@second.ival.es
обсуждение исходный текст
Список 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@ival.es




В списке pgsql-general по дате отправления:

Предыдущее
От: Matt Goodall
Дата:
Сообщение: Re: Column types via ODBC interface
Следующее
От: Paulo Jan
Дата:
Сообщение: Re: existing but not-existing database.