agora inbox for pgsql-admin@postgresql.org  

help / color / mirror / Atom feed

From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: pg_upgrade
Date: Wed, 12 Jun 2024 21:50:52 +0200
Message-ID: <852b5c2b-d54c-439e-84c3-3fd1ea7a49b9@jakobs.com> (raw)
In-Reply-To: <CAB5fag4COrZFzYYcbJN4penKuprYNog3nT-z5PRn29dcnvmE7A@mail.gmail.com>
References: <CAB5fag4COrZFzYYcbJN4penKuprYNog3nT-z5PRn29dcnvmE7A@mail.gmail.com>

Am 12.06.24 um 16:06 schrieb Wasim Devale:
> Hi I am getting this error message while performing PG upgrade.
>
> Database user "postgres" is not install user failure existing
>
> Screenshot attached.
>
> Thanks,
> Wasim

Hi Wasim,

It seems that the operating system user "postgres" did not set up the 
cluster you are trying to upgrade.

Check which OS user owns the data directory.

Unfortunately, you don't show the complete shell prompt and pg_upgrade 
command line in your question or your screen photograph (it's not even a 
real screen shot).

It might help to chown the complete data directory to user and group 
postgres, but it's difficult to tell definitely without further information.

Regards,

Holger


-- 

Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012

view thread (13+ messages)  latest in thread

Message-ID: <852b5c2b-d54c-439e-84c3-3fd1ea7a49b9@jakobs.com>
Permalink:  ../852b5c2b-d54c-439e-84c3-3fd1ea7a49b9@jakobs.com/
Also on:    postgresql.org/message-id/852b5c2b-d54c-439e-84c3-3fd1ea7a49b9@jakobs.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: holger@jakobs.com, pgsql-admin@lists.postgresql.org
  Subject: Re: pg_upgrade
  In-Reply-To: <852b5c2b-d54c-439e-84c3-3fd1ea7a49b9@jakobs.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox