Can i create a brand new cluster and check it that way? Since I had to stop / shut down the 14 cluster in order to proceed with pg_upgrade and I dont know how can i connect to it now ... ________________________________ Od: Dávid Suchan <david.suc...@student.tuke.sk> Odoslané: streda 15. marca 2023 14:47 Komu: Daniel Gustafsson <dan...@yesql.se> Predmet: Re: pg_upgrade Only the install user can be defined in the new cluster
Can i create a brand new cluster and check it that way? Since I had to stop / shut down the 14 cluster in order to proceed with pg_upgrade and I dont know how can i connect to it now ... ________________________________ Od: Daniel Gustafsson <dan...@yesql.se> Odoslané: streda 15. marca 2023 13:27 Komu: Dávid Suchan <david.suc...@student.tuke.sk> Kópia: pgsql-gene...@postgresql.org <pgsql-gene...@postgresql.org> 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.suc...@student.tuke.sk> 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