Message-ID: <852b5c2b-d54c-439e-84c3-3fd1ea7a49b9@jakobs.com>
Date: Wed, 12 Jun 2024 21:50:52 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: pg_upgrade
To: pgsql-admin@lists.postgresql.org
References: 
 <CAB5fag4COrZFzYYcbJN4penKuprYNog3nT-z5PRn29dcnvmE7A@mail.gmail.com>
From: Holger Jakobs <holger@jakobs.com>
In-Reply-To: 
 <CAB5fag4COrZFzYYcbJN4penKuprYNog3nT-z5PRn29dcnvmE7A@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/852b5c2b-d54c-439e-84c3-3fd1ea7a49b9%40jakobs.com>
Precedence: bulk

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