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 по дате отправления: