Re: Pg14, pg_dumpall and "password_encryption=true"

2021-03-03 Thread Peter Eisentraut
On 18.01.21 07:18, Michael Paquier wrote: This would be interpreting setconfig='{password_encryption=on}' as "opt out of future password security increases". I expect that will tend not to match the intent of the person entering the setting. That said, if v14 were already behaving this way, I w

Re: Pg14, pg_dumpall and "password_encryption=true"

2021-01-17 Thread Michael Paquier
On Sun, Jan 17, 2021 at 02:20:10PM -0800, Noah Misch wrote: > On Sun, Jan 17, 2021 at 01:51:35PM +0100, Magnus Hagander wrote: >> Option 3 would be the closest to how other things work though, >> wuodln't it? Normally, it's the job of pg_dump (or pg_dumpall) to >> adapt the dump to the new version

Re: Pg14, pg_dumpall and "password_encryption=true"

2021-01-17 Thread Noah Misch
On Sun, Jan 17, 2021 at 01:51:35PM +0100, Magnus Hagander wrote: > On Sat, Jan 16, 2021 at 8:27 AM Noah Misch wrote: > > On Fri, Jan 15, 2021 at 01:35:50PM +0900, Ian Lawrence Barwick wrote: > > > $ tail -3 pg_upgrade_utility.log > > > ALTER ROLE "postgres" SET "password_encryption" TO 'tr

Re: Pg14, pg_dumpall and "password_encryption=true"

2021-01-17 Thread Magnus Hagander
On Sat, Jan 16, 2021 at 8:27 AM Noah Misch wrote: > > On Fri, Jan 15, 2021 at 01:35:50PM +0900, Ian Lawrence Barwick wrote: > > $ tail -3 pg_upgrade_utility.log > > ALTER ROLE "postgres" SET "password_encryption" TO 'true'; > > psql:pg_upgrade_dump_globals.sql:75: ERROR: invalid value

Re: Pg14, pg_dumpall and "password_encryption=true"

2021-01-15 Thread Noah Misch
On Fri, Jan 15, 2021 at 01:35:50PM +0900, Ian Lawrence Barwick wrote: > $ tail -3 pg_upgrade_utility.log > ALTER ROLE "postgres" SET "password_encryption" TO 'true'; > psql:pg_upgrade_dump_globals.sql:75: ERROR: invalid value for > parameter "password_encryption": "true" > HINT: A

Pg14, pg_dumpall and "password_encryption=true"

2021-01-14 Thread Ian Lawrence Barwick
Greetings Consider the following: postgres=# SELECT current_setting('server_version'); current_setting - 12.5 (1 row) postgres=# SELECT * FROM pg_db_role_setting WHERE setrole = 10; setdatabase | setrole | setconfig -+---