Re: pg_upgrade Only the install user can be defined in the new cluster

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: Dávid Suchan <david(dot)suchan(at)student(dot)tuke(dot)sk>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_upgrade Only the install user can be defined in the new cluster
Date: 2023-03-16 09:28:21
Message-ID: 021ED6C2-C01F-4E5B-8415-10C1BE29FCBA@yesql.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On 15 Mar 2023, at 16:39, Dávid Suchan <david(dot)suchan(at)student(dot)tuke(dot)sk> wrote:
>
> It prints out:
> count
> -------
> 1

I have a feeling the cluster you tried to upgrade to doesn't match this one, as
the check that failed will fail on values other than 1. Did you create them
equally? If you try to upgrade into this cluster, even just with the --check
option, does that yield more success?

--
Daniel Gustafsson

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2023-03-16 10:15:07 Re: Is the PL/pgSQL refcursor useful in a modern three-tier app?
Previous Message Dominique Devienne 2023-03-16 08:55:32 Re: Is the PL/pgSQL refcursor useful in a modern three-tier app?