Jelenlegi hely

PostreSQL.org

Feliratkozás PostreSQL.org hírcsatorna csatornájára
PostgreSQL news
Frissítve: 12 óra 39 perc

Call for Papers and Call for Workshops - PGDay.IT 2018 - June 29h, Garda Lake, Italy

2018, január 22 - 01:00

PGDay.IT 2018 will be held on June 29h, in Lazise, Italy, and we are now accepting proposals for talks and workshops.

We are full of enthusiasm because the last edition has been fantastic! Almost 200 enthusiastic attendees, interesting talks, great speakers, fantastic partners and a beautiful location. Attendees’ feedbacks have been incredible!

We couldn’t have asked for a better outcome. Thanks to everybody: attendees, speakers, staff, partners and we hope to meet you again during this new edition of PGDay.IT

PGDay.IT 2018 will be held in Lazise on Lake Garda on June 29th, 2018.

The location chosen is Hotel Parchi del Garda. It is located between the towns of Peschiera del Garda and Lazise, just 900 metres away from the lake’s shore.

Our advice for you: take your time, keep the weekend to discover Lake Garda.

For those who are worried about how to reach the location: “PG_shuttle" solves this matter!

We have organised a free pick up at Verona airport, Verona train station and Bergamo airport. Just fill the form to book your “PG_shuttle”.

How is the conference structured?

A keynote, eight talks in Italian, eight talks in English and the lightning talks at the end of the day.

The Call for Paper is open and there is something new: workshops on June 28th! Four hours dedicated to specific topics chosen among the proposals that we will receive. The Call for workshops is open!

English talks proposal and English workshops are welcome!

For any issue, please send an email with your questions or comments to pgday@itpug.org

Kategóriák: Informatika

Announcing The Release Of repmgr 4.0.2

2018, január 18 - 01:00

Oxford, United Kingdom - January 18, 2018

2ndQuadrant announces the release of repmgr 4.0.2. repmgr is the most popular tool for PostgreSQL replication and failover management. It enhances and complements PostgreSQL's built-in replication capabilities, making it easy to set up and manage standby servers, check replication status, and perform administrative tasks such as switchover operations. The repmgrd daemon provides automatic failover capability to maximize database uptime and can easily be integrated with other tools such as PgBouncer for high application availability.

repmgr 4.0.2 includes the following usability enhancements:

  • Recognize the -t/--terse option for repmgr cluster event to hide the Details column
  • Add "--wait-start" option for repmgr standby register
  • Add %p event notification parameter for repmgr standby switchover

This release contains the following bug fixes:

  • Add missing -W option to getopt_long() invocation
  • Automatically create slot name if missing
  • Fixes to parsing output of remote repmgr invocations
  • When registering BDR nodes, automatically create missing connection replication set
  • Handle missing node record in repmgr node rejoin

For a detailed list of all fixed bugs, please read the full release notes here.

We highly recommend upgrading to repmgr 4.0.2 at the earliest opportunity available. For this release, a simple package upgrade and restart of repmgrd (if running) is required.

Download is available here and installation instructions are available here.

repmgr is developed and maintained by 2ndQuadrant. It is fully supported by their respected 24/7 Production Support, providing the fastest and highest rated response service for PostgreSQL anywhere and is available worldwide. repmgr is distributed under GPL v3.

For more information, please send an email to info@2ndQuadrant.com

About 2ndQuadrant

2ndQuadrant is the Gold Standard for PostgreSQL Products & Services and consistently contributes enterprise features to enhance performance, scalability, security, and stability in PostgreSQL. Spanning 22 countries and 5 continents, 2ndQuadrant is the largest single collective organization of PostgreSQL experts. We have adopted the open source business model and are Major Sponsors for the PostgreSQL project. Our focus on service quality is reflected in the consistent best-in-class NPS of over 75 for more than 2 years.

Kategóriák: Informatika

pg_back 1.4 released

2018, január 18 - 01:00

pg_back is a simple (well kind of) bash shell script that can dump all your databases to files.

It can operate on standby servers and takes care of pausing and resuming WAL replay.

The 1.4 release brings support for PostgreSQL 10.

pg_back is licensed under the classic 2 clauses BSD license.

More at https://github.com/orgrim/pg_back

Kategóriák: Informatika

JDBC 42.2.0 Released

2018, január 18 - 01:00

The JDBC group is proud to release version 42.2.0

Notable changes include:

  • Support SCRAM-SHA-256 for PostgreSQL 10 in the JDBC 4.2 version (Java 8+) using the Ongres SCRAM library. PR 842
  • Make SELECT INTO and CREATE TABLE AS return row counts to the client in their command tags. Issue 958 PR 962
  • Support Subject Alternative Names for SSL connections. PR 952
  • Support isAutoIncrement metadata for PostgreSQL 10 IDENTITY column. PR 1004
  • Support for primitive arrays PR#887 3e0491a
  • Implement support for get/setNetworkTimeout() in connections. PR 849
  • Make GSS JAAS login optional, add an option "jaasLogin" PR 922 see [Connecting to the Database]{https://jdbc.postgresql.org/documentation/head/connect.html
Kategóriák: Informatika

Announcing the Release of OmniDB 2.4.1

2018, január 16 - 01:00

Oxford, United Kingdom — January 16, 2018

2ndQuadrant announces the release of OmniDB 2.4.1. OmniDB is a browser-based database management tool. It is designed to be a powerful, yet lightweight, user-friendly and fast-performing interface for PostgreSQL databases. OmniDB is fully backed by 2ndQuadrant’s world-renowned 24/7 Production Support.

The updates and improvements included in this release are:

  • Connections are now managed in the workspace, without losing existing work and focus
  • Autocomplete shortcut key is now Ctrl-Space by default
  • New improved Find & Replace for SQL Editor
  • OmniDB server now listens to the same port for HTTP(S) and WS(S), no need for opening two ports in firewall anymore

This release presents bug fixes including:

  • Improved autocomplete event handling
  • Data grid can now copy more than 1000 rows/cols
  • Improved performance for list sequence in tree view

For a complete list of changes, read the OmniDB change tracker here.

OmniDB 2.4.1 download is available here and installation instructions are available here.

For more information, please send an email to info@2ndQuadrant.com

About 2ndQuadrant

2ndQuadrant is the Gold Standard for PostgreSQL Products & Services and consistently contributes enterprise features to enhance performance, scalability, security, and stability in PostgreSQL. Spanning 22 countries and 5 continents, 2ndQuadrant is the largest single collective organization of PostgreSQL experts. We have adopted the open source business model and are Platinum sponsors for the PostgreSQL project. Our focus on service quality is reflected in the consistent best-in-class NPS of over 75 for more than 2 years.

Kategóriák: Informatika

Announcing the Release of pglogical 2.1.1

2018, január 11 - 01:00

Oxford, United Kingdom - January 11, 2018

2ndQuadrant announces the release of pglogical 2.1.1, the next generation in logical replication, for PostgreSQL. Implemented entirely as a PostgreSQL extension, pglogical is a logical replication system that serves as a highly efficient method of replicating data as an alternative to physical replication.

This is a minor release that addresses bugs including:

  • Fixed version detection for PostgreSQL 10.x releases
  • Fixed misreporting of conflicts on partial unique indexes
  • Fixed conflicts resulting from table synchronization. These could happen when synchronization worker has finished faster than main apply worker catches up with it.
  • Workaround for failure to clean spilled transactions in PostgreSQL
  • Log more context when reporting ERRORs
  • Log conflicting rows as part of conflict logging

pglogical is supported by 2ndQuadrant. 2ndQuadrant’s respected 24/7 Production Support provides the fastest and highest rated response service for PostgreSQL anywhere and is available worldwide.

Download and installation instructions are available here.

For more information, please send an email to info@2ndQuadrant.com

About 2ndQuadrant

2ndQuadrant is the Gold Standard for PostgreSQL Products & Services and consistently contributes enterprise features to enhance performance, scalability, security, and stability in PostgreSQL. Spanning 22 countries and 5 continents, 2ndQuadrant is the largest single collective organization of PostgreSQL experts. We have adopted the open source business model and are Platinum sponsors for the PostgreSQL project. Our focus on service quality is reflected in the consistent best-in-class NPS of over 75 for more than 2 years.

Kategóriák: Informatika

Pgpool-II 3.7.1, 3.6.8, 3.5.12, 3.4.15 and 3.3.19 are now officially released.

2018, január 9 - 01:00
What is Pgpool-II?

Pgpool-II is a tool to add useful features to PostgreSQL, including:

  • connection pooling
  • load balancing
  • automatic fail over and more.
Minor releases

Pgpool Global Development Group is pleased to announce the availability of following versions of Pgpool-II:

  • 3.7.1
  • 3.6.8
  • 3.5.12
  • 3.4.15
  • 3.3.19

These are the latest stable minor versions of each major versions of Pgpool-II. Release notes for versions prior 3.6 are no longer included in the source code.

Please take a look at release notes.

You can download the source code and RPMs.

Kategóriák: Informatika

Announcing @postgresql

2018, január 8 - 01:00

The PostgreSQL Global Development Group is pleased to announce the launch of the official community Twitter handle: https://twitter.com/postgresql

@postgresql will contain a mix of automatic and manually curated postings from a group of volunteers that feature various aspects of PostgreSQL and the community-at-large. Content will contain a mix of news, advice, and highlights around PostgreSQL, and enable the PostgreSQL Global Development Group to further engage with the community. If you would like for @postgresql to highlight PostgreSQL-oriented content, we encourage you to reach out to @postgresql via Twitter’s direct message feature.

The live feed for blog entries syndicated from Planet PostgreSQL will continue to be available at https://twitter.com/planetpostgres

We hope you will join us on Twitter.

Kategóriák: Informatika

Oldalak

Theme by me