| From: | Holger Jakobs <holger(at)jakobs(dot)com> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: pg_upgrade |
| Date: | 2024-06-12 19:50:52 |
| Message-ID: | 852b5c2b-d54c-439e-84c3-3fd1ea7a49b9@jakobs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PGSQL DBA | 2024-06-13 01:23:18 | How to Handle Sequences in Logical Bi-Directional Replication |
| Previous Message | Achilleas Mantzios | 2024-06-12 19:46:14 | Re: Logical replication from PostgreSQL 10.23 to 16.3, last two big tables (getting synced) just keep growing |