Project

General

Profile

Actions

Bug #4260

closed

PostgreSQL update

Added by Alexander Pyhalov over 7 years ago. Updated over 7 years ago.

Status:
Closed
Priority:
Normal
Category:
OI-Userland
Target version:
-
Start date:
2013-10-23
Due date:
2013-12-04
% Done:

100%

Estimated time:
40.00 h
Difficulty:
Medium
Tags:
postgresql

Description

Currently, OI ships PostgreSQL 8.2, 8.3 and 8.4 and several related products - PostgreSQL language libraries (C++/Perl/PHP/Tcl/Java), pgbouncer, pgadmin, pgagent. Some dependent products are compiled against this versions ( library/apr-util/dbd-pgsql ).
We need to deprecate tools based on 8.2, 8.3.
PostgreSQL 8.4 should go to userland gate. Also we need to add modern PostgreSQL version to userland (at least, 9.3, perhaps, 9.2).
Then we need to recompile language libraries and different tools against modern PostgreSQL.
We need some infrastructure to support multiple PostgreSQL version in userland gate and to easily switch default PostgreSQL version.

Actions #1

Updated by Alexander Pyhalov over 7 years ago

PostgreSQL 8.4.18 an 9.3.1 are now available from /hipster repository.

Actions #2

Updated by Alexander Pyhalov over 7 years ago

  • % Done changed from 0 to 20
Actions #3

Updated by Alexander Pyhalov over 7 years ago

Perl and PHP client PostgreSQL libraries were updated.

Actions #4

Updated by Alexander Pyhalov over 7 years ago

  • % Done changed from 20 to 30

C++, TCL and Java libraries were updated.

Actions #5

Updated by Alexander Pyhalov over 7 years ago

  • % Done changed from 30 to 40

pgbouncer was updated.

Actions #6

Updated by Alexander Pyhalov over 7 years ago

  • % Done changed from 40 to 50

pgadmin and pgagent were updated

Actions #7

Updated by Alexander Pyhalov over 7 years ago

Added pg_repack, Python psycopg2 module, pgloader

Actions #8

Updated by Jon Tibble over 7 years ago

Wishlist: pgbadger (performance analysis via logs), barman (backup and recovery)

Actions #9

Updated by Alexander Pyhalov over 7 years ago

Added pgpool-II

Actions #10

Updated by Alexander Pyhalov over 7 years ago

Added pgbadger

Actions #11

Updated by Alexander Pyhalov over 7 years ago

Added barman

Actions #12

Updated by Alexander Pyhalov over 7 years ago

Marked old PostgreSQL versions as "obsolete". Also obsoleted pg_upgrade tool - standard pg_upgrade tool is included in pkg:/database/postgres-93/contrib.

Actions #13

Updated by Alexander Pyhalov over 7 years ago

  • Status changed from New to In Progress
  • % Done changed from 50 to 100
Actions #14

Updated by Ken Mays over 7 years ago

  • Due date set to 2013-12-04
  • Category set to 10
  • Status changed from In Progress to Closed
  • Estimated time set to 40.00 h
  • Tags changed from needs-triage to postgresql

No testing issues reported on packages submitted to hipster repo. Closing as 'progress complete' from package maintainer.

Actions

Also available in: Atom PDF