Обсуждение: existing but not-existing database.
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
> > 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?? > You should have deleted the database with "destroydb". Now you can edit "by hand" the pg_database table, which is the system table where the available databases are stored. Use standard SQL commands like "SELECT * FROM pg_database" and etc. to delete the entry for your database. Paulo Jan. DDnet.