Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



It prints out:
 count
-------
     1
(1 row)

Od: Daniel Gustafsson <daniel@xxxxxxxx>
Odoslané: streda 15. marca 2023 13:27
Komu: Dávid Suchan <david.suchan@xxxxxxxxxxxxxxx>
Kópia: pgsql-general@xxxxxxxxxxxxxx <pgsql-general@xxxxxxxxxxxxxx>
Predmet: Re: pg_upgrade Only the install user can be defined in the new cluster
 
> On 15 Mar 2023, at 10:30, Dávid Suchan <david.suchan@xxxxxxxxxxxxxxx> wrote:

> ..there are no other users in the db.

The check in question performs this:

        SELECT COUNT(*) FROM pg_catalog.pg_roles WHERE rolname !~ '^pg_';

What do you get when running that in the new v14 cluster?

--
Daniel Gustafsson


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux