Jelenlegi hely

PostreSQL.org

Feliratkozás PostreSQL.org hírcsatorna csatornájára
PostgreSQL news
Frissítve: 3 nap 17 óra

Release of temboard v3.0

2019, március 20 - 01:00

Release of temboard 3.0, the powerful PostgreSQL management tool developed inside Dalibo Labs!

New feature: Maintenance

The maintenance plugin gives the users an overview on the databases, schemas, tables or indexes respective sizes. It is very useful to get information about bloat and toast. It helps users determine potential issues and understand or prevent performance issues due to unaccordingly used space. The plugin also provides easy access to maintenance actions such as VACUUM, ANALYZE or REINDEX in order to fix space or performance problems.

More about the maintenance plugin.

Enhancement of the interface

temboard’s interface is still improving. The 3.0 version lays out the instances as a grid on the homepage in order to better manage large database fleet. The sidebar is now collapsible to put forward the page's content. Moreover the homepage and the dashboard can be displayed in full screen mode which is more suitable when using a supervision screen.

And more...

Many other improvements and bug fixes are included, among which: * Limit double authentication to not read only APIs, * New monitoring probes: replication lag and connection, temporary files, * Show number of waiting/blocking req in activity tabs, * pg_hba.conf and pg_ident.conf edition removed from pgconf plugin.

More about this version's CHANGELOG.

An easier installation

Installing temboard and its agent is simpler thanks to its auto configuration script and clean documentation. The rpm and debian packages are available in the Dalibo Labs deposits.

Find out more information in the online documentation of temboard.

Video demo

You can find the demo for this new version of temboard on our Youtube page. Watch it by clicking here

Links

temboard is mainly developed by Julien Tachoires, Étienne Bersac and Pierre Giraud.

Kategóriák: Informatika

EMS SQL Backup for PostgreSQL released!

2019, március 19 - 01:00

EMS Software Development, one of the leaders in database administration software development, is pleased to announce the release of its new product SQL Backup for PostgreSQL for creating automatic backups for PostgreSQL databases. The tool offers easy and quick deployment of scheduled backup tasks on multiple servers and monitoring their execution.

SQL Backup for PostgreSQL can significantly improve the workflow of database administrators in both large and small companies. They get the reliable tool to create automated backup tasks. The single console for managing backups for all servers at hand can considerably reduce costs on server maintenance ”- said Vladimir Sokolov, CEO of EMS Software Development.

We have designed smart wizards to create scheduled backup tasks that can considerably save time on creating backups in large systems. SQL Backup for PostgreSQL can reduce storage costs due to direct uploading of backup files into popular cloud storages, such as Dropbox, Google Drive, Amazon S3 and others, Now we are focusing on adding new features and further development of the program “ - stated Ivan Proshechkin, technical director.

Regular execution of backup tasks with SQL Backup for PostgreSQL is a key for smooth and high-performance working of your PostgreSQL servers.

More information about SQL Backup for PostgreSQL.

Kategóriák: Informatika

Announcing the release of E-Maj 3.0.0

2019, március 18 - 01:00

We are very glad to announce the 3.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 version doesn't contain new big features. But:

  • As the project is now an official member of the DaliboLabs constellation, the development is now supported by Dalibo,
  • It is possible to install the PostgreSQL extension on PGaaS cloud environments where creating external EXTENSIONs is not allowed,
  • the Emaj_web client has been largely improved, with a new GUI (while the old phpPgAdmin plugin is not maintained anymore).

This new version supports from 9.5 to v11 PostgreSQL versions.

The full documentation is available on line. The core extension is available at pgxn.org or github.org.

The Emaj_web application is also available at github.org.

Have fun with E-Maj !

Kategóriák: Informatika

Call for Papers for Postgres Vision 2019 is Now Open

2019, március 14 - 01:00

The event will take place June 24-26 at the Sheraton Boston Hotel in Boston, MA, USA

Business leaders, database professionals, and developers are encouraged to submit individual presentations or panel discussions that highlight real-world enterprise-scale case studies, deep dives into Postgres tools and technologies, and explorations of the future of the database project.

The Call for Papers for Postgres Vision 2019 will end on Wednesday, April 10th.

Submit Your Paper Today at: http://go.enterprisedb.com/s0920nE00L2s0A000000i0B

Info and registration at: https://postgresvision.com/

Kategóriák: Informatika

PostgreSQL Participates in Google Summer of Code 2019!

2019, február 28 - 01:00

The PostgreSQL Project is excited to announce that we have been accepted by Google to participate in their Summer of Code (GSoC) 2019 educational sponsoring program. GSoC is a program in which Google awards stipends to university students who complete a free and open-source software project during the summer. This will be the 12th time that the PostgreSQL Project will provide mentoring to university students to help develop new features for The World's Most Advanced Open Source Relational Database and related projects. We have the chance to accept student projects that will be developed from May to August.

For more information about GSoC, please visit the GSoC website: https://summerofcode.withgoogle.com/

For more information about working with the PostgreSQL project as part of GSoC, please visit our GSoC website: https://wiki.postgresql.org/wiki/GSoC

Kategóriák: Informatika

Postgres-operator v1.1.0

2019, február 25 - 01:00

A new release is available for the Postgres Operator. The operator helps you to manage PostgreSQL HA clusters on Kubernetes. Notable changes among others are:

  • support for setting shmem for better parallel query support
  • support init containers
  • improved logging in rolling upgrade
  • added superuser team support (additional team to be created as superuser)
  • support setting additional replication slots via Patroni
  • fix issue surrounding delete cluster
  • fix reporting .status

Thanks to everyone involved, reporting bugs, suggesting enhancements and contributing to the operator!

Kategóriák: Informatika

dbMigration .NET v10.1 released

2019, február 22 - 01:00

dbMigration .NET v10.1 is a simple, easy and intuitive multiple database migration and sync tool, With it you can easily migrate schema and data to PostgreSQL and vice versa without complicated procedures. (Free, All-In-One, Portable, Single executable file and Multi-language)

Major New features and improvements from version 9.2 to 10.1:

  • PostgreSQL 11 support
  • Added Auto-generating COMMENTS of tables and columns
  • Added Auto-generating DEFAULT values of columns
  • Added Auto-generating CHECK constraints of tables
  • Added SSH: Secure Shell support
  • Improved Graphical User Interface
  • Improved Mapping column names from the target table
  • Improved Automatic Mapping Types
  • Improved Custom Mapping Types
  • Improved Command-Line
  • Improved Connection profile
  • Compatible with Microsoft Windows 10 Insider Preview 18305 and higher
  • ...and more

The new version is immediately available for download.

Kategóriák: Informatika

XlogMiner Enhancements Released and Renamed to WalMiner

2019, február 22 - 01:00

XlogMiner is a tool for parsing executed SQL statements from PostgreSQL's WAL and can generate corresponding undo SQL statements. The open source project address is https://github.com/HighgoSoftware/XLogMiner. This version has a large usage limit, you need to set the wal level to logical, and you need to set the table to IDENTITY FULL mode. This can exacerbate the bloat of wal and reduce database performance.

To cater to the changes in the PG log name, XlogMiner is now renamed to WalMiner. The new open source address is temporarily at https://gitee.com/movead/XLogMiner.

Release Enhancements

The analyse source of the old version of the tool xlogminer is the "change data" in current wal record. It does not get data from the page in FPW for parsing of wal records.

The new version of walminer can not only parse the FPW of the current wal record, but also record and redo all FPWs that appear during the parsing process. So walminer can resolve low-level wal and you don't need to set the table to IDENTITY FULL mode.

Additionally:

1.WalMiner supports parsing any wal log level above the minimum level.

2.No need to set the table to IDENTITY FULL mode.

3.Increase the resolution of the wal record modified by the system table.

4.Fix a bug that failed to parse in other databases after a relfilenode change occurred.

New restrictions brought by WalMiner

Walminer can fully parse out all wal records after the first checkpoint in the given wal. The delete and update records before the first checkpoint may fail to parse, as follows:

UPDATE "public"."t1" SET VALUES(NULL) (NOTICE:wal is not enought.);

If you need to resolve this record, you only need to add some earlier wal segment.

The specific usage is viewed in the README.EN.MD in the open source code.

limits
  1. This version only parses DML statements and does not process DDL statements. Future changes: The parsing of DDL statements has been put into the todolist, which may gradually support various DDL statements.
  2. The DML statemes would NOT be parsed out when the below DDL related operations were executed: Deleting/Truncating table, table space modification and column type modification etcs. Response: It is recommended to save a data dictionary to ensure that the history wal log can be parsed before performing the table structure change. Future changes: Now I have added the ability to save the data dictionary in walminer.
  3. The parsing result is depending on the latest database dictionary. For example, after user1 created table t1, the table owner was modified to user2, then all the parsing results related to table t1 will be marked with user2. Response: It is recommended to save a data dictionary to ensure that the history wal log can be parsed before performing the table structure change. Future changes: Now I have added the ability to save the data dictionary in walminer.
  4. The "ctid" attribute is the value of the change "at that time". If there are "ctid" changes due to vacuum or other operations, this value will be inaccurate. We need use this value to determine the corresponding undo tuples when the rows of data are duplicate, it does not mean that you can execute such undo statements directly.
  5. If the DDL statement "drop" was executed, all related column value will be decoded as "encode('AD976BC56F',hex)" before this DDL execution.
  6. Can only parse the wal file consistent with the data dictionary timeline
  7. WalMiner is an individual product and has not been fully tested.
contact me

If you find bugs or have good suggestions, you can contact me via email (lchch1990@sina.cn).

Kategóriák: Informatika

Pgpool-II 4.0.3, 3.7.8, 3.6.15, 3.5.19 and 3.4.22 are now officially released.

2019, február 21 - 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:

  • 4.0.3
  • 3.7.8
  • 3.6.15
  • 3.5.19
  • 3.4.22

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

PostgreSQL 11.2, 10.7, 9.6.12, 9.5.16, and 9.4.21 Released!

2019, február 14 - 01:00

The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 11.2, 10.7, 9.6.12, 9.5.16, and 9.4.21. This release changes the behavior in how PostgreSQL interfaces with fsync() and includes fixes for partitioning and over 70 other bugs that were reported over the past three months.

Users should plan to apply this update at the next scheduled downtime.

Highlight: Change in behavior with fsync()

When available in an operating system and enabled in the configuration file (which it is by default), PostgreSQL uses the kernel function fsync() to help ensure that data is written to a disk. In some operating systems that provide fsync(), when the kernel is unable to write out the data, it returns a failure and flushes the data that was supposed to be written from its data buffers.

This flushing operation has an unfortunate side-effect for PostgreSQL: if PostgreSQL tries again to write the data to disk by again calling fsync(), fsync() will report back that it succeeded, but the data that PostgreSQL believed to be saved to the disk would not actually be written. This presents a possible data corruption scenario.

This update modifies how PostgreSQL handles a fsync() failure: PostgreSQL will no longer retry calling fsync() but instead will panic. In this case, PostgreSQL can then replay the data from the write-ahead log (WAL) to help ensure the data is written. While this may appear to be a suboptimal solution, there are presently few alternatives and, based on reports, the problem case occurs extremely rarely.

A new server parameter data_sync_retry has been added to manage this behavior. If you are certain that your kernel does not discard dirty data buffers in such scenarios, you can set data_sync_retry to on to restore the old behavior.

Bug Fixes and Improvements

This update introduces a change into how release notes are packaged. As of this update, all currently supported versions of PostgreSQL will only contain their major version-specific release notes. For example, PostgreSQL 11 only packages the release notes for version 11.2, 11.1, and 11.0. The release notes for unsupported versions (PostgreSQL 9.3 and older) will be available in older releases and from a soon-to-be released archive on the PostgreSQL website.

This update also fixes over 70 bugs that were reported in the last several months. Some of these issues affect only version 11, but many affect all supported versions.

Some of these fixes include:

  • Fix handling of unique indexes with INCLUDE columns on partitioned tables
  • Ensure that NOT NULL constraints of a partitioned table are honored within its partitions
  • Several fixes for constraints on partitioned tables
  • Fix problems with applying ON COMMIT DROP and ON COMMIT DELETE ROWS to partitioned tables and tables with inheritance children
  • Disallow COPY FREEZE on partitioned tables
  • Several fixes for the ALTER TABLE .. ADD COLUMN with a non-nullable default feature, including a possible index corruption case
  • Several fixes in GIN indexes, including avoiding a deadlock with vacuuming and concurrent index insertions (which partially reverts a performance improvement introduced in PostgreSQL 10)
  • Fix possible crashes in logical replication when index expressions or predicates are in use
  • Several fixes for the write-ahead log (WAL)
  • Fix possible crash in UPDATE with a multiple SET clause using a sub-SELECT
  • Fix crash when zero rows are provided to json[b]_populate_recordset() or json[b]_to_recordset()
  • Several fixes related to collation handling, including the parsing of collation-sensitive expressions in the arguments of a CALL statement
  • Several fixes for the query planner, including an improvement to planning speed for large inheritance or partitioning table groups
  • Several fixes for TRUNCATE
  • Ensure ALTER TABLE ONLY ADD COLUMN IF NOT EXISTS is processed correctly
  • Allow UNLISTEN in hot-standby (replica) mode
  • Fix parsing of space-separated lists of host names in the ldapserver parameter of LDAP authentication entries in pg_hba.conf
  • Several fixes for ecpg
  • Several fixes for psql, including having \g target work with COPY TO STDOUT
  • The random number generation for pgbench is now fully deterministic and platform-independent when --random-seed=N is specified
  • Fix pg_basebackup and pg_verify_checksums to appropriately ignore temporary files
  • Several fixes for pg_dump, including having ALTER INDEX SET STATISTICS commands present
  • Prevent false index-corruption reports from contrib/amcheck caused by inline-compressed data
  • Support new Makefile variables to help with building extensions

This update also contains tzdata release 2018i for DST law changes in Kazakhstan, Metlakatla, and Sao Tome and Principe. Kazakhstan's Qyzylorda zone is split in two, creating a new zone Asia/Qostanay, as some areas did not change UTC offset. Historical corrections for Hong Kong and numerous Pacific islands.

Updating

All PostgreSQL update releases are cumulative. As with other minor releases, users are not required to dump and reload their database or use pg_upgrade in order to apply this update release; you may simply shutdown PostgreSQL and update its binaries.

Users who have skipped one or more update releases may need to run additional, post-update steps; please see the release notes for earlier versions for details.

PostgreSQL 9.4 will stop receiving fixes on February 13, 2020. Please see our versioning policy for more information.

Links
Kategóriák: Informatika

Barman v2.6 - Now with Support for Geo-redundancy

2019, február 4 - 01:00

Oxford, United Kingdom - February 4, 2019

2ndQuadrant today announced the release of Barman version 2.6. This release introduces support for geographical redundancy, allowing DBAs and System Administrators to add another tier to their disaster recovery solution for PostgreSQL databases.

Barman (Backup and Recovery Manager) is an open source administration tool for managing backup and disaster recovery of PostgreSQL servers. It allows you to perform remote backups of multiple servers in business-critical environments and helps DBAs during the recovery phase.

Barman v2.6 presents the following new features:

  • Add support for geographical redundancy. Geo-redundancy allows a Barman server to use another Barman server as a data source, instead of using a PostgreSQL server.

  • Add 'put-wal' command. This allows Barman to safely receive WAL files via PostgreSQL's 'archive_command' using the new 'barman-wal-archive' script included in the latest 'barman-cli' package.

  • Add ANSI colour support to 'check' command.

This release also includes minor bug fixes. A complete list of changes and bug fixes is available here.

Download and installation instructions are available here.

Source files are available for download here.

Barman is developed and maintained by 2ndQuadrant and distributed under GPL v3.

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

Kategóriák: Informatika

PostgreSQL Automatic Failover (PAF) v2.2.1 released

2019, január 31 - 01:00
Announce

PostgreSQL Automatic Failover (PAF) v2.2.1 has been released on January 31st 2019 under PostgreSQL licence.

PAF is a PostgreSQL resource agent for Pacemaker. Its original aim is to keep it clear between the Pacemaker administration and the PostgreSQL one, to keep things simple, documented and yet powerful.

Version 2.2.1 is a minor bugfix release, no new features. See changelog: https://github.com/ClusterLabs/PAF/releases/tag/v2.2.1

To download the sources, a RPM or a DEB package, see: https://github.com/ClusterLabs/PAF/releases/latest

Packages from PGDG or official distribution repositories will be updated.

Useful links

Source code and releases are available on github:

Documentation, procedures, community support as well:

Quick demo and test screencast: https://blog.ioguix.net/postgresql/2019/01/24/Build-a-PostreSQL-Automated-Failover-in-5-minutes.html

Please, use the pgsql-general@postgresql.org or users@clusterlabs.org mailing lists if you have questions.

Any feedback is welcomed.

Kategóriák: Informatika

Release: check_pgactivity 2.4

2019, január 30 - 01:00
check_pgactivity version 2.4 released

check_pgactivity is a PostgreSQL plugin for Nagios. This plugin is written with a focus on a rich perfdata set. Every new features of PostgreSQL can be easily monitored with check_pgactivity.

Changelog :

  • add a new uptime service
  • add ability to filter by application_name in longest_query and oldest_idlexact services
  • add minimal delta size to pgdump_backup service to avoid alert when backup grows small in size
  • allow psql connections without providing connection arguments: rely on the binary default behaviour and environment variables
  • returns CRITICAL if connection fails for service connection, instead of UNKNOWN
  • document minimal privileges for all services
  • replication_slots service handle wal files and pg_replslots files separately
  • take account of the new BRIN summarize state of autovacuum
  • ignore startup and backup replication states in service streaming_delta
  • many fixes

Here are some useful links:

Thanks to all the contributors!

Kategóriák: Informatika

PGConf APAC 2019 Schedule Announced

2019, január 29 - 01:00

The schedule for PGConf APAC 2019 has been announced. The conference is being hosted on March 19 - 21 in Singapore.

PGConf APAC is the PostgreSQL conference series for all PostgreSQL enthusiasts in the Asia Pacific region. Singapore is a global city and is very well connected via flights with major hubs across the globe. It has a unique cultural blend and population from different ethnicity and religions. The coexistence and sound infrastructure has provided the foundation for rapid growth of the country and its positioning as a trade, technological and financial hub.

These are the reasons why various PostgreSQL User Groups from Asia have come together to organize one of the largest PostgreSQL shows in Asia Pacific – PGConf APAC 2019, the first large-scale PostgreSQL conference for the Asia Pacific region.

The full schedule and details of the talks being presented is available on the PGConf APAC website.

In addition to the general conference, the first day (March 19) is dedicated to training on Performance Tuning and PostgreSQL Security. World-renowned PostgreSQL experts will go in-depth and get hands-on with today's most interesting PostgreSQL features and tools.

These training are being offered at a special discounted rate for the duration of Early Bird (until 19th Feb 2019), and a further discount can be obtained when purchasing a conference ticket and training course together.

Registration is open for the event and tickets can be purchased directly on the conference website for general admission and training courses.

For questions or more information please send an email to pgconfapac@googlegroups.com.

Kategóriák: Informatika

DB Doc 6.0 released

2019, január 24 - 01:00

Yohz Software has just released DB Doc 6.0, the PostgreSQL schema documentation tool, and is available for immediate download.

Changes in this version:
  • Added support for PostgreSQL 11.x databases.
  • Added option to generate schema information in XML format.
  • Added sample XSL style sheets to display the XML content.
DB Doc benefits:
  • Document a PostgreSQL database in 5 simple steps
  • Create documentation in HTML, XML, PDF, CHM, and MS Word formats. You can view the samples here.
  • Eliminate tedious and time-consuming manual documentation tasks
  • Satisfy audit requirements by keeping complete and timely documentation
  • 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 timely and accurate documentation
  • Runs on Windows XP to Windows 10
  • Runs on Linux using Wine, so you can use DB Doc on your favorite Linux distribution
  • Supports PostgreSQL 8.3 and newer, without the need for any additional database drivers.

For more details about DB Doc, please visit the product page. DB Doc-related technical blogs are available here.

Kategóriák: Informatika

Nordic PGDay 2019 - schedule announced and registration open

2019, január 10 - 01:00

Nordic PGDay 2019 will be held in Copenhagen, Denmark, on March 19, 2019, and is proud to be a PostgreSQL Community Recognised Conference. It will feature a full day with a single track of PostgreSQL presentations from both Nordic and global PostgreSQL experts, covering a wide range of topics.

We are now happy to announce our schedule.

Our registration has also been opened. Seats are limited so we recommend that you register early if you are interested! Early Bird discount is available until February 17th or for the first 40 tickets.

We look forward to seeing you in Copenhagen!

Kategóriák: Informatika

Announcing the release of AgensGraph 2.1

2019, január 7 - 01:00

The AgensGraph Development Team are pleased to announce the release of AgensGraph v2.1.

AgensGraph is a new generation multi-model graph database for PostgreSQL. AgensGraph offers the graph analysis environment for highly connected data in which users can write, edit, and execute SQL and Cypher query together at the same time. AgensGraph comes along with PostgreSQL compatibility and PostgreSQL Extensions. It is why AgensGraph can set PostgreSQL users free from the pains of data migration and enables easier development of graph-based applications than other graph databases.

AgensGraph v2.1 Community Edition is available under Apache 2.0 License, so please feel free to use and send us any inquiry/idea about our products to: agens@bitnine.net or our Github

For more details please see the release notes.

Major Improvements and Bug Fixes:
  • Performance Enhancement
  • Cypher
    • Enhance shortest-path algorithm and minor features
  • Cypher Implemention
  • Make all built-in functions usable
  • Support "IN" for sub-queries
  • Usability
  • Improve Graph meta
    • Add a GUC on graphmeta which decide it works automatically or not
    • Add a function regather_graphmeta() which reset and gather graphmeta
  • Add help command in agens shell
    • Change the implementation of constants
      • Handle UNKNOWNOID constants properly (::jsonb and ::text)
      • Handle parameters AS-IS
    • Implement type casting
      • Implement pre-evaluating CypherTypeCast
      • Implement auto type casting on function call
      • Implement auto type casting on operators
      • jsonb to graphid -> numeric to graphid
    • Update comment about token precedence in gram.y
  • Bug Fixes
  • Please see the release notes for fix details
The new version is immediately available for download.
Kategóriák: Informatika

Brand New Standard Edition of dbForge Studio for PostgreSQL by Devart

2018, december 13 - 01:00

Devart, a recognized vendor of professional database management software for developers and DBAs, announced the release of dbForge Studio for PostgreSQL, v2.0 with new exclusive features and a bunch of essential updates and improvements.

Standard Edition

Now dbForge Studio for PostgreSQL has two editions, a free Express edition with basic functionality and Standard editions with advanced features. The Standard edition can be evaluated at no cost for 30 days. When this trial period expires, users can purchase a license to continue enjoying exclusive features or it will be limited to a free Express edition.

The Standard edition includes the following exclusive features:

  • Data Import and Data Export
  • Master-Detail Browser
  • Data Reports
  • Pivot Table
  • SQL Snippets
  • Query Execution History
  • Execute Large Script
  • SQL Document
  • Context prompt in the FROM list of the SELECT queries
  • Full code completion support for the SELECT statement
  • Connectivity
  • SSH connection
  • Connectivity support for PostgreSQL 11.x
  • Connectivity support for PostgreSQL 10.x
  • Connectivity support for PostgreSQL 8.3, 8.2, 8.1
  • Connectivity support for elephantsql.com
  • Other Improvements
  • Digital signature for the installation file
  • FIPS compliance

dbForge Studio for PostgreSQL is a GUI tool for database development and management. The IDE for PostgreSQL allows users to create, develop, and execute queries, edit and adjust the code to specific requirements in a convenient and user-friendly interface.

For more information about dbForge Studio for PostgreSQL, please visit

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

Kategóriák: Informatika

Announcing the release of AgensGraph 2.0

2018, november 30 - 01:00

The AgensGraph Development Team are pleased to announce the release of AgensGraph v2.0.

AgensGraph is a new generation multi-model graph database for PostgreSQL. AgensGraph offers the graph analysis environment for highly connected data in which users can write, edit, and execute SQL and Cypher query together at the same time. AgensGraph comes along with PostgreSQL compatibility and PostgreSQL Extensions. It is why AgensGraph can set PostgreSQL users free from the pains of data migration and enables an easier development of graph-based applications than other graph databases.

This release of AgensGraph v2.0 includes many updates in PG compatibility, usability and performance with known bug fixes. For more details please see the release notes.

Major Improvements and Bug Fixes:
  • PostgreSQL Compatibility
  • Support PostgreSQL 10.4
  • Performance
  • Remove use of SPI in ModifyGraph
  • Cypher Implementation
  • Support STARTS WITH / ENDS WITH / CONTAINS clauses
  • Support PREPARE statement for Cypher
  • Usability
  • Support ‘=~’ operator for regex matching
  • Support ‘graphid’ comparisons ex) MATCH (n) WHERE id(n) = '1.1' AND id(n) = 1.1 RETURN n;
  • Support implicit conversion of any value to jsonb during LOAD ex) LOAD FROM external_table AS r CREATE (:v = r);
  • Support printing NULL values in _vertex, _edge, and graphpath
  • Validate AG_VERSION before init or start
  • Added installation step for RHEL
  • Addition of the metric catalog ag_graphmeta
  • Improved labels() on vertex
  • Support storing NULL properties
  • Support DROP VLABEL ... CASCADE
  • Bug Fixes
  • Bug fixes related to Cypher, graphpath, graph joins, etc. (Please see the release notes for fix details)
The new version is immediately available for download.
Kategóriák: Informatika

Theme by me