[ANNOUNCE] PG Partition Manager (pg_partman) 2.0.0 Released

2015-06-16 Thread Keith Fiske
The next major version of pg_partman has been released.

The biggest new feature is there is now a background worker process
(http://www.postgresql.org/docs/9.4/static/bgworker.html) for
partition maintenance. This means, for most cases, a separate
scheduler is no longer required. This also means that PostgreSQL 9.4
at a minimum is required for 2.0.0. See the README and doc file for
more info on setting this up.

There are also now no longer distinct partition trigger types (static 
dynamic). These have been combined into a single trigger format that
better handles a wider range of incoming data to partition sets.
Instructions for migrating existing partition sets can be found in the
extension update file (pg_partman--1.8.7--2.0.0.sql).

The primary download location is github -
https://github.com/keithf4/pg_partman
It can also be found on pgxn - http://pgxn.org/dist/pg_partman/2.0.0

--
Keith Fiske
Database Administrator
OmniTI Computer Consulting, Inc.
http://www.keithf4.com


[ANNOUNCE] MyJSQLView Version 7.03 Released

2015-06-16 Thread dmp

The MyJSQLView project is pleased to release v7.03 to the public. The
release is to fix the plugin management tool proxy setting property.
Remote HTTP repositories can not be created or loaded. The release
also is for archiving purposes to finalize the last release before
the move of the code version control from Google Code to an alternative
private server.

Dana M. Proctor
MyJSQLView Project Manager
http://myjsqlview.com

MyJSQLView provides an easy to use Java based user interface frontend for
viewing, adding, editing, or deleting entries in several mainstream
databases. A query frame allows the building of complex SQL statements
and a SQL Query Bucket for saving such. The application allows easy
sorting, searching, and import/export of table data. A plug-in framework
has allowed the inclusion of tools to visually build queries, profile and
plot data for analysis.


--
Sent via pgsql-announce mailing list (pgsql-announce@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-announce


[ANNOUNCE] Psycopg 2.6.1 released

2015-06-16 Thread Daniele Varrazzo
Psycopg 2.6.1 has been released. You can get it from:

http://initd.org/psycopg/tarballs/PSYCOPG-2-6/psycopg2-2.6.1.tar.gz

The most important bug fixed in this release is the libcrypto
callbacks conflict between libpq and Python (#290), fixed by Jan
UrbaƄski: thank you very much. Other bugs fixed:

- Lists consisting of only None are escaped correctly (ticket #285).
- Correctly unlock the connection after error in flush (ticket #294).
- Fixed MinTimeLoggingCursor.callproc() (ticket #309).




Psycopg is the most popular PostgreSQL adapter for the Python
programming language. At its core it fully implements the Python DB
API 2.0 specifications. Several extensions allow access to many of the
features offered by PostgreSQL.


-- 
Sent via pgsql-announce mailing list (pgsql-announce@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-announce