Thanks Denial, 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) Regards, Narresh On Wed 15 Jul, 2020, 3:28 PM Daniel Verite <dan...@manitou-mail.org wrote: > TALLURI Nareshkumar wrote: > > > [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. > > > Best regards, > -- > Daniel Vérité > PostgreSQL-powered mailer: https://www.manitou-mail.org > Twitter: @DanielVerite > > >
