Re: migrate from PG 9.5 to PG 12 or more

2021-10-19 Thread CONVERS Yann - DREAL Auvergne-Rhône-Alpes/CIDDAE/SIG
hello Pascal, I do it in 2020 from postgresql 9.6 to 12 . I do with a shell linux script using pd_dump and pg_restore from a database save. I first mount a new postgresql 12 server, prepare with new hard parameters in postgresql.conf,

Re: [PATCH] doc/queries.sgml: add missing comma

2021-10-19 Thread Michael Paquier
On Tue, Oct 19, 2021 at 06:41:54PM -0700, David G. Johnston wrote: > On Tue, Oct 19, 2021 at 2:33 PM Tom Lane wrote: >> ... although I think this text is mine, so naturally I'd think >> that. Anyone else have an opinion? > > If I read that aloud to myself there is a comma after iteration. Agreed

Re: ALTER TABLE ... SET DATA TYPE removes statistics

2021-10-19 Thread Michael Paquier
On Tue, Oct 19, 2021 at 12:16:44PM -0300, Alvaro Herrera wrote: > Dunno, putting it in the middle of the existing paragraph looks odd to > me. I would put it in a separate one instead, as in the attached. Fine by me. Thanks! -- Michael signature.asc Description: PGP signature

Re: [PATCH] doc/queries.sgml: add missing comma

2021-10-19 Thread David G. Johnston
On Tue, Oct 19, 2021 at 2:33 PM Tom Lane wrote: > Drew DeVault writes: > > Minor grammatical fix. > > Hmm, I'm not sure that reads any better than before. > > > > > -Strictly speaking, this process is iteration not recursion, but > > +Strictly speaking, this process is iteration, no

Re: [PATCH] doc/queries.sgml: add missing comma

2021-10-19 Thread Tom Lane
Drew DeVault writes: > Minor grammatical fix. Hmm, I'm not sure that reads any better than before. > > -Strictly speaking, this process is iteration not recursion, but > +Strictly speaking, this process is iteration, not recursion, but > RECURSIVE is the terminology chosen by t

max_sync_workers_per_subscription

2021-10-19 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/logical-replication-config.html Description: max_sync_workers_per_subscription option is not added.

pmap grep zero fail to load vm_peak

2021-10-19 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/kernel-resources.html Description: pmap 4170 | awk '/rw-s/ && /zero/ {print $2}' is not working if I Do pmap 4170 | awk '/rw-s/ && /zero/ {print $2}' I get 2ac0 1099776K rw

[PATCH] doc/queries.sgml: add missing comma

2021-10-19 Thread Drew DeVault
Minor grammatical fix. --- doc/src/sgml/queries.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/doc/src/sgml/queries.sgml b/doc/src/sgml/queries.sgml index 516fbcbf37..0f3d9ce7f8 100644 --- a/doc/src/sgml/queries.sgml +++ b/doc/src/sgml/queries.sgml @@ -2172,7 +2172,7 @@ S

migrate from PG 9.5 to PG 12 or more

2021-10-19 Thread Pascal CROZET
Hi PG experts, During next year, I've the goal to migrate an instance of 4 databases from PostGreSql 9.5 to 12 or maybe more 14. What's the best tools I've to use ? Do a simple pg_dumpall in text format can archive this goal ? What other files more than pg_hba.conf and postgresql.conf do I need

Re: ALTER TABLE ... SET DATA TYPE removes statistics

2021-10-19 Thread Alvaro Herrera
On 2021-Oct-19, Michael Paquier wrote: > On Mon, Oct 18, 2021 at 05:15:59PM -0300, Euler Taveira wrote: > > I agree that it might surprise an user and it would be good to document it. > > However, it does not belong to the description. I would add it to the Notes > > section at the end of the ALTE