On Thu, Jun 5, 2014 at 5:37 PM, Andres Freund <and...@2ndquadrant.com> wrote: > On 2014-06-05 16:56:08 +0900, Amit Langote wrote: >> On Thu, Jun 5, 2014 at 4:09 PM, Fujii Masao <masao.fu...@gmail.com> wrote: >> > Do we need to back-patch this to older versions (i,e. 9.2, 9.1, ..)? >> > >> >> Yes, this should be backpatched to 9.2, 9.1, 9.0, too. > > I don't think it really needs to go to 9.0 - that didn't have > serializable. And before that it was fine to use serializable on a HS > standby. >
Yeah, you are right, s 9.0 hot standby server does allow to - [amit@localhost git]$ psql postgres -p 15432 Timing is on. psql (9.0.17) postgres=# begin transaction isolation level serializable; BEGIN whereas - [amit@localhost git]$ psql postgres -p 15432 Timing is on. psql (9.1.13) Type "help" for help. postgres=# begin transaction isolation level serializable; ERROR: cannot use serializable mode in a hot standby HINT: You can use REPEATABLE READ instead. Perhaps just the s/VACUUM/ANALYZE part for 9.0 then -- Amit -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers