Re: psql: FATAL: database "postgres" does not exist or ERROR: 23505: duplicate key value violates unique constraint "pg_namespace_nspname_index"
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 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 > > >
Re: psql: FATAL: database "postgres" does not exist or ERROR: 23505: duplicate key value violates unique constraint "pg_namespace_nspname_index"
Yes Karsten, Can some one help us on this please. Regards, Narresh On Wed 15 Jul, 2020, 10:55 PM Karsten Hilbert On Wed, Jul 15, 2020 at 10:03:06PM +0530, Naresh Kumar wrote: > > > 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) > > At this point you are very likely in need of (highly) > specialized professional help. > > Karsten > -- > GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B > > >
Re: psql: FATAL: database "postgres" does not exist or ERROR: 23505: duplicate key value violates unique constraint "pg_namespace_nspname_index"
Thanks Christopher, if you any such contacts can you share with us. Regards, Narresh On Fri 17 Jul, 2020, 7:04 AM Christophe Pettus > > > On Jul 16, 2020, at 18:32, Naresh Kumar wrote: > > > > Can some one help us on this please. > > To be clear, what you almost certainly have here is serious data > corruption. You will need to find a (paid, commercial) specialist to help > you with the recovery. You are unlikely to get the level of support you > need on this list, for free. > > -- > -- Christophe Pettus >x...@thebuild.com > >
Re: psql: FATAL: database "postgres" does not exist or ERROR: 23505: duplicate key value violates unique constraint "pg_namespace_nspname_index"
Thanks, I will check it out. On Fri 17 Jul, 2020, 7:42 AM Christophe Pettus > > > On Jul 16, 2020, at 19:08, Naresh Kumar wrote: > > > > Thanks Christopher, if you any such contacts can you share with us. > > The community maintains this page; I'm sure you can find someone who can > help you there: > > https://www.postgresql.org/support/professional_support/ > > -- > -- Christophe Pettus >x...@thebuild.com > >
