Re: pg_upgrade does not upgrade pg_stat_statements properly

От

Dave Cramer

Тема

Дата

15 июля 2021 г. в 16:35:05

Msg-id

CADK3HHJDOirXazRn99BmSwGOGsOp+T-0MzzV1YAMWGb4SsKZUA@mail.gmail.com

обсуждение

Ответ на

Re: pg_upgrade does not upgrade pg_stat_statements properly (David G. Johnston)

Список

pgsql-hackers

Дерево обсуждения

pg_upgrade does not upgrade pg_stat_statements properly Dave Cramer <davecramer@gmail.com> 14 июля 2021 г. в 18:38:49

Re: pg_upgrade does not upgrade pg_stat_statements properly "David G. Johnston" <david.g.johnston@gmail.com> 14 июля 2021 г. в 18:47:47

Re: pg_upgrade does not upgrade pg_stat_statements properly Dave Cramer <davecramer@gmail.com> 14 июля 2021 г. в 18:58:45

Re: pg_upgrade does not upgrade pg_stat_statements properly "David G. Johnston" <david.g.johnston@gmail.com> 14 июля 2021 г. в 19:09:20

Re: pg_upgrade does not upgrade pg_stat_statements properly Dave Cramer <davecramer@gmail.com> 14 июля 2021 г. в 19:21:40

Re: pg_upgrade does not upgrade pg_stat_statements properly Tom Lane <tgl@sss.pgh.pa.us> 14 июля 2021 г. в 19:43:47

Re: pg_upgrade does not upgrade pg_stat_statements properly Dave Cramer <davecramer@gmail.com> 15 июля 2021 г. в 11:40:54

Re: pg_upgrade does not upgrade pg_stat_statements properly "David G. Johnston" <david.g.johnston@gmail.com> 15 июля 2021 г. в 15:01:34

Re: pg_upgrade does not upgrade pg_stat_statements properly Dave Cramer <davecramer@gmail.com> 15 июля 2021 г. в 15:09:28

Re: pg_upgrade does not upgrade pg_stat_statements properly "David G. Johnston" <david.g.johnston@gmail.com> 15 июля 2021 г. в 15:17:27

Re: pg_upgrade does not upgrade pg_stat_statements properly "David G. Johnston" <david.g.johnston@gmail.com> 15 июля 2021 г. в 15:15:57

Re: pg_upgrade does not upgrade pg_stat_statements properly Bruce Momjian <bruce@momjian.us> 29 июля 2021 г. в 01:52:36

Re: pg_upgrade does not upgrade pg_stat_statements properly "David G. Johnston" <david.g.johnston@gmail.com> 29 июля 2021 г. в 04:35:28

Re: pg_upgrade does not upgrade pg_stat_statements properly Bruce Momjian <bruce@momjian.us> 29 июля 2021 г. в 14:56:40

Re: pg_upgrade does not upgrade pg_stat_statements properly Dave Cramer <davecramer@gmail.com> 29 июля 2021 г. в 15:01:43

Re: pg_upgrade does not upgrade pg_stat_statements properly Bruce Momjian <bruce@momjian.us> 29 июля 2021 г. в 15:10:17

Re: pg_upgrade does not upgrade pg_stat_statements properly Jan Wieck <jan@wi3ck.info> 29 июля 2021 г. в 15:46:12

Re: pg_upgrade does not upgrade pg_stat_statements properly Bruce Momjian <bruce@momjian.us> 29 июля 2021 г. в 16:14:32

Re: pg_upgrade does not upgrade pg_stat_statements properly Julien Rouhaud <rjuju123@gmail.com> 29 июля 2021 г. в 18:04:16

Re: pg_upgrade does not upgrade pg_stat_statements properly Jan Wieck <jan@wi3ck.info> 29 июля 2021 г. в 18:14:56

Re: pg_upgrade does not upgrade pg_stat_statements properly Julien Rouhaud <rjuju123@gmail.com> 30 июля 2021 г. в 02:02:57

Re: pg_upgrade does not upgrade pg_stat_statements properly Dave Cramer <davecramer@postgres.rocks> 30 июля 2021 г. в 10:03:50

Re: pg_upgrade does not upgrade pg_stat_statements properly Julien Rouhaud <rjuju123@gmail.com> 30 июля 2021 г. в 10:39:45

Re: pg_upgrade does not upgrade pg_stat_statements properly Dave Cramer <davecramer@postgres.rocks> 30 июля 2021 г. в 10:48:34

Re: pg_upgrade does not upgrade pg_stat_statements properly Julien Rouhaud <rjuju123@gmail.com> 30 июля 2021 г. в 11:07:28

Re: pg_upgrade does not upgrade pg_stat_statements properly Dave Cramer <davecramer@postgres.rocks> 30 июля 2021 г. в 11:18:56

Re: pg_upgrade does not upgrade pg_stat_statements properly Julien Rouhaud <rjuju123@gmail.com> 30 июля 2021 г. в 11:28:32

Re: pg_upgrade does not upgrade pg_stat_statements properly Dave Cramer <davecramer@postgres.rocks> 30 июля 2021 г. в 11:33:55

Re: pg_upgrade does not upgrade pg_stat_statements properly Julien Rouhaud <rjuju123@gmail.com> 30 июля 2021 г. в 11:40:52

Re: pg_upgrade does not upgrade pg_stat_statements properly Jan Wieck <jan@wi3ck.info> 30 июля 2021 г. в 16:44:17

Re: pg_upgrade does not upgrade pg_stat_statements properly Jan Wieck <jan@wi3ck.info> 30 июля 2021 г. в 16:43:04

Re: pg_upgrade does not upgrade pg_stat_statements properly Tom Lane <tgl@sss.pgh.pa.us> 30 июля 2021 г. в 17:05:12

Re: pg_upgrade does not upgrade pg_stat_statements properly Jan Wieck <jan@wi3ck.info> 30 июля 2021 г. в 17:28:32

Re: pg_upgrade does not upgrade pg_stat_statements properly Dave Cramer <davecramer@gmail.com> 29 июля 2021 г. в 15:17:52

Re: pg_upgrade does not upgrade pg_stat_statements properly Bruce Momjian <bruce@momjian.us> 29 июля 2021 г. в 15:24:49

Re: pg_upgrade does not upgrade pg_stat_statements properly "David G. Johnston" <david.g.johnston@gmail.com> 29 июля 2021 г. в 15:28:12

Re: pg_upgrade does not upgrade pg_stat_statements properly Bruce Momjian <bruce@momjian.us> 29 июля 2021 г. в 15:40:27

Re: pg_upgrade does not upgrade pg_stat_statements properly Dave Cramer <davecramer@gmail.com> 29 июля 2021 г. в 15:36:19

Re: pg_upgrade does not upgrade pg_stat_statements properly Bruce Momjian <bruce@momjian.us> 29 июля 2021 г. в 15:42:16

Re: pg_upgrade does not upgrade pg_stat_statements properly "David G. Johnston" <david.g.johnston@gmail.com> 29 июля 2021 г. в 16:00:36

Re: pg_upgrade does not upgrade pg_stat_statements properly Bruce Momjian <bruce@momjian.us> 29 июля 2021 г. в 16:16:49

Re: pg_upgrade does not upgrade pg_stat_statements properly Dave Cramer <davecramer@gmail.com> 29 июля 2021 г. в 16:22:59

Re: pg_upgrade does not upgrade pg_stat_statements properly Bruce Momjian <bruce@momjian.us> 29 июля 2021 г. в 16:34:48

Re: pg_upgrade does not upgrade pg_stat_statements properly Alvaro Herrera <alvherre@alvh.no-ip.org> 29 июля 2021 г. в 17:43:09

Re: pg_upgrade does not upgrade pg_stat_statements properly Bruce Momjian <bruce@momjian.us> 29 июля 2021 г. в 19:06:45

Re: pg_upgrade does not upgrade pg_stat_statements properly Bruce Momjian <bruce@momjian.us> 3 августа 2021 г. в 15:39:31

Re: pg_upgrade does not upgrade pg_stat_statements properly Dave Cramer <davecramer@gmail.com> 29 июля 2021 г. в 19:27:49

Re: pg_upgrade does not upgrade pg_stat_statements properly Tom Lane <tgl@sss.pgh.pa.us> 29 июля 2021 г. в 21:01:24

Re: pg_upgrade does not upgrade pg_stat_statements properly Bruce Momjian <bruce@momjian.us> 29 июля 2021 г. в 22:11:03

Re: pg_upgrade does not upgrade pg_stat_statements properly Tom Lane <tgl@sss.pgh.pa.us> 29 июля 2021 г. в 22:19:56

Re: pg_upgrade does not upgrade pg_stat_statements properly Bruce Momjian <bruce@momjian.us> 29 июля 2021 г. в 22:26:01

Re: pg_upgrade does not upgrade pg_stat_statements properly Tom Lane <tgl@sss.pgh.pa.us> 29 июля 2021 г. в 22:29:11

Re: pg_upgrade does not upgrade pg_stat_statements properly Bruce Momjian <bruce@momjian.us> 29 июля 2021 г. в 22:38:58

Re: pg_upgrade does not upgrade pg_stat_statements properly Alvaro Herrera <alvherre@alvh.no-ip.org> 29 июля 2021 г. в 23:26:46

Re: pg_upgrade does not upgrade pg_stat_statements properly Dave Cramer <davecramer@gmail.com> 29 июля 2021 г. в 23:06:25

Re: pg_upgrade does not upgrade pg_stat_statements properly Bruce Momjian <bruce@momjian.us> 30 июля 2021 г. в 16:40:06

Re: pg_upgrade does not upgrade pg_stat_statements properly Bruce Momjian <bruce@momjian.us> 3 августа 2021 г. в 16:00:47

Re: pg_upgrade does not upgrade pg_stat_statements properly "David G. Johnston" <david.g.johnston@gmail.com> 29 июля 2021 г. в 19:56:46

Re: pg_upgrade does not upgrade pg_stat_statements properly Dave Cramer <davecramer@gmail.com> 29 июля 2021 г. в 18:06:10

Re: pg_upgrade does not upgrade pg_stat_statements properly Alvaro Herrera <alvherre@alvh.no-ip.org> 29 июля 2021 г. в 18:19:17

Re: pg_upgrade does not upgrade pg_stat_statements properly Bruce Momjian <bruce@momjian.us> 29 июля 2021 г. в 19:08:04

Re: pg_upgrade does not upgrade pg_stat_statements properly "David G. Johnston" <david.g.johnston@gmail.com> 29 июля 2021 г. в 17:00:12

Re: pg_upgrade does not upgrade pg_stat_statements properly Bruce Momjian <bruce@momjian.us> 29 июля 2021 г. в 18:28:55

Re: pg_upgrade does not upgrade pg_stat_statements properly Bruce Momjian <bruce@momjian.us> 29 июля 2021 г. в 18:35:01

Re: pg_upgrade does not upgrade pg_stat_statements properly "David G. Johnston" <david.g.johnston@gmail.com> 29 июля 2021 г. в 18:38:57

Re: pg_upgrade does not upgrade pg_stat_statements properly "David G. Johnston" <david.g.johnston@gmail.com> 29 июля 2021 г. в 18:36:58

Re: pg_upgrade does not upgrade pg_stat_statements properly Dave Cramer <davecramer@gmail.com> 29 июля 2021 г. в 17:10:01

Re: pg_upgrade does not upgrade pg_stat_statements properly Alvaro Herrera <alvherre@alvh.no-ip.org> 29 июля 2021 г. в 17:13:48

Re: pg_upgrade does not upgrade pg_stat_statements properly Dave Cramer <davecramer@gmail.com> 29 июля 2021 г. в 17:15:30

Re: pg_upgrade does not upgrade pg_stat_statements properly Jan Wieck <jan@wi3ck.info> 29 июля 2021 г. в 16:28:42

Re: pg_upgrade does not upgrade pg_stat_statements properly "David G. Johnston" <david.g.johnston@gmail.com> 29 июля 2021 г. в 16:44:30

Re: pg_upgrade does not upgrade pg_stat_statements properly Jan Wieck <jan@wi3ck.info> 29 июля 2021 г. в 16:55:51

Re: pg_upgrade does not upgrade pg_stat_statements properly "David G. Johnston" <david.g.johnston@gmail.com> 29 июля 2021 г. в 17:05:21

Re: pg_upgrade does not upgrade pg_stat_statements properly "David G. Johnston" <david.g.johnston@gmail.com> 29 июля 2021 г. в 15:39:32

Re: pg_upgrade does not upgrade pg_stat_statements properly Bruce Momjian <bruce@momjian.us> 29 июля 2021 г. в 16:12:51

Re: pg_upgrade does not upgrade pg_stat_statements properly Dave Cramer <davecramer@gmail.com> 29 июля 2021 г. в 15:46:36

Re: pg_upgrade does not upgrade pg_stat_statements properly Dave Cramer <davecramer@gmail.com> 29 июля 2021 г. в 11:02:41

Re: pg_upgrade does not upgrade pg_stat_statements properly Dave Cramer <davecramer@gmail.com> 15 июля 2021 г. в 15:21:59

Re: pg_upgrade does not upgrade pg_stat_statements properly "David G. Johnston" <david.g.johnston@gmail.com> 15 июля 2021 г. в 15:29:48

Re: pg_upgrade does not upgrade pg_stat_statements properly Dave Cramer <davecramer@gmail.com> 15 июля 2021 г. в 15:43:20

Re: pg_upgrade does not upgrade pg_stat_statements properly Alvaro Herrera <alvherre@alvh.no-ip.org> 15 июля 2021 г. в 16:11:38

Re: pg_upgrade does not upgrade pg_stat_statements properly Alvaro Herrera <alvherre@alvh.no-ip.org> 15 июля 2021 г. в 16:13:22

Re: pg_upgrade does not upgrade pg_stat_statements properly Dave Cramer <davecramer@gmail.com> 15 июля 2021 г. в 16:16:09

Re: pg_upgrade does not upgrade pg_stat_statements properly "David G. Johnston" <david.g.johnston@gmail.com> 15 июля 2021 г. в 16:25:37

Re: pg_upgrade does not upgrade pg_stat_statements properly Dave Cramer <davecramer@gmail.com> 15 июля 2021 г. в 16:35:05

Re: pg_upgrade does not upgrade pg_stat_statements properly Jan Wieck <jan@wi3ck.info> 15 июля 2021 г. в 16:35:55

Re: pg_upgrade does not upgrade pg_stat_statements properly "David G. Johnston" <david.g.johnston@gmail.com> 15 июля 2021 г. в 16:46:08

Re: pg_upgrade does not upgrade pg_stat_statements properly Jan Wieck <jan@wi3ck.info> 15 июля 2021 г. в 16:58:29

Re: pg_upgrade does not upgrade pg_stat_statements properly "David G. Johnston" <david.g.johnston@gmail.com> 15 июля 2021 г. в 17:10:45

Re: pg_upgrade does not upgrade pg_stat_statements properly Jan Wieck <jan@wi3ck.info> 15 июля 2021 г. в 18:14:28

Re: pg_upgrade does not upgrade pg_stat_statements properly Bruce Momjian <bruce@momjian.us> 15 июля 2021 г. в 18:26:24

Re: pg_upgrade does not upgrade pg_stat_statements properly "David G. Johnston" <david.g.johnston@gmail.com> 15 июля 2021 г. в 18:30:35

Re: pg_upgrade does not upgrade pg_stat_statements properly Dave Cramer <davecramer@postgres.rocks> 15 июля 2021 г. в 18:51:53

Re: pg_upgrade does not upgrade pg_stat_statements properly "David G. Johnston" <david.g.johnston@gmail.com> 15 июля 2021 г. в 20:24:17

Re: pg_upgrade does not upgrade pg_stat_statements properly Jan Wieck <jan@wi3ck.info> 15 июля 2021 г. в 23:18:10

Re: pg_upgrade does not upgrade pg_stat_statements properly "David G. Johnston" <david.g.johnston@gmail.com> 15 июля 2021 г. в 23:31:07

Re: pg_upgrade does not upgrade pg_stat_statements properly "David G. Johnston" <david.g.johnston@gmail.com> 15 июля 2021 г. в 16:15:34

Re: pg_upgrade does not upgrade pg_stat_statements properly Robert Eckhardt <eckhardtr@vmware.com> 15 июля 2021 г. в 16:31:04

Re: pg_upgrade does not upgrade pg_stat_statements properly Jan Wieck <jan@wi3ck.info> 15 июля 2021 г. в 16:38:45

Re: pg_upgrade does not upgrade pg_stat_statements properly "David G. Johnston" <david.g.johnston@gmail.com> 14 июля 2021 г. в 19:33:42

On Thu, 15 Jul 2021 at 12:25, David G. Johnston <david.g.johnston@gmail.com> wrote:

On Thu, Jul 15, 2021 at 9:16 AM Dave Cramer <davecramer@gmail.com> wrote:
Eh, and
pg_upgrade [other switches] --upgrade-extensions
sounds good too ...

Ultimately I believe this is the solution, however we still need to teach extensions how to upgrade themselves or emit a message saying they can't, or even ignore if it truly is a NOP.

If it's opt-in and simple I don't really care but I doubt I would use it as personally I'd rather the upgrade not touch my application at all (to the extent possible) and just basically promise that I'll get a reliable upgrade. Then I'll go ahead and ensure I have the backups of the new version and that my application works correctly, then just run the "ALTER EXTENSION" myself. But anything that will solve pain points for same-PostgreSQL-version extension upgrading is great.

I may have not communicated this clearly. In this case the application worked fine, the extension worked fine. The issue only arose when doing a dump and restore of the database and then the only reason it failed was due to trying to revoke permissions from pg_stat_statements_reset.

There may have been other things that were not working correctly but since it did not cause any errors it was difficult to know.

As Robert points out in the next message this is not a particularly great user experience

Dave

В списке pgsql-hackers по дате отправления

Предыдущее

От: Robert Eckhardt

Дата: 15 июля 2021 г. в 16:31:04

Сообщение: Re: pg_upgrade does not upgrade pg_stat_statements properly

Следующее

От: Jan Wieck

Дата: 15 июля 2021 г. в 16:35:55

Сообщение: Re: pg_upgrade does not upgrade pg_stat_statements properly