Noticias relacionadas con PostgreSQL

FOSDEM PGDay 2017

Eventos PostgreSQL [ENG] - Vie, 03/02/2017 - 01:00

PostgreSQL Europe will host a separate PGDay as well as a developer room during FOSDEM 2017.

pgwatch2: PostgreSQL monitoring has never been easier before

Noticias PostgreSQL [ENG] - Mar, 31/01/2017 - 01:00
pgwatch 2: PostgreSQL monitoring made easy

Cybertec Schönig & Schönig GmbH proudly presents pgwatch 2 - the most easy to install monitoring tool for PostgreSQL ever released.

It is based on Grafana and offers out of the box monitoring for PostgreSQL databases. Due to the use of containers, pgwatch 2 can be installed in minutes without having to worry about dependencies and complex installation procedures. It is pre-configured. All it needs is a database connection and you are ready to go.

Fire it up and pgwatch will already collect data and display vital information for you in no time.

pgwatch 2 is Open Source can be used free of charge.

Please share feedback as we will improve pgwatch based on your ideas.

More information can be found on our website

Follow us on twitter @PostgresSupport and share your feedback.

pgBadger v9.1 has been released

Noticias PostgreSQL [ENG] - Vie, 27/01/2017 - 01:00

Paris, France - January 24th, 2017

pgBadger is a PostgreSQL performance analyzer, built for speed with fully detailed reports based on your PostgreSQL log files.

pgBadger 9.1 was released today, this is a maintenance release that fix some minor bugs. There is also a new report on error class distribution and some feature enhancements:

  • Add report of error class distribution when SQLState is available in the log_line_prefix (see %e placeholder).
  • Update SQL Beautifier to pgFormatter v1.6 code.
  • Improve error message normalization.
  • Add --normalized-only option to generate a text file containing all normalized queries found in a log with count.
  • Allow %c (session id) to replace %p (pid) as unique session id.
  • Add waiting for lock messages to event reports.
  • Add --start-monday option to start calendar weeks in Monday instead of default to Sunday.

Here are the complete list of changes:

  • Add report of error class distribution when SQLState is available in the log line prefix. Thanks to jacks33 for the feature request.
  • Fix incremental global index on resize. Thanks to clomdd for the report.
  • Fix command tag log_line_prefix placeholder %i to allow space character.
  • Fix --exclude-line options and removing of obsolete directory when retention is enabled and --noreport is used.
  • Fix typo in "vacuum activity table". Thanks to Nicolas Gollet for the patch.
  • Fix autovacuum report. Thanks to Nicolas Gollet for the patch.
  • Fix author of pgbadger's logo - Damien Cazeils and English in comments. Thanks to Thibaut Madelaine for the patch.
  • Add information about pgbouncer log format in the -f option. Thanks to clomdd for the report.
  • Add --normalized-only information in documentation.
  • Fix broken report of date-time introduced in previous patch.
  • Fix duration/query association when log_duration=on and log_statement=all. Thanks to Eric Jensen for the report.
  • Fix normalization of messages about advisory lock. Thanks to Thibaut Madelaine for the report.
  • Fix report of auto_explain output. Thanks to fch77700 for the report.
  • Fix unwanted log format auto detection with log entry from stdin. Thanks to Jesus Adolfo Parra for the report.
  • Add left open parentheses to the "stop" chars of regex to look for db client in the prefix to handle the PostgreSQL client string format that includes source port. Thanks to Jon Nelson for the patch.
  • Fix some spelling errors. Thanks to Jon Nelson for the patch.
  • Allow %c (session id) to replace %p (pid) as unique session id. Thanks to Jerryliuk for the report.
  • Allow pgBadger to parse default log_line_prefix that will be probably used in 10.0: '%m [%p] '
  • Fix missing first line with interpreter call.
  • Fix missing Avg values in CSV report. Thanks to Yosuke Tomita for the report.
  • Fix error message in autodetect_format() method.
  • Add --start-monday option to start calendar weeks in Monday instead of default to Sunday. Thanks to Joosep Mae for the feature request.
  • Fix --histo-average option. Thanks to Yves Martin for the report.
  • Remove plural form of --ssh-option in documentation. Thanks to mark-a-s for the report.
  • Fix --exclude-time filter and rewrite code to skip unwanted line as well code to update the progress bar. Thanks to Michael Chesterton for the report.
  • Fix support to %r placeholder in prefix instead of %h.
Links & Credits

DALIBO would like to thank the developers who submitted patches and the users who reported bugs and feature requests.

pgBadger is an open project. Any contribution to build a better tool is welcome. You just have to send your ideas, features requests or patches using the GitHub tools or directly on our mailing list.

Links :

  • Download : https://github.com/dalibo/pgbadger/releases/
  • Mailing List : https://groups.google.com/forum/?hl=fr#!forum/pgbadger (pgbadger@googlegroups.com)

About pgBadger :

pgBagder is a new generation log analyzer for PostgreSQL, created by Gilles Darold (also author of ora2pg, the powerful migration tool). pgBadger is a fast and easy tool to analyze your SQL traffic and create HTML5 reports with dynamics graphs. pgBadger is the perfect tool to understand the behavior of your PostgreSQL servers and identify which SQL queries need to be optimized.

Docs, Download & Demo at http://dalibo.github.io/pgbadger/

About DALIBO :

DALIBO is the leading PostgreSQL company in France, providing support, trainings and consulting to its customers since 2005. The company contributes to the PostgreSQL community in various ways, including : code, articles, translations, free conferences and workshops

Check out DALIBO's open source projects at http://dalibo.github.io

Inaugural meeting of pgCMH

Eventos PostgreSQL [ENG] - Mar, 24/01/2017 - 01:00

Please join fellow Central OH-based PostgreSQL enthusiasts for the first ever mtg of the newly formed PUG, pgCMH!

DB Doc 3.5 for PostgreSQL released

Noticias PostgreSQL [ENG] - Jue, 12/01/2017 - 01:00

Yohz Software has released a new version of DB Doc for PostgreSQL - a PostgreSQL schema documentation tool.

The latest version is 3.5, and includes the following changes:

  • Users can now choose which schemas to generate documentation for.
  • A warning is now raised when sequence properties cannot be read, allowing the export process to continue
  • Bug fix - function arguments raising errors.
  • Bug fix - PDF output causing out of range errors.

What DB Doc can do for PostgreSQL users:

  • Create documents in HTML, CHM, PDF, and MS Word formats
  • Eliminate tedious and time-consuming manual documentation tasks.
  • Satisfy audit requirements by keeping complete and timely documentation.
  • Document a database in a couple of clicks.
  • View inter-object and inter-database dependencies in your documents.
  • Document layouts can be fully customizable to suit your requirements.
  • Keep teams up to date by distributing documentation.

System requirements:

  • Runs on Windows XP to Windows 10.
  • Runs on Wine, so you can use DB Doc on your favorite Linux distribution.
  • Supports PostgreSQL 8.3 to 9.6, without the need for any additional database drivers.

For more information about DB Doc for PostgreSQL, please visit http://www.yohz.com/dbdoc_details.htm, and download a free 30-day trial.

About Yohz Software

Yohz Software is a developer of database applications for most popular database engines. Learn more about Yohz Software at http://www.yohz.com.

Announcing The Release Of repmgr 3.3

Noticias PostgreSQL [ENG] - Vie, 06/01/2017 - 01:00

Oxford, United Kingdom - January 6, 2017

2ndQuadrant is proud to announce the release of repmgr version 3.3, the popular tool for PostgreSQL failover since 2010.

repmgr 3.3 provides a number of usability improvements for the repmgr command line utility, particularly for the ‘standby clone’ and ‘standby register’ commands. These changes are primarily aimed at making repmgr easier to use when provisioning complex replication clusters.

repmgrd users should take note of the changes to repmgr logging behaviour.

From repmgr 3.3, support for the upcoming PostgreSQL 10 release will be provided as far as possible. PostgreSQL 10 is still under development with significant changes expected to the implementation of replication functionality; anyone wishing to test repmgr with PostgreSQL 10 should build from the repmgr master branch. Links

repmgr is an open source package that helps DBAs and System Administrators manage a cluster of PostgreSQL databases. By taking advantage of the Hot Standby capability introduced in PostgreSQL 9, repmgr greatly simplifies the process of setting up and managing databases with high availability and scalability requirements.

repmgr is distributed under GPL v3 and maintained by 2ndQuadrant.

Barman v2.1 Announced

Noticias PostgreSQL [ENG] - Jue, 05/01/2017 - 01:00

2ndQuadrant announces the release of Barman version 2.1, a Backup and Recovery Manager for PostgreSQL.

This minor release fixes a few bugs. It also introduces the --archive option to the switch-xlog command, in order to help users during the installation process of a new server.

For a complete list of changes, see the "Release Notes" section below.

Links Release notes
  • Add --archive and --archive-timeout options to switch-xlog command
  • Preliminary support for PostgreSQL 10 (#73)
  • Minor additions:
    • Add last archived WAL info to 'diagnose' output
    • Add start time and execution time to the output of 'delete' command
  • Minor bug fixes:
    • Return failure for 'get-wal' command on inactive server
    • Make 'streaming_archiver_names' and 'streaming_backup_name' options global (#57)
    • Fix rsync failures due to files truncated during transfer (#64)
    • Correctly handle compressed history files (#66)
    • Avoid de-referencing symlinks in 'pg_tblspc' when preparing recovery (#55)
    • Fix comparison of last archiving failure (#40, #58)
    • Avoid failing recovery if postgresql.conf is not writable (#68)
    • Fix output of 'replication-status' command (#56)
    • Exclude files from backups like pg_basebackup (#65, #72)
    • Exclude directories from other Postgres versions while copying tablespaces (#74)
Download About

Barman (Backup and Recovery Manager) is an open-source administration tool for disaster recovery of PostgreSQL servers written in Python. It allows your organisation to perform remote backups of multiple servers in business critical environments to reduce risk and help DBAs during the recovery phase.

Barman is distributed under GNU GPL 3 and maintained by 2ndQuadrant.

Support for PostgreSQL 9.5 and 9.6 in dbForge Data Compare for PostgreSQL

Noticias PostgreSQL [ENG] - Lun, 26/12/2016 - 01:00

Devart has released a new version of dbForge Data Compare for PostgreSQL – a powerful and easy to use tool for table data comparison and synchronization.

Devart, a Czech software provider of database connectivity solutions and tools for database management and development, announced the release of dbForge Data Compare for PostgreSQL that comes with support for PostgreSQL 9.5, 9.6, redesigned Comparison Document, and with the new Document Categories feature.

Data Compare for PostgreSQL has the following new features and improvements:

  • Support for PostgreSQL 9.5, 9.6
  • Comparison document has been completely redesigned
  • New JSON View and redesigned XML view in Data Editor and Viewer window
  • Ability to assign categories for documents from different connections
  • New installation wizard and redesigned skins
  • New easy to use trial product activation

dbForge Data Compare for PostgreSQL is a Postgre Data Diff and Sync tool that allows users to review all the differences in tables being compared and execute an automatically generated script to remove these differences.

For more information about dbForge Data Compare for PostgreSQL, please visit https://www.devart.com/dbforge/postgresql/datacompare/.

About Devart

Devart is one of the leading developers of database tools and administration software, ALM solutions, data providers for various database servers, data integration and backup solutions. The company also implements Web and Mobile development projects.

Learn more about Devart at https://www.devart.com.

Registration for FOSDEM PGDay 2017 is now open!

Noticias PostgreSQL [ENG] - Vie, 16/12/2016 - 01:00

Registration for the FOSDEM PGDay 2017 in Brussels is now open.

FOSDEM PGDay 2017 is a one day, one track conference which is held as an extension to the PostgreSQL activities at FOSDEM. It takes place on Ferbruary 3rd in the Brussels Marriott hotel.

Registration for the FOSDEM PGDay 2017 is required. Registration for FOSDEM itself or the PostgreSQL Devroom at FOSDEM is not required.

More information on the event, venue and schedule as well as registration can be found here:

https://2017.fosdempgday.org/

pgDay Asia 2017 is CFP is Open

Noticias PostgreSQL [ENG] - Vie, 16/12/2016 - 01:00

Following the success of first pan-Asia Postgres event - pgDay Asia 2016 held in March 2016, we are pleased to announce pgDay Asia 2017 to be held in Singapore. The conference will be held along with FOSSASIA - one of the largest FOSS conference on the planet. pgDay Asia will be PostgreSQL conference series for all PostgreSQL enthusiasts in the Asia Pacific region.

For more details on FOSSASIA check FOSSASIA 2017 website

So, you will be able to enjoy one of the largest PostgreSQL conference in Asia and one of the largest FOSS conferences to meet new friends in Asia in the same week!

We would also like to open Call For Paper for pgDay Asia 2017. Some of the topics which can be used for submitting a talk are- 1. Migration projects 2. Performance troubleshooting and tuning 3. noSQL and geo-spatial features of Postgres 4. Unique use-case and customer stories 5. Postgres internals and their value for end users

For some examples you can refer to the papers which were presented at last year's event

Of course we are happy to receive proposal for talk on other PostgreSQL related topics as well.

To submit you proposal for presentation please go to this submission link

Dates

Friday, March 17th - Postgres Talks at pgDay Asia Saturday, March 18th - pgDay 2017 at FOSSASIA 2017

Venue

To be Announced

Important Dates

2016-12-16: Proposals acceptance begins 2017-01-16: Proposals acceptance ends 2017-01-20: Authors of accepted proposals contacted

If you need any additional information please contact our team at pgday-asia@googlegroups.com

Let's meet many PG and FOSS folks in Singapore!

This conference is organized by the PostgreSQL people from Asian communities (You can see the list on the web site). If you have any question, feel free to contact us on pgday-asia@googlegroups.com. The finances and local logistics for pgDay Asia 2016 are being handled by Ashnik Pte Ltd, Singapore this year.

As always, this event will not be possible without generous sponsorship and support from many different organizations. We will be soon sharing details of sponsorship opportunities at pgDay Asia 2017.

PgDay.IT 2016

Eventos PostgreSQL [ENG] - Mar, 13/12/2016 - 01:00

The tenth edition of the Italian PostgreSQL Day, also known as PgDay.IT. A whole day about our favorite database and its ecosystem.

CHAR(16)

Eventos PostgreSQL [ENG] - Mar, 06/12/2016 - 01:00

CHAR(16) is an international conference to celebrate and showcase the significant developments the leading PostgreSQL engineering teams have made in the areas of Clustering, High Availability and Replication. This year's event includes an optional 1 day training track.

PGConf ASIA 2016

Eventos PostgreSQL [ENG] - Vie, 02/12/2016 - 01:00

PGConf.ASIA 2016 is an international conference for PostgreSQL, celebrating its 20th anniversary.

FOSDEM PGDay 2017 & FOSDEM Devroom Call for Papers

Noticias PostgreSQL [ENG] - Vie, 25/11/2016 - 01:00

FOSDEM PGDay 2017 is a one day conference held this year on February 3rd followed immediately by the two day FOSDEM conference in Brussels at which we'll be hosting additional sessions on February 5th.

For more information on FOSDEM PGDay, please see:

https://2017.fosdempgday.org/

For more information on FOSDEM, please see:

https://fosdem.org/2017/

The call for papers for both the PGDay and FOSDEM Devroom has now been extended until midnight CET, 4th December. If you would like to submit a talk, please see the website:

https://2017.fosdempgday.org/callforpapers/

Talks may be on any topic related to PostgreSQL in some way. Suggested topic areas include:

  • Developing applications with or for PostgreSQL
  • Administering large scale PostgreSQL installations
  • Case studies and/or success stories of PostgreSQL deployments (or interesting failures)
  • PostgreSQL tools and utilities
  • PostgreSQL internals hacking
  • Community and local user groups
  • Tuning and performance improvements
  • Migration from other database systems
  • Scaling, Clustering and High Availability
  • Replication
  • Recovery and Backup strategies
  • Benchmarking and hardware
  • PostgreSQL related products
  • DevOps and continuous deployment/configuration/integration around PostgreSQL

Of course, we're happy to receive proposals for talks on other PostgreSQL related topics as well.

NOTE: Please submit talks through our website for both the PGDay and FOSDEM Devroom. DO NOT use the FOSDEM Pentabarf system as we are notmanaging the PostgreSQL talks though it.

The PostgreSQL Europe team will also have a table throughout the FOSDEM event; please feel free to stop by to chat with us about PostgreSQL and pickup some swag!

DbWrench Database Design 4.0 Released

Noticias PostgreSQL [ENG] - Mar, 22/11/2016 - 01:00

Version 4.0 of DbWrench is now available for download.

This release marks the switch from version 3 to version 4 of the product cycle. This release focused on the complete replacement of the editor code complete framework. We believe the new code complete framework is more compact and much more responsive. Also the look and styling for the database documentation has been improved.

It is our hope that these improvement will make DbWrench easier to use and make you more productive.

A free trial download of this latest version is available at www.dbwrench.com.

Thank you for your continued support of our product!

Launch of the Israel PostgreSQL Community Website

Noticias PostgreSQL [ENG] - Lun, 21/11/2016 - 01:00

We are pleased to announce the launch of The Israel PostgreSQL Community website.

Our goal is to promote PostgreSQL knowledge and usage in Israel by collaboration of all interested in it users.

The site will publish PostgreSQL global and regional community news and events.

We will promote PostgreSQL usage among students and pupils by providing lectures in colleges and high schools. We'll be glad for any help from the community for any relevant presentation content that can be useful for those populations.

There is a forum with variety of topics and blog section with relevant posts.

We are going to organize PGDAY at the beginning of the next year in Israel.

We are calling all PostgreSQL users in Israel to join effort and build strong and valuable community.

We initiated the process of product documentation translation. This is the time consuming process and we'll be glad if other users will be able to help us.

Please visit us at http://postgresql.org.il/.

E-Maj 2.0.0 released

Noticias PostgreSQL [ENG] - Mar, 15/11/2016 - 01:00

I am proud to announce the 2.0.0 version of E-Maj.

E-Maj is a PostgreSQL extension which enables fine-grained write logging and time travel on subsets of the database.

This new version supports PostgreSQL 9.1+ versions. It is now installed as a native postgres extension. The new "E-Maj rollback consolidation" feature brings more flexibility while the use of event triggers brings more reliability. The E-Maj phpPgAdmin plugin has been improved as well to use these new features.

The core extension is available at pgxn.org or github.org. It includes a general presentation and a detailed documentation. The phpPgAdmin plugin is also available at github.org.

Have fun with E-Maj !

PGConf Silicon Valley

Eventos PostgreSQL [ENG] - Lun, 14/11/2016 - 01:00

PGConf Silicon Valley will include a day of optional tutorials on November 14th followed by two days of keynotes and breakout sessions on November 15 & 16th. Last year's conference hosted speakers from companies such as TripAdvisor, Square, Urban Airship, Heap, MixRank, AWS, Heroku, and Rackspace. Building on the popularity of PGConfSV 2015, we have extended this year's conference to include two full days of breakout sessions. Stay tuned for more information regarding the schedule.

For sponsorship opportunities, http://www.pgconfsv.com/sponsors

Register to attend, https://www.eventbrite.com/e/pgconf-silicon-valley-2016-tickets-24414801328

Amazon RDS now supports PostgreSQL 9.6.1

Noticias PostgreSQL [ENG] - Vie, 11/11/2016 - 01:00

Amazon RDS for PostgreSQL now supports the next major release of the PostgreSQL open source database, version 9.6.1. New features include parallel query, phrase search, and improvements to performance and usability. With this release, Amazon RDS for PostgreSQL also supports the bloom and pg_visibility extensions.

You can create a new Amazon RDS for PostgreSQL 9.6.1 database instance with just a few clicks from the AWS Management Console or you can upgrade an existing PostgreSQL 9.5 database instance using point-and-click upgrade. Upgrading from version 9.3 and 9.4 requires you to perform a point-and-click upgrade to the next major version, reaching version 9.5 before upgrading to 9.6.1. Each upgrade operation involves a short period of unavailability for your database instance. Learn more about upgrading your database instances from the Amazon RDS User Guide.

Visit the product page to learn more about Amazon RDS for PostgreSQL.

JDBC 1212 Released

Noticias PostgreSQL [ENG] - Jue, 03/11/2016 - 01:00

The JDBC group is pleased to announce the release.

Notable fixes

  • ? can now be used in non-prepared statements (fixed regression of 9.4.1210)

Thanks to all of the contributors

Distribuir contenido