Re: psql: FATAL: database "postgres" does not exist or ERROR: 23505: duplicate key value violates unique constraint "pg_namespace_nspname_index" - Mailing list pgsql-general
From
Naresh Kumar
Subject
Re: psql: FATAL: database "postgres" does not exist or ERROR: 23505: duplicate key value violates unique constraint "pg_namespace_nspname_index"
Already I tried to connect with template0, template1, user database name, postgres, nothing is working getting same error message as mentioned in trail mail.
For the second one, yes we don't have backups to restore, we don't have any option apart from data directory(no wal files)
> [0]postgres@axmdevhkdb008$ [PHKGAXMD008] psql > psql: FATAL: database "postgres" does not exist
That's not necessarily a problem. The "postgres" database is generally empty and some installations don't even have one. Use "psql -d template1" instead, or start postgres in single-user mode.
> Since we are not able to connect to DB , we did a new initialization and > copy the directories from base directory to new base directory(in new data > location)
This can't work. If you have a backup from just before that point, you should restore it and work from that without writing anything into the data directory.
