http://permalink.gmane.org/gmane.comp.db.postgresql.announce hourly 1 1901-01-01T00:00+00:00 http://gmane.org/img/gmane-25t.png http://gmane.org http://permalink.gmane.org/gmane.comp.db.postgresql.announce/2039 <pre> Sorry, correct URL is http://www.postgresql.org/ftp/pgadmin3/release/v1.16.0-beta1/ </pre> Guillaume Lelarge 2012-05-16T18:54:25 http://permalink.gmane.org/gmane.comp.db.postgresql.announce/2038 <pre>pgAdmin v1.16.0 Beta 1 is now available for testing in source from: http://www.postgresql.org/ftp/pgadmin3/release/v1.14.0-beta1/ Unfortunately, Windows and Mac OS X distributions aren't yet available. Nevertheless, you can still have it with the PostgreSQL 9.2 beta 1 one-click installer from: http://www.postgresql.org/download/snapshots/ We're still working on a visual tour. In the meantime, the list of new features is available in the changelog (http://www.pgadmin.org/development/changelog.php). Please download a copy to test, and report any issues to pgadmin-support&lt; at &gt;postgresql.org to help us prepare for our upcoming 1.16 final release. Regards. </pre> Guillaume Lelarge 2012-05-16T17:27:43 http://permalink.gmane.org/gmane.comp.db.postgresql.announce/2037 <pre>PostgreSQL Conference Europe 2012 will be held on October 23-26 in Prague, The Czech Republic, at the Corinthia hotel. It will cover topics for PostgreSQL users, developers and contributors, as well as decision and policy makers. For more information about the conference, please see the website at http://2012.pgconf.eu/. We are now accepting proposals for talks. Please note that we are looking for talks in English and Czech. Each session will last 45 minutes, and may be on any topic related to PostgreSQL. Suggested topic areas include: * Developing applications for PostgreSQL * Administering large scale PostgreSQL installations * Case studies and/or success stories of PostgreSQL deployments * PostgreSQL tools and utilities * PostgreSQL hacking * Community &amp; user groups * Tuning the server * Migrating from other systems * Scaling/replication * Benchmarking &amp; hardware * PostgreSQL related products Of course, we're happy to receive proposals for talks on other PostgreSQL related topics as well. We also hav</pre> Magnus Hagander 2012-05-15T19:44:22 http://permalink.gmane.org/gmane.comp.db.postgresql.announce/2036 <pre>The PostgreSQL Global Development Group announces the beta release of PostgreSQL 9.2, which will include major increases in performance and both vertical and horizontal scalability. The PostgreSQL Project asks all users to download and begin testing 9.2 Beta as soon as possible. Major performance and scalability advances in this version include: * Index-only scans, allowing users to avoid inefficient scans of base tables * Enhanced read-only workload scaling to 64 cores and over 300,000 queries per second * Improvements to data write speeds, including group commit * Reductions in CPU power consumption * Cascading replication, supporting geographically distributed standby databases PostgreSQL 9.2 will also offer many new features for application developers, including: * JSON data support, enabling hybrid document-relational databases * Range types, supporting new types of calendar, time-series and analytic applications * Multiple improvements to ALTER and other statements, easing runtime </pre> josh< at >postgresql.org 2012-05-14T22:48:49 http://permalink.gmane.org/gmane.comp.db.postgresql.announce/2035 <pre>== PostgreSQL Weekly News - May 13 2012 == PostgreSQL Session will be held on October 4th, 2012, in Paris, France. More information at: http://www.postgresql-sessions.org/en/4/ == PostgreSQL Product News == AnySQL Maestro 12.5, an ODBC-based management tool which works with PostgreSQL, released. http://www.sqlmaestro.com/products/anysql/maestro/ pgXplorer, a GUI for postgres 8.4+, released. The code is open sourced under the ISC license and can be found on github at: https://github.com/davyjones/pgXplorer Postgres-XC 1.0beta2, a write-scalable multi-master symmetric cluster based on PostgreSQL, released. http://postgres-xc.sourceforge.net/docs/1_0/release-xc-1-0.html PL/Proxy 2.4, a database partitioning system implemented as a PL, released. http://pgfoundry.org/projects/plproxy/ SIDU 3.5 for PostgreSQL, a web-based tool for database administration, released. http://sidu.sf.net Version 1.25.1 of tail_n_mail, a Postgres log watcher program, released: http://bucardo.org/wiki/Tail_n_mail == PostgreSQL</pre> David Fetter 2012-05-14T05:52:44 http://permalink.gmane.org/gmane.comp.db.postgresql.announce/2034 <pre>Hi all, Postgres-XC, write-scalable multi-master symmetric cluster based on PostgreSQL, version 1.0beta2 has been released. This beta version is based on PostgreSQL 9.1.3. All the patches in PostgreSQL 9.1 stable branch have been merged up to commit 1c0e678 (4th of May 2012). You can download the tarball directly from here: https://sourceforge.net/projects/postgres-xc/files/latest/download This tarball contains all the HTML and man documentation. The following enhancements have been made since release of 1.0beta1: - Redaction of release notes, summarizing all the features added in Postgres-XC since the creation of the project - Support for make world - Regressions stabilized (no failures for 139 tests) - Fix of more than 50 bugs. - Merge with stable branch of PostgreSQL 9.1 (600~ commits). Compared to version Postgres-XC 0.9.7, the following features have been added: - Fast query shipping (FQS), quick identification of expressions in a query that can be pushed down to remote nodes - SERIAL types - TABLES</pre> Michael Paquier 2012-05-13T03:59:11 http://permalink.gmane.org/gmane.comp.db.postgresql.announce/2033 <pre>Hi! SQL Maestro Group announces the release of AnySQL Maestro 12.5, a powerful tool for managing any database engine accessible via ODBC driver or OLE DB provider (PostgreSQL, MySQL, SQL Server, Oracle, Access, etc). The new version is immediately available at http://www.sqlmaestro.com/products/anysql/maestro/ AnySQL Maestro comes in both Freeware and Professional editions. The feature matrix can be found at http://www.sqlmaestro.com/products/anysql/maestro/free_vs_pro/ Top 10 new features: =================== 1. Report Designer. 2. Support for auto increment columns for MS SQL Server and MS Access. 3. SQL Editors: Unicode support, text change markers, and improved code folding appearance. 4. Enhanced performance of the SQL Script Editor tool. 5. Improved Script Runner. 6. Inline images in the data grid. 7. Displaying BLOB data as PDF. 8. Creation of views from Visual Query Builder. 9. Updated Data Input form. 10. Spanish translation. In addition to this, several bugs have been fixed and s</pre> SQL Maestro Group 2012-05-10T12:46:55 http://permalink.gmane.org/gmane.comp.db.postgresql.announce/2032 <pre>====== PostgreSQL Session #4 : Call for Papers ====== After three successful sessions dedicated to the new features of PostgreSQL 9.0 (february 2011), to PostGIS (june 2011), and to replication systems (february 2012), we'd like to announce that the 4th PostgreSQL Session will be held on October 4th, 2012, in Paris, France. More informations at: http://www.postgresql-sessions.org/en/4/ The topic of the conference will be: "Migrate to PostgreSQL" We're launching a call for paper for this event. You can now submit your talks, in English or in French. Each talk should last 45 minutes (questions included) and should focus on the topic of the event. We are interested in any talk about the following subjects: * Database migration (ora2pg, ETL, etc.) * Application migration * Partitioning in PostgreSQL * Managing a cluster of PostgreSQL servers * Replication and High-Availability * Foreign Data Wrappers (oracle_fdw, mysql_fdw, tds_fdw) * TCO Comparison of DMBS Talks can be ei</pre> Guillaume Lelarge 2012-05-09T16:09:41 http://permalink.gmane.org/gmane.comp.db.postgresql.announce/2031 <pre>New version of PL/Proxy is out. Main change is that default remote username is now taken from current_user, not session_user. Also internal connection cache now supports having connections to same cluster under different usernames. Both changes together make SECURITY DEFINER functions work sensibly. Old behaviour was targeted to support obscure security schemes for connect strings, but this is now obsoleted by SQL/MED. More details: http://pgfoundry.org/frs/shownotes.php?release_id=1947 Downloads: http://pgfoundry.org/projects/plproxy/ About PL/Proxy -------------- PL/Proxy is database partitioning system implemented as PL language. Homepage: http://wiki.postgresql.org/wiki/PL/Proxy GIT: http://git.postgresql.org/gitweb?p=plproxy.git;a=summary Github: https://github.com/markokr/plproxy-dev List: http://lists.pgfoundry.org/mailman/listinfo/plproxy-users ---------------------------(end of broadcast)--------------------------- -To unsubscribe from this list, send an email to: </pre> Marko Kreen 2012-05-07T19:07:38 http://permalink.gmane.org/gmane.comp.db.postgresql.announce/2030 <pre>Greetings everyone. I have just released pgXplorer - a new GUI for postgres 8.4+. You can download the installers for Mac, Windows and Ubuntu from pgxplorer.com. The code is open sourced under the ISC license and can be found on github at: https://github.com/davyjones/pgXplorer Please raise any issues or concerns at the projects' github page. Thanks, dj ---------------------------(end of broadcast)--------------------------- -To unsubscribe from this list, send an email to: pgsql-announce-unsubscribe&lt; at &gt;postgresql.org </pre> dj< at >pgxplorer.com 2012-05-06T08:54:23 http://permalink.gmane.org/gmane.comp.db.postgresql.announce/2029 <pre>== PostgreSQL Weekly News - May 06 2012 == PostgreSQL conference China 2012 will be on June 14-17, 2012 in Beijing. http://wiki.postgresql.org/wiki/Pgconfchina2012 PostgreSQL Magazine #01 is out now. http://pgmag.org/01/ PostgreSQL Turkey User Group is organizing 2nd Turkish PostgreSQL Conference in Istanbul, on May 12, 2012. Magnus Hagander will be giving the keynote. Please register for free: http://pgday.PostgreSQL.org.tr/2012/ == PostgreSQL Product News == ODB 2.0.0, an ORM for C++, supports PostgreSQL. http://www.codesynthesis.com/pipermail/odb-announcements/2012/000013.html == PostgreSQL Jobs for May == http://archives.postgresql.org/pgsql-jobs/2012-05/threads.php == PostgreSQL Local == PGCon 2012 will be held 17-18 May 2012, in Ottawa at the University of Ottawa. It will be preceded by two days of tutorials on 15-16 May 2012. http://www.pgcon.org/2012/ PGDay France will be in Lyon on June 7, 2012. http://www.pgday.fr PostgreSQL Conference Europe 2012 will be in Prague, Czech Republic on </pre> David Fetter 2012-05-07T03:54:59 http://permalink.gmane.org/gmane.comp.db.postgresql.announce/2028 <pre>PostgreSQL conference China 2011 will be hold in June 14-17 in Beijing, China. PostgresQL User Group Conference China which organized by CPUG(China Postgres User Group) is an annual conference for PostgreSQL users in China, the conference is a hub for learning new features, sharing the know-how, and making friends about PostgreSQL. PostgresQL User Group Conference China 2012 will be on 14-17 June 2012 at Renmin University of China in Beijing with two days of Tutorials on 14-15 June 2012. Magnus Hagander,Simon Rigg and Suzuki Koichi from community will also join this conference to give keynote speeches. A Two-day free Postgres DBA training will be given for people who want to learn PostgreSQL administration in the first two days. In 16-17 June, and the conference will be organized in three tracks, PostgreSQL experts from local and community will give talks about: - System architecture for using PostgreSQL - Migration of production systems from another database - Data warehousing - Tuning Postg</pre> galy lee 2012-05-06T11:12:30 http://permalink.gmane.org/gmane.comp.db.postgresql.announce/2027 <pre>I am pleased to announce the release of ODB 2.0.0. ODB is an open source object-relational mapping (ORM) system for C++. It allows you to persist C++ objects to a relational database without having to deal with tables, columns, or SQL and without manually writing any of the mapping code. Major new features in this release: * Support for C++11 which adds integration with the new C++11 standard library components, including smart pointers and containers. Now you can use std::unique_ptr and std::shared_ptr as object pointers (their lazy versions are also provided). For containers, support was added for std::array, std::forward_list, and the unordered containers. * Support for polymorphism which allows you to persist, load, update, erase, and query objects of derived classes using their base class interfaces. Persistent class hierarchies are mapped to the relational database model using the table-per-difference mapping. * Support for composite object ids which are translate</pre> Boris Kolpackov 2012-05-02T12:33:44 http://permalink.gmane.org/gmane.comp.db.postgresql.announce/2026 <pre>I'm very pleased to announce the release of the first issue of PostgreSQL Magazine. This issue #01 is brought to you thanks to the collective work of dozen of people. Writers, Editors, Reviewers. Kudos to them all ! Here's a quick view of the ToC : - PostgreSQL 9.1 : 10 awesome new features - NoSQL : The Key Value store everyone ignored - Interview : Stefan Kaltenbrunner - Opinion : Funding PostgreSQL Features - Waiting for 9.2 : Cascading Streaming Replication - Tips &amp; Tricks : PostgreSQL in Mac OS X Lion The magazine is available online and on paper. You can either : * Read it Online: http://pgmag.org/01/read * Buy the Print Edition: http://pgmag.org/01/buy * or Download the PDF: http://pgmag.org/01/download Finally, I would like to thank our benefactors… Fotolia.com has offered us a free subscription plan to access their stock photo database. We also received fundings from PostgreSQL Europe (PGEU) and Software in the Public Interest (SPI). Thanks a lot to them ! </pre> PostgreSQL Magazine 2012-05-01T21:22:40 http://permalink.gmane.org/gmane.comp.db.postgresql.announce/2025 <pre>== PostgreSQL Weekly News - April 29 2012 == == PostgreSQL Jobs for April == http://archives.postgresql.org/pgsql-jobs/2012-04/threads.php == PostgreSQL Local == PGCon 2012 will be held 17-18 May 2012, in Ottawa at the University of Ottawa. It will be preceded by two days of tutorials on 15-16 May 2012. http://www.pgcon.org/2012/ PGDay France will be in Lyon on June 7, 2012. http://www.pgday.fr PostgreSQL Conference Europe 2012 will be in Prague, Czech Republic on October 23-26. The call for sponsors is open. http://2012.pgconf.eu/ == PostgreSQL in the News == Planet PostgreSQL: http://planet.postgresql.org/ PostgreSQL Weekly News is brought to you this week by David Fetter Submit news and announcements by Sunday at 3:00pm Pacific time. Please send English language ones to david&lt; at &gt;fetter.org, German language to pwn&lt; at &gt;pgug.de, Italian language to pwn&lt; at &gt;itpug.org. Spanish language to pwn&lt; at &gt;arpug.com.ar. == Reviews == == Applied Patches == Robert Haas pushed: - Minor improvements for CHECK NO INHERIT d</pre> David Fetter 2012-04-30T05:42:00 http://permalink.gmane.org/gmane.comp.db.postgresql.announce/2024 <pre>== PostgreSQL Weekly News - April 22 2012 == PostgreSQL Conference Europe 2012 will be in Prague, Czech Republic on October 23-26. The call for sponsors is open. http://2012.pgconf.eu/ PGNext has been cancelled. == PostgreSQL Product News == pgbouncer 1.5.1, a light-weight connection pooler for PostgreSQL, released. http://pgfoundry.org/frs/shownotes.php?release_id=1936 pgpool-II 3.1.3 and 3.0.7, a multi-purpose middleware which can provide connection pooling, replication, load balancing, parallel execution and more, released. http://www.pgpool.net/download.php?f=pgpool-II-3.1.3.tar.gz http://www.pgpool.net/download.php?f=pgpool-II-3.0.7.tar.gz Skytools 3.0.1, a package of tools developed by Skype for replication and failover including PgQ, a generic queuing framework and Londiste, a row-based master-slave replication replication system, released: http://pgfoundry.org/projects/skytools == PostgreSQL Jobs for April == http://archives.postgresql.org/pgsql-jobs/2012-04/threads.php == PostgreSQL Local </pre> David Fetter 2012-04-23T06:34:56 http://permalink.gmane.org/gmane.comp.db.postgresql.announce/2023 <pre>pgpool Global Development Group is pleased to announce the availability of pgpool-II 3.1.3 and 3.0.7 which are the latest stable versions of each major series. You can download the source codes from: http://www.pgpool.net/download.php?f=pgpool-II-3.1.3.tar.gz http://www.pgpool.net/download.php?f=pgpool-II-3.0.7.tar.gz ========================================================================= pgpool-II 3.1.3 ========================================================================= This is a bugfix release against pgpool-II 3.1.2. ------------------------------------------------------------------------- * Bug fixes ------------------------------------------------------------------------- - Add m4 files. This should prevent compiling problem on older OS's. (Tatsuo Ishii) - Fix to handle failover properly in detect_postmaster_down_error(). (Tatsuo Ishii) It is possible that it fails to read backend socket after detecting backend errors and before actually detaching the backend. - Fix bug </pre> Yugo Nagata 2012-04-23T06:25:37 http://permalink.gmane.org/gmane.comp.db.postgresql.announce/2022 <pre> 04/18/2012 PostgreSQL Conference Next 2012, in Denver from Jun 26th - 29th is cancelled. If you are looking for another conference in this time frame we suggest: http://www.pgcon.org/ There are also other conferences coming up in the next 6 months: http://www.postgresopen.org/ http://www.pgconf.eu Lastly, there is a Denver PgDay in October. PgDay's are a great way to meet locals and enjoy a smaller community setting but still maintain top notch content. Sincerely, Joshua D. Drake </pre> Joshua D. Drake 2012-04-18T18:50:37 http://permalink.gmane.org/gmane.comp.db.postgresql.announce/2021 <pre>[Re-reply to keep -announce in the loop..] On Wed, Apr 18, 2012 at 12:42 AM, Mark Felder &lt;feld&lt; at &gt;feld.me&gt; wrote: The .tar.gz on pgfoundry.org looks OK, so this must be some local problem. </pre> Marko Kreen 2012-04-18T14:07:34 http://permalink.gmane.org/gmane.comp.db.postgresql.announce/2020 <pre>Minor bugfix release. Main fix is the workaround for broken BOM handling in Python's logging.handlers.SysLogHandler. [ http://bugs.python.org/issue14452 ] Get it ------ Downloads: http://pgfoundry.org/projects/skytools Github: https://github.com/markokr/skytools Changes ------- = Features = * skytools.config: new .getbytes() method to support human-readable sizes. = Fixes = * skytools.skylog: Wrap logger.handlers.SysLogHandler to work around broken BOM addition when logging unicode() strings. * skytools.skylog: Improve compatibility with direct logger module usage. * debian/skytools.ini: include in tgz * pgqd(libusual): ignore EINTR on close() * Better error message in londiste.handler.dispatch when part_field is NULL. * Bump internal version in pgq/pgq_coop/pgq_node schemas. Seems I forgot to do it for 3.0, probably because there were doc-only changes in SQL code. About Skytools -------------- This is a package of tools</pre> Marko Kreen 2012-04-18T15:24:54 http://permalink.gmane.org/gmane.comp.db.postgresql.announce/2019 <pre> It appears the URL lets you specify what you want the downloaded filename to be. During this process I didn't download it myself; I updated the FreeBSD port's Makefile so I could send a patch to the port maintainer. As part of that process you update the version number in the Makefile, and then run "make makesum" which downloads the version specified and automatically updates the checksum and name of the tarball in the "distinfo" file. That was done automatically without human intervention. It added pgbouncer-1.5.1.tar.gz and the same checksum as the previous release. I just tested this again: [/usr/ports/databases/pgbouncer]# make makesum ===&gt; License BSD accepted by the user =&gt; pgbouncer-1.5.1.tar.gz doesn't seem to exist in /usr/ports/distfiles/. =&gt; Attempting to fetch http://pgfoundry.org/frs/download.php/3197/pgbouncer-1.5.1.tar.gz pgbouncer-1.5.1.tar.gz 100% of 401 kB 500 kBps distinfo: SHA256 (pgbouncer-1.5.1.tar.gz) = 408924d54794fcd63cd31284fa13a2126</pre> Mark Felder 2012-04-18T16:36:39 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.db.postgresql.announce