Re: pg_upgrade - Mailing list pgsql-admin

From Holger Jakobs
Subject Re: pg_upgrade
Date
Msg-id 852b5c2b-d54c-439e-84c3-3fd1ea7a49b9@jakobs.com
Whole thread Raw
In response to pg_upgrade  (Wasim Devale <wasimd60@gmail.com>)
Responses Re: pg_upgrade
List pgsql-admin
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




pgsql-admin by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: Logical replication from PostgreSQL 10.23 to 16.3, last two big tables (getting synced) just keep growing
Next
From: PGSQL DBA
Date:
Subject: How to Handle Sequences in Logical Bi-Directional Replication