FreeSoftNews

== PostgreSQL Weekly News - July 20 2008 ==

New Survey: How do you usually install or update PostgreSQL?
http://www.posgresql.org/community

Peter Eisentraut of the Core Team today took a PostgreSQL development
job at Sun Microsystems. At the same time, Josh Berkus left Sun, but
he hasn’t said yet where he’s going.

== PostgreSQL Product News ==

check_postgres 2.0.1 released.
http://bucardo.org/check_postgres/

Code Factory 8.7 for Windows released.
http://www.sqlmaestro.com/products/postgresql/codefactory/

• Read more: PostgreSQL Weekly News - July 20 2008

2ndQuadrant is now announcing a new course on PostgreSQL Administration
using the popular Navicat, a powerful administration and development
frontend tool.

This is an important step in increasing the diversity of the PostgreSQL
ecosystem. Navicat is an important tool for both PostgreSQL and MySQL,
so supporting customer’s existing tool choices makes co-existence or
conversion/migration to PostgreSQL a cheaper and smoother experience.

• Read more: PostgreSQL Administration using Navicat

I’m pleased to announce the availability of ‘one click’ PostgreSQL installers for Linux and Mac OS X. The installers are modeled on the Windows Installer, and currently include PostgreSQL 8.3.3, pgAdmin 1.8.4, pl/Java and the pl/pgsql debugger plugin.

You can download beta versions of the installers from:

http://www.postgresql.org/download/linux

http://www.postgresql.org/download/macosx

These installers are packaged by EnterpriseDB.

Hi!

SQL Maestro Group announce the release of PostgreSQL Code Factory 8.7, a
powerful Windows GUI solution for PostgreSQL data management and SQL
queries/scripts development.

http://www.sqlmaestro.com/products/postgresql/codefactory/

Please note that before July 20 you can purchase PostgreSQL Code Factory and
other our products and bundles with an unprecedented 30% discount.

New features
=================
1. Unicode/UTF-8 support.

2. A possibility of connecting to remote PostgreSQL servers via HTTP/PHP
tunneling.

3. SQL Formatter for DML statements (SELECT, INSERT, UPDATE and DELETE).

4. The SQL Generator tool has been implemented to produce various SQL
scripts (CREATE, DROP, SELECT, INSERT, etc) for the selected table/view.

5. Some new features have been incorporated into SQL Editor and SQL Script
Editor.  Now it is possible to comment/uncomment selected text, convert
selected text to different cases (lower, UPPER, and NameCase), export the
contents of the editor to RTF and HTML formats (to file or to clipboard) and
print/preview the contents of the editor.

6. Starting with this version it is possible to use the lookup editor for a
column, which is linked by a foreign key with a single column from another
table.

7. The Quick Connect mode has been added (to skip metadata refreshing on
connect).

There are also some other useful things. Full press release is available at
http://www.sqlmaestro.com/news/company/5248/

Background information:
=================
SQL Maestro Group is engaged in developing complete database admin and
management tools for MySQL, Oracle, MS SQL Server, DB2, PostgreSQL, SQLite,
Firebird and MaxDB providing the highest performance, scalability and
reliability to meet the requirements of today’s database applications.

Sincerely yours,
The SQL Maestro Group Team
http://www.sqlmaestro.com

== PostgreSQL Weekly News - July 13 2008 ==

== PostgreSQL Product News ==

Open Technology Group has created a high-availability training course.
http://www.otg-nc.com/training-courses/coursedetail.php?courseid=65&cat_id=8

== PostgreSQL Jobs for July ==

http://archives.postgresql.org/pgsql-jobs/2008-07/threads.php

== PostgreSQL Local ==

The Call for Papers for European PGDay has begun.
http://www.pgday.org/en/call4papers

• Read more: PostgreSQL Weekly News - July 13 2008

The Italian PostgreSQL Users Group (ITPUG - non profit organisation;
www.itpug.org), together with PostgreSQL Europe and the PostgreSQL
community is proud to announce the first official European event for the
PostgreSQL Project. We are currently seeking speakers and sponsors for
the event.

PGDay 2008 will be held in Prato, Tuscany, Italy on the 17th and 18th of
October 2008, with the Patronage of the Province of Prato.

The following organisations have given their support to PGDay (listed in
alphabetical order):

• Read more: European PostgreSQL Day 2008

MORRISVILLE, NC - July 9, 2008 - Open Technology Group, Inc. announces PostgreSQL High Availability Training

The Open Technology Group (OTG), a leader in the development and delivery of training solutions centered about Open Source technologies, released the latest in its set of advanced PostgreSQL training courses - Deploying HA PostgreSQL Solutions.  “This course is designed based on the needs and requirements of our enterprise customers” said Chander Ganesan, President, “it teaches students how to implement and manage fast-failover, highly available replication solutions in their enterprise”. It covers a wide range of HA deployment scenarios through the use of lecture and exercises, including deploying solutions that leverage Common Address Redundancy Protocol (CARP), Heartbeat version 2 (with Cluster Resource Manager support), and failover Slony-I replication environments, including deployment of highly available, transaction durable, Slony-I clusters (i.e., no transactions lost in a single node failure).

• Read more: Open Technology Group, Inc. announces PostgreSQL High Availability Training

As of today, the Elephant is offically 12 years old.

On July 8, 1996, Marc Fournier set up the first public CVS server of the ten-year-old POSTGRES code. A small group of volunteer hackers started improving it, soon releasing a steady stream of improvements.

Today, PostgreSQL is one of the most popular SQL/relational databases in the world and respected throughout the industry for maturity, clean code, and unique advanced features.

So, happy birthday, PostgreSQL!

xTuple, the leader in open source enterprise resource planning software, today announced the release of xTuple ERP 3.0, with an array of powerful new tools that enable ordinary system users to get more functionality from the world’s most advanced open source ERP system — with no coding required. Among the key new features is a user-friendly Screen Builder for designing customized system dashboards and the world’s only open source assemble-to-order (ATO) Product Configurator for streamlining non-inventory order processing.

“xTuple has the most powerful open source ERP system on the market, but there’s been a perception that you need to be a C++ coder or database guru in order to make changes,” said Ned Lilly, president and CEO of xTuple. “We’ve eliminated that barrier with a user interface designer that allows end-users to create new screens and menu options with literally no coding required.”

Read more at PostgreSQL

== PostgreSQL Weekly News - July 06 2008 ==

The July CommitFest has begun. Start reviewing
http://wiki.postgresql.org/wiki/CommitFest:2008-07

== PostgreSQL Product News ==

MicroOLAP Database Designer 1.2.4 for PostgreSQL released.
http://microolap.com/products/database/postgresql-designer/

== PostgreSQL Jobs for July ==

http://archives.postgresql.org/pgsql-jobs/2008-07/threads.php

== PostgreSQL Local ==

pgDay Portland is July 20, just before OSCON.
http://pugs.postgresql.org/node/400

PGCon Brazil 2008 will be on September 26-27 at Unicamp in Campinas.
http://pgcon.postgresql.org.br/index.en.html

• Read more: PostgreSQL Weekly News - July 06 2008

Following the phenomenal international success of PGDay 2007, the 2008
event, to be held on October 17th and 18th will include both an Italian
program and a European program running in parallel. This call for papers
is for the European program - expect a separate one for the Italian one.

The conference will once again be held in the beautiful historic
surroundings of the Monash University Prato Centre in Prato, a small
walled town near Florence, Tuscany.

European PGDay 2008 is the main European event about PostgreSQL this
year. If you’re doing interesting PostgreSQL work in Europe or
elsewhere, this is your chance to tell people about it! Our goal is to
have a complete track of English talks during the conference, so that at
any given time there will be at least one English and one Italian talk
available to go to.

• Read more: Call for Papers - European PGDay 2008

== PostgreSQL Weekly News - June 29 2008 ==

July’s commit-fest is starting soon.

== PostgreSQL Product News ==

pgsnap 0.4 released.
http://pgsnap.projects.postgresql.org/

PL/Proxy 2.0.6 released.
http://pgfoundry.org/projects/plproxy/

• Read more: PostgreSQL Weekly News - June 29 2008

== PostgreSQL Weekly News - June 22 2008 ==

New Survey: What TODO would you most like?
http://www.postgresql.org/community/

== PostgreSQL Jobs for June ==

http://archives.postgresql.org/pgsql-jobs/2008-06/threads.php

== PostgreSQL Local ==

TorontoPUG’s first meeting will be June 23 at The Rhino.
http://pugs.postgresql.org/blog/159

OKPUG’s first meeting will be June 23 at 7:00pm at Coach’s in Norman, OK.
http://pugs.postgresql.org/node/408

PgDay.IT’s planning meeting will be Wednesday, June 25 at 2130 CET via IRC.
irc://irc.freenode.net/pgday-it

pgDay Portland is July 20, just before OSCON.
http://pugs.postgresql.org/node/400

PGCon Brazil 2008 will be on September 26-27 at Unicamp in Campinas.
http://pgcon.postgresql.org.br/index.en.html

• Read more: PostgreSQL Weekly News - June 22 2008

== PostgreSQL Weekly News - June 15 2008 ==

PostgreSQL 8.3.3, 8.2.9, etc. have been released. Upgrade as soon as
practical.

== PostgreSQL Product News ==

check_postgres 1.8.2 released.
http://bucardo.org/check_postgres/

== PostgreSQL Jobs for June ==

http://archives.postgresql.org/pgsql-jobs/2008-06/threads.php

== PostgreSQL Local ==

pgDay San Francisco needs presentations for August 5. Submit by June 17th.
http://pugs.postgresql.org/node/415

TorontoPUG’s first meeting will be June 23 at The Rhino.
http://pugs.postgresql.org/blog/159

OKPUG’s first meeting will be June 23 at 7:00pm at Coach’s in Norman, OK.
http://pugs.postgresql.org/node/408

PgDay.IT’s planning meeting will be Wednesday, June 25 at 2130 CET via IRC.
irc://irc.freenode.net/pgday-it

pgDay Portland needs presentations for July 20. Submit by 20th.
http://pugs.postgresql.org/node/400

PGCon Brazil 2008 will be on September 26-27 at Unicamp in Campinas.
http://pgcon.postgresql.org.br/index.en.html

PGDay.IT 2008 will be October 17 and 18 in Prato.
http://www.pgday.org/it/

== PostgreSQL in the News ==

Planet PostgreSQL: http://www.planetpostgresql.org/

• Read more: PostgreSQL Weekly News - June 15 2008

———————————————————————
PostgreSQL New RPM Sets
2008-06-14

Versions: 8.3.3, 8.2.9, 8.1.13, 8.0.17, 7.4.21

Set label: 8.3.3-1PGDG, 8.2.9-1PGDG,, 8.1.13-1PGDG 8.0.17-1PGDG, 7.4.21-1PGDG
———————————————————————

———————————————————————
Release Info:

PostgreSQL RPM Building Project has released RPMs for new PostgreSQL
minor releases, and they are available in main FTP site and its mirrors.
Users should upgrade to these versions as soon as possible.

• Read more: New RPM Sets for Fedora / Red Hat Enterprise Linux / CentOS

Updates for all maintained versions of PostgreSQL are available today: 8.3.3, 8.2.9, 8.1.13, 8.0.17 and 7.4.21. These releases fix more than two dozen minor issues reported and patched over the last few months.

Read more at PostgreSQL

The pgAdmin Development Team are pleased to announce the release of pgAdmin 1.8.4, the Open Source graphical PostgreSQL administration tool for Windows, Linux, FreeBSD, Mac OS X and Solaris.

Read more at PostgreSQL

The pgAdmin Development Team are pleased to announce the release of
pgAdmin 1.8.4, the Open Source graphical PostgreSQL administration tool
for Windows, Linux, FreeBSD, Mac OS X and Solaris, now available for
download in source and a variety of binary formats from:

http://www.pgadmin.org/download/

v1.8.4 is primarily a bug fix release, including the following changes. Note
that v1.8.3 was never announced as a release due to an issue found at the
last minute.

• Read more: pgAdmin III v1.8.4 released

== PostgreSQL Weekly News - May 18 2008 ==

As expected, the May commitfest is coming to a much smoother
conclusion than the previous one.

Tatsuo Ishii sent in a patch to add WITH RECURSIVE. If accepted, this
will make PostgreSQL the first FOSS database with the native ability
to handle tree- and directed-graph structures.

== PostgreSQL Product News ==

• Read more: PostgreSQL Weekly News - May 18 2008

The Brasilian PostgreSQL User Group is proud to invite you to
participate in PGCon-Brazil 2008[1]. After the realization of
PGCon-Brazil 2007[2], we inviting the international comunity to submit
your proposal of lectures to our second release of this event.
PGCon-Brasil 2008 will happen in 26 and 27 of september, at
UNICAMP[3].

* Submissions:
o We will choose up to 2 lectures in this year;
o Each lecture will have 60 minutes including time for questions;
o Any one could send more then one proposal, but is possible
that no more than one will be select;

• Read more: Call for papers in PGCon Brazil 2008