Re: single user mode -P option is ignored

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: single user mode -P option is ignored
Date: 2018-12-19 17:07:59
Message-ID: CAFj8pRCj7hX2UVZV5Wi57UhZu_dVsN7zq_Fu1OwXJX6kkXfV4g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

st 19. 12. 2018 v 18:07 odesílatel Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
napsal:

> On 2018-Dec-19, Tom Lane wrote:
>
> > Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> writes:
> > > some customer has PostgreSQL 9.5.5. He cannot to login to database due
> > > broken index
> > > When I use single mode against to this database I got a error
> > > start transaction
> > > could not open critical system index 2679
> >
> > I can't reproduce this.
>
> Judging by the "start transaction" string, I wonder if Pavel is using
> bootstrap mode rather than standard single mode.
>

I used parameters --single and -P

> --
> Álvaro Herrera https://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2018-12-19 17:11:08 Re: WRITE_*_ARRAY macros for outfuncs.c
Previous Message Alvaro Herrera 2018-12-19 17:06:57 Re: single user mode -P option is ignored