4 ms·

PostgreSQL 9.6.2, 9.5.6, 9.4.11, 9.3.16 and 9.2.20 released

119 points by willlll 10y ago

afarrell 10y ago
> Users should plan to apply this update at the next scheduled downtime. Folks who are looking for ways to upgrade PostgreSQL without downtime might want to take a look at this setup using pacemaker: https://github.com/gocardless/our-postgresql-setup https://github.com/gocardless/our-postgresql-setup http://www.interdb.jp/blog/pgsql/pg_pacemaker_01/ http://www.interdb.jp/blog/pgsql/pg_pacemaker_01/ digs into playing with the vagrant box a tiny bit. EDIT-- ah, found the talk explaining it: https://www.youtube.com/watch?v=SAkNBiZzEX8 https://www.youtube.com/watch?v=SAkNBiZzEX8
carbocation 10y ago
All pages on postgresql.org are currently showing an error for me.
- gigatexal 10y ago
  Same for me.
  - anarazel 10y ago
    The infrastructure people are on it, sorry for that.
    - striking 10y ago
      Wow, it's already fixed. Good work!
- krzrak 10y ago
  Maybe they have a downtime to upgrade PostgreSQL ;)
broswell 10y ago
OOPs. Here too! Server Error An internal server error occurred.
thejosh 10y ago
Cached link: https://webcache.googleusercontent.com/search?q=cache:CDUXYn8PAEwJ:https://www.postgresql.org/about/news/1733/+&cd=1&hl=en&ct=clnk&gl=au https://webcache.googleusercontent.com/search?q=cache:CDUXYn...
gsylvie 10y ago
I find their branching model interesting (no merges ever!): $ git log --graph --oneline --decorate --date-order --all * 86d911ec0f (HEAD -> master, origin/master, origin/HEAD) Allow index... * 7c5d8c16e1 Add explicit ORDER BY to a few tests that exercise hash-... | * 1888fad440 (origin/REL9_4_STABLE) Fix roundoff problems in float8... | | * 7786b98482 (origin/REL9_5_STABLE) Fix roundoff problems in float8... | | | * 404756fe89 (origin/REL9_6_STABLE) Fix roundoff problems in float8... * | | | 8f93bd8512 Fix roundoff problems in float8_timestamptz() and make... * | | | a507b86900 Add WAL consistency checking facility. * | | | 115cb31597 Fix relcache leaks in get_object_address_publication_rel() * | | | e35bbea7dd doc: Some improvements in CREATE SUBSCRIPTION ref page * | | | c3c4f6e174 Revise the way the element allocator for a simplehash... * | | | 242066cc8e Speed up "brin" regression test a little bit. * | | | ac8eb972f2 Avoid redefining simplehash_allocate/simplehash_free. * | | | 565903af47 Allow the element allocator for a simplehash to be specified. * | | | 94708c0e8c Fix compiler warning. * | | | 293e24e507 Cache hash index's metapage in rel->rd_amcache. | | | | * 903bfef382 (tag: REL9_2_20, origin/REL9_2_STABLE) Correct thinko... | | | | | * 4dd4e3fe10 (origin/REL9_3_STABLE) Correct thinko in last-minute... | * | | | | cd898769cb Correct thinko in last-minute release note item. | | * | | | 13b30ada99 Correct thinko in last-minute release note item. | | | * | | ae8a602c32 Correct thinko in last-minute release note item. * | | | | | 39c3ca5161 Correct thinko in last-minute release note item.
- justinlaster 10y ago
  > --date-order Why!?
  - gsylvie 10y ago
    Because git log --graph implies "--topo-order" and I didn't want that: $ git help log --graph [...] This implies the --topo-order option by default Without "--date-order" it looks like this: $ git log --graph --all --decorate --oneline * 86d911ec0f (HEAD -> master, origin/master, origin/HEAD) Allow index AMs to... * 7c5d8c16e1 Add explicit ORDER BY to a few tests that exercise hash-join code. * 8f93bd8512 Fix roundoff problems in float8_timestamptz() and make_interval(). * a507b86900 Add WAL consistency checking facility. * 115cb31597 Fix relcache leaks in get_object_address_publication_rel() * e35bbea7dd doc: Some improvements in CREATE SUBSCRIPTION ref page * c3c4f6e174 Revise the way the element allocator for a simplehash is specified. And 960 more commits before finally getting to this one... :-) | * 1888fad440 (origin/REL9_4_STABLE)

119 points by willlll 10y ago

> Users should plan to apply this update at the next scheduled downtime. Folks who are looking for ways to upgrade PostgreSQL without downtime might want to take a look at this setup using pacemaker: https://github.com/gocardless/our-postgresql-setup https://github.com/gocardless/our-postgresql-setup http://www.interdb.jp/blog/pgsql/pg_pacemaker_01/ http://www.interdb.jp/blog/pgsql/pg_pacemaker_01/ digs into playing with the vagrant box a tiny bit. EDIT-- ah, found the talk explaining it: https://www.youtube.com/watch?v=SAkNBiZzEX8 https://www.youtube.com/watch?v=SAkNBiZzEX8

carbocation 10y ago

All pages on postgresql.org are currently showing an error for me.

gigatexal 10y ago
Same for me.
- anarazel 10y ago
  The infrastructure people are on it, sorry for that.
  - striking 10y ago
    Wow, it's already fixed. Good work!
krzrak 10y ago
Maybe they have a downtime to upgrade PostgreSQL ;)

broswell 10y ago

OOPs. Here too! Server Error An internal server error occurred.

thejosh 10y ago

Cached link: https://webcache.googleusercontent.com/search?q=cache:CDUXYn8PAEwJ:https://www.postgresql.org/about/news/1733/+&cd=1&hl=en&ct=clnk&gl=au https://webcache.googleusercontent.com/search?q=cache:CDUXYn...

gsylvie 10y ago

I find their branching model interesting (no merges ever!): $ git log --graph --oneline --decorate --date-order --all * 86d911ec0f (HEAD -> master, origin/master, origin/HEAD) Allow index... * 7c5d8c16e1 Add explicit ORDER BY to a few tests that exercise hash-... | * 1888fad440 (origin/REL9_4_STABLE) Fix roundoff problems in float8... | | * 7786b98482 (origin/REL9_5_STABLE) Fix roundoff problems in float8... | | | * 404756fe89 (origin/REL9_6_STABLE) Fix roundoff problems in float8... * | | | 8f93bd8512 Fix roundoff problems in float8_timestamptz() and make... * | | | a507b86900 Add WAL consistency checking facility. * | | | 115cb31597 Fix relcache leaks in get_object_address_publication_rel() * | | | e35bbea7dd doc: Some improvements in CREATE SUBSCRIPTION ref page * | | | c3c4f6e174 Revise the way the element allocator for a simplehash... * | | | 242066cc8e Speed up "brin" regression test a little bit. * | | | ac8eb972f2 Avoid redefining simplehash_allocate/simplehash_free. * | | | 565903af47 Allow the element allocator for a simplehash to be specified. * | | | 94708c0e8c Fix compiler warning. * | | | 293e24e507 Cache hash index's metapage in rel->rd_amcache. | | | | * 903bfef382 (tag: REL9_2_20, origin/REL9_2_STABLE) Correct thinko... | | | | | * 4dd4e3fe10 (origin/REL9_3_STABLE) Correct thinko in last-minute... | * | | | | cd898769cb Correct thinko in last-minute release note item. | | * | | | 13b30ada99 Correct thinko in last-minute release note item. | | | * | | ae8a602c32 Correct thinko in last-minute release note item. * | | | | | 39c3ca5161 Correct thinko in last-minute release note item.

justinlaster 10y ago
> --date-order Why!?
- gsylvie 10y ago
  Because git log --graph implies "--topo-order" and I didn't want that: $ git help log --graph [...] This implies the --topo-order option by default Without "--date-order" it looks like this: $ git log --graph --all --decorate --oneline * 86d911ec0f (HEAD -> master, origin/master, origin/HEAD) Allow index AMs to... * 7c5d8c16e1 Add explicit ORDER BY to a few tests that exercise hash-join code. * 8f93bd8512 Fix roundoff problems in float8_timestamptz() and make_interval(). * a507b86900 Add WAL consistency checking facility. * 115cb31597 Fix relcache leaks in get_object_address_publication_rel() * e35bbea7dd doc: Some improvements in CREATE SUBSCRIPTION ref page * c3c4f6e174 Revise the way the element allocator for a simplehash is specified. And 960 more commits before finally getting to this one... :-) | * 1888fad440 (origin/REL9_4_STABLE)