[GENERAL] existing but not-existing database.

[Marcos Lloret]

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
[EMAIL PROTECTED]

Re: [GENERAL] existing but not-existing database.

[Paulo Jan]

  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.