From: | Dávid Suchan <david(dot)suchan(at)student(dot)tuke(dot)sk> |
---|---|
To: | Daniel Gustafsson <daniel(at)yesql(dot)se> |
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-15 13:48:06 |
Message-ID: | VE1P191MB111815900E362D0C6170E227D6BF9@VE1P191MB1118.EURP191.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)suchan(at)student(dot)tuke(dot)sk>
Odoslané: streda 15. marca 2023 14:47
Komu: Daniel Gustafsson <daniel(at)yesql(dot)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 <daniel(at)yesql(dot)se>
Odoslané: streda 15. marca 2023 13:27
Komu: Dávid Suchan <david(dot)suchan(at)student(dot)tuke(dot)sk>
Kópia: pgsql-general(at)postgresql(dot)org <pgsql-general(at)postgresql(dot)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(dot)suchan(at)student(dot)tuke(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Gustafsson | 2023-03-15 13:48:47 | Re: pg_upgrade Only the install user can be defined in the new cluster |
Previous Message | Daniel Gustafsson | 2023-03-15 12:27:20 | Re: pg_upgrade Only the install user can be defined in the new cluster |