Project

General

Profile

Bug #4260

PostgreSQL update

Added by Alexander Pyhalov almost 7 years ago. Updated almost 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.

History

#1

Updated by Alexander Pyhalov almost 7 years ago

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

#2

Updated by Alexander Pyhalov almost 7 years ago

  • % Done changed from 0 to 20
#3

Updated by Alexander Pyhalov almost 7 years ago

Perl and PHP client PostgreSQL libraries were updated.

#4

Updated by Alexander Pyhalov almost 7 years ago

  • % Done changed from 20 to 30

C++, TCL and Java libraries were updated.

#5

Updated by Alexander Pyhalov almost 7 years ago

  • % Done changed from 30 to 40

pgbouncer was updated.

#6

Updated by Alexander Pyhalov almost 7 years ago

  • % Done changed from 40 to 50

pgadmin and pgagent were updated

#7

Updated by Alexander Pyhalov almost 7 years ago

Added pg_repack, Python psycopg2 module, pgloader

#8

Updated by Jon Tibble almost 7 years ago

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

#9

Updated by Alexander Pyhalov almost 7 years ago

Added pgpool-II

#10

Updated by Alexander Pyhalov almost 7 years ago

Added pgbadger

#11

Updated by Alexander Pyhalov almost 7 years ago

Added barman

#12

Updated by Alexander Pyhalov almost 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.

#13

Updated by Alexander Pyhalov almost 7 years ago

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

Updated by Ken Mays almost 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.

Also available in: Atom PDF