pgsql: Remove more progname references in vacuumdb.c

2019-07-22 Thread Michael Paquier
Remove more progname references in vacuumdb.c Oversight in 5f384037. Author: Álvaro Herrera Discussion: https://postgr.es/m/20190722151806.GA22634@alvherre.pgsql Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/3cae75f4209bcbb06285544de0f1c59f717a3159 Modified File

pgsql: Make pg_upgrade's test.sh less chatty.

2019-07-22 Thread Tom Lane
Make pg_upgrade's test.sh less chatty. Remove "set -x", and pass "-A trust" to initdb explicitly, to suppress almost all of the noise this script used to emit on stderr. Back-patch of commit eb9812f27 into all active branches. Discussion: https://postgr.es/m/21766.1558397...@sss.pgh.pa.us Discus

pgsql: Make pg_upgrade's test.sh less chatty.

2019-07-22 Thread Tom Lane
Make pg_upgrade's test.sh less chatty. Remove "set -x", and pass "-A trust" to initdb explicitly, to suppress almost all of the noise this script used to emit on stderr. Back-patch of commit eb9812f27 into all active branches. Discussion: https://postgr.es/m/21766.1558397...@sss.pgh.pa.us Discus

pgsql: Make pg_upgrade's test.sh less chatty.

2019-07-22 Thread Tom Lane
Make pg_upgrade's test.sh less chatty. Remove "set -x", and pass "-A trust" to initdb explicitly, to suppress almost all of the noise this script used to emit on stderr. Back-patch of commit eb9812f27 into all active branches. Discussion: https://postgr.es/m/21766.1558397...@sss.pgh.pa.us Discus

pgsql: Make pg_upgrade's test.sh less chatty.

2019-07-22 Thread Tom Lane
Make pg_upgrade's test.sh less chatty. Remove "set -x", and pass "-A trust" to initdb explicitly, to suppress almost all of the noise this script used to emit on stderr. Back-patch of commit eb9812f27 into all active branches. Discussion: https://postgr.es/m/21766.1558397...@sss.pgh.pa.us Discus

pgsql: Make pg_upgrade's test.sh less chatty.

2019-07-22 Thread Tom Lane
Make pg_upgrade's test.sh less chatty. Remove "set -x", and pass "-A trust" to initdb explicitly, to suppress almost all of the noise this script used to emit on stderr. Back-patch of commit eb9812f27 into all active branches. Discussion: https://postgr.es/m/21766.1558397...@sss.pgh.pa.us Discus

pgsql: Install dependencies to prevent dropping partition key columns.

2019-07-22 Thread Tom Lane
Install dependencies to prevent dropping partition key columns. The logic in ATExecDropColumn that rejects dropping partition key columns is quite an inadequate defense, because it doesn't execute in cases where a column needs to be dropped due to cascade from something that only the column, not t

pgsql: Install dependencies to prevent dropping partition key columns.

2019-07-22 Thread Tom Lane
Install dependencies to prevent dropping partition key columns. The logic in ATExecDropColumn that rejects dropping partition key columns is quite an inadequate defense, because it doesn't execute in cases where a column needs to be dropped due to cascade from something that only the column, not t

pgsql: Install dependencies to prevent dropping partition key columns.

2019-07-22 Thread Tom Lane
Install dependencies to prevent dropping partition key columns. The logic in ATExecDropColumn that rejects dropping partition key columns is quite an inadequate defense, because it doesn't execute in cases where a column needs to be dropped due to cascade from something that only the column, not t

pgsql: Install dependencies to prevent dropping partition key columns.

2019-07-22 Thread Tom Lane
Install dependencies to prevent dropping partition key columns. The logic in ATExecDropColumn that rejects dropping partition key columns is quite an inadequate defense, because it doesn't execute in cases where a column needs to be dropped due to cascade from something that only the column, not t

pgsql: Revert "initdb: Change authentication defaults"

2019-07-22 Thread Peter Eisentraut
Revert "initdb: Change authentication defaults" This reverts commit 09f08930f0f6fd4a7350ac02f29124b919727198. The buildfarm client needs some adjustments first. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/7961886580a594e519ca7ed1811b464206738be5 Modified Files

pgsql: initdb: Change authentication defaults

2019-07-22 Thread Peter Eisentraut
initdb: Change authentication defaults Change the defaults for the pg_hba.conf generated by initdb to "peer" for local (if supported, else "md5") and "md5" for host. (Changing from "md5" to SCRAM is left as a separate exercise.) "peer" is currently not supported on AIX, HP-UX, and Windows. User

pgsql: Use appendBinaryStringInfo in more places where the length is kn

2019-07-22 Thread David Rowley
Use appendBinaryStringInfo in more places where the length is known When we already know the length that we're going to append, then it makes sense to use appendBinaryStringInfo instead of appendStringInfoString so that the append can be performed with a simple memcpy() using a known length rather

pgsql: Make identity sequence management more robust

2019-07-22 Thread Peter Eisentraut
Make identity sequence management more robust Some code could get confused when certain catalog state involving both identity and serial sequences was present, perhaps during an attempt to upgrade the latter to the former. Specifically, dropping the default of a serial column maintains the owners

pgsql: Make better use of the new List implementation in a couple of pl

2019-07-22 Thread David Rowley
Make better use of the new List implementation in a couple of places In nodeAppend.c and nodeMergeAppend.c there were some foreach loops which looped over the list of subplans and only performed any work if the subplan index was found in a Bitmapset. With the old linked list implementation of Lis