Re: BUG #15213: unable to login on PostgreSQL by postgres user

From: Arthur Zakirov <a(dot)zakirov(at)postgrespro(dot)ru>
To: dhirendra04(at)hotmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15213: unable to login on PostgreSQL by postgres user
Date: 2018-05-29 08:23:01
Message-ID: 20180529082300.GA2424@zakirov.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello,

On Tue, May 29, 2018 at 07:32:38AM +0000, PG Bug reporting form wrote:
> [dhirsing(at)jira-stg ~]$ sudo -u postgres psql postgres
> [sudo] password for dhirsing:
> could not change directory to "/home/dhirsing"
> psql: FATAL: database "postgres" does not exist
> DETAIL: The database subdirectory "base/12950" is missing.

I think you missed postgres database directory. Can you check using a
file manager if the directory "base/12950" exists in your PGDATA?

If it is lost the only way is to restore your instance from a backup.

--
Arthur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2018-05-29 09:18:26 BUG #15214: Pg 10.4 windows 64 bit installer is 32 bit
Previous Message PG Bug reporting form 2018-05-29 07:32:38 BUG #15213: unable to login on PostgreSQL by postgres user