Make Homepage | Add To Favorites | Print Page | Submit News | Feedback | Contact | 

Your Technical Computer Information Resource!  
     
  Server Applications Technical Updates [Page: 10 of 112] @ TACKtech Corp.  

10.16.2015 - Ora2Pg 16 released



View PostgreSQL-Press related news.

Paris, France - October 16th, 2015

Ora2Pg 16 released

Version 16.0 of Ora2Pg, a free and reliable tool used to migrate an Oracle database to PostgreSQL, has been officially released and is publicly available for download.

This major release improve PL/SQL code replacement, fixes several bugs and adds some major new features:

  • Full migration of MySQL database, it just work like with Oracle database.
  • Full migration assessment report for MySQL database.
  • New script, ora2pg_scanner, to perform a migration assessment of all Oracle and MySQL instances on a network.
  • Add technical difficulty level in migration assessment.
  • Allow migration assessment on client queries extracted from AUDIT_TRAIL (oracle) or general_log table (mysql).
  • Ora2Pg has a "made in one night" brand new Web site (still need some work) http://ora2pg.darold.net/

Example of technical difficulty level assessment output using the sakila database with some more difficulties:

Total 83.90 cost migration units means approximatively 1 man-day(s). Migration level: B-5

Here are the explanation of the migration level code:

Migration levels: A - Migration that might be run automatically B - Migration with code rewrite and a human-days cost up to 5 days C - Migration with code rewrite and a human-days cost above 5 days Technical levels: 1 = trivial: no stored functions and no triggers 2 = easy: no stored functions but with triggers, no manual rewriting 3 = simple: stored functions and/or triggers, no manual rewriting 4 = manual: no stored functions but with triggers or views with code rewriting 5 = difficult: stored functions and/or triggers with code rewriting

This is to help you to find the database that can be migrated first with small efforts (A and B) and those who need to conduct a full migration project (C).

This release has also some new useful features:

  • Export type SHOW_TABLE now shows additional information about table type (FOREIGN, EXTERNAL or PARTITIONED with the number of partition).
  • Connection's user and password can be passed through environment variables ORA2PG_USER and ORA2PG_PASSWD to avoid setting them at ora2pg command line.
  • Improve PL/SQL replacement on ADD_MONTH(), ADD_YEAR(), TRUNC(), INSTR() and remove the replacement limitation on DECODE().
  • Add detection of migration difficulties in views, was previously reserved to functions, procedures, packages and triggers.
  • Replace values in auto generated configuration file from command line options -s, -n, -u and -p when --init_project is used.
  • Adjust lot of scores following new functionalities in Ora2Pg, ex: autonomous transactions, dblink or synomyms are now more easy to migrate.

There is some new command line options to ora2pg script:

  • -m | --mysql : to be used with --init_project and -i option to inform ora2pg that we work with a MySQL format
  • -T | --temp_dir : option to be able to set a distinct temporary directory to run ora2pg in parallel.
  • --audit_user : option to set the user used in audit filter and enable migration assessment report on queries from AUDIT_TRAIL (oracle) or general_log table (mysql).
  • --dump_as_sheet and --print_header options to be able to compute a CSV file with all migration assessment from a list of oracle database.
  • --dump_as_csv option to report assessments into a csv file. It will not include comments or details, just objects names, numbers and cost.

Some change can break backward compatibility:

  • Change NULL_EQUAL_EMPTY to be disabled by default to force change in the application instead of transforming the PL/SQL.

This release adds some new configuration directives:

  • MYSQL_PIPES_AS_CONCAT: Enable it if double pipe and double ampersand (|| and &&) should not be taken as equivalent to OR and AND.
  • MYSQL_INTERNAL_EXTRACT_FORMAT: Enable it if you want EXTRACT() replacement to use the internal format returned as an integer.
  • AUDIT_USER: Set the comma separated list of user name that must be used to filter from the DBA_AUDIT_TRAIL or general_log tables.
  • REPLACE_ZERO_DATE: the "zero" date: 0000-00-00 00:00:00 is replaced by a NULL by default, use it to use the date of your choice. Useful when you have a NOT NULL constraint.
  • INDEXES_RENAMING: force renaming of all indexes using a name with tablename_columnsnames. Useful for database that have multiple time the same index name or that use the same name than a table.
  • HUMAN_DAYS_LIMIT: default to 5 days, used to set the number of human-days limit for migration of type C.

As usual there is also some bug fixes and Oracle to PostgreSQl conversion adjustments, for a complete list see the changelog.

Links & Credits

Thanks to all contributors, they are all cited in the changelog file.

Useful Links:


About Ora2Pg

Ora2Pg is an easy and reliable tool to migrate from Oracle to PostgreSQL. It is developed since 2001 and can export most of the Oracle objects (table, view, materialized view, tablespace, sequence, indexes, trigger, grant, function, procedure, package, partition, data, blob, external table, etc.).

Ora2Pg works on any platform and is available under the GPL v3 licence.

Docs, Download & Support at ora2pg.darold.net.


Full View / NID: 56449 / Submitted by: The Zilla of Zuron

10.13.2015 - 2UDA Beta (1) Released



View PostgreSQL-Press related news.

2ndQuadrant Unified Data Analytics (2UDA) is a data analytics application suite that unifies databases, spreadsheets, data mining and visualisation in one seamless desktop installer.

This latest release brings a number of enhancements based on the valuable feedback we have had from users who have downloaded a copy of the previous Alpha releases.

2UDA is a great example of the benefits derived from the 'tablesample' feature of PostgreSQL 9.5, demonstrating how large data samples can be quickly analysed through visualization.

Try the Beta version of 2UDA for yourself at http://2ndquadrant.com/2uda

Full View / NID: 56387 / Submitted by: The Zilla of Zuron

10.13.2015 - Database Designer for PostgreSQL 1.10.6 available



View PostgreSQL-Press related news.

The MicroOLAP team is proud to introduce Database Designer for PostgreSQL with enhanced support for Windows 10 and optional anonymous statistics functionality, an comprehensive CASE tool with intuitive graphical interface allowing you to

  • build a clear and effective database structure visually,
  • see the complete picture (diagram) representing all the tables, references between them, views, stored procedures and other objects,
  • easily generate a physical database on a server,
  • modify it according to any changes you made to the diagram using fast ALTER statements,
  • import already existing diagram from a server,
  • export diagram to common graphic formats or as SQL script,
  • create detailed printings and reports.

New release introduces enhanced support for Windows 10 and optional anonymous statistics functionality.

Download

You're welcome to download the Database Designer for PostgreSQL 1.10.6 right now at: http://microolap.com/products/database/postgresql-designer/download/

Feedback

Please don't hesitate to ask any questions or report bugs with our Support Ticketing system available at http://www.microolap.com/support/

Full changelog:

  • [!] Anonymous statistics module added (optional)
  • [!] Enhanced Windows 10 support by new compiler introduced
  • [*] Performance optimizations in error logging
  • [-] "EAccessViolation (Bug B21C0000) after reference deletion" bug fixed
  • [-] "Range check error in processes information for x64 machines" bug fixed
Full View / NID: 56386 / Submitted by: The Zilla of Zuron

10.12.2015 - New version of Oracle-to-PostgreSQL converter has been released



View PostgreSQL-Press related news.

Intelligent Converters has released a new version of Oracle-to-PostgreSQL converter with the following improvements:

  • Oracle 12c support
  • option to write into log file
  • improved synchronization

Visit the product page to learn more about the new version of Oracle-to-PostgreSQL: http://www.convert-in.com/ora2pgs.htm

Full View / NID: 56388 / Submitted by: The Zilla of Zuron

10.09.2015 - PostgreSQL RESTful API



View PostgreSQL-Press related news.

PSQL-API

Offers RESTful API access and API administration tools for the Postgres database server. Integrates all needed for fastest start. A WEB interface is used for administration. The API interface is created for HTTP applications (WEB, mobile, IoT and others) and allows CRUD operations and specified queries using secured communications (HTTPS, CORS, JWT/custom authorization rules).

Developed by Q-Bis Consult and partners, the project is open source MIT licensed.

https://github.com/QBisConsult/psql-api https://www.npmjs.com/package/psql-api

Full View / NID: 56366 / Submitted by: The Zilla of Zuron

10.08.2015 - 2015-10-08 Security Update Release



View PostgreSQL-Press related news.

The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.4.5, 9.3.10, 9.2.14, 9.1.19 and 9.0.23. This release fixes two security issues, as well as several bugs found over the last four months. Users vulnerable to the security issues should update their installations immediately; other users should update at the next scheduled downtime. This is also the final update release for major version 9.0.

Security Fixes

Two security issues have been fixed in this release which affect users of specific PostgreSQL features:

CVE-2015-5289: json or jsonb input values constructed from arbitrary user input can crash the PostgreSQL server and cause a denial of service.

CVE-2015-5288: The crypt() function included with the optional pgCrypto extension could be exploited to read a few additional bytes of memory. No working exploit for this issue has been developed.

The PostgreSQL project thanks Josh Kupershmidt and Oskari Saarenmaa for reporting these issues.

This update will also disable SSL renegotiation by default; previously, it was enabled by default. SSL renegotiation will be removed entirely in PostgreSQL versions 9.5 and later.

Other Fixes and Improvements

In addition to the above, many other issues were patched in this release based on bugs reported by our users over the last few months. These fixes include:

  • Prevent deeply nested regex, LIKE and SIMILAR matching from crashing the server
  • Multiple other fixes with regular expression handling
  • Ensure that ALTER TABLE sets all locks for CONSTRAINT modifications
  • Fix subtransaction cleanup when a cursor fails, preventing a crash
  • Prevent deadlock during WAL insertion when commit_delay is set
  • Fix locking during updating of updatable views
  • Prevent corruption of relation cache "init file"
  • Improve performance of large SPI query results
  • Improve LISTEN startup time
  • Disable SSL renegotiation by default
  • Lower minimum for *_freeze_max_age parameters
  • Limit the maximum for wal_buffers to 2GB
  • Guard against potential stack overflows in several areas
  • Fix handling of DOW and DOY in datetime input
  • Allow regular expression queries to be canceled sooner
  • Fix assorted planner bugs
  • Fix several shutdown issues in the postmaster
  • Make anti-wraparound autovacuuming more robust
  • Fix minor issues with GIN and SP-GiST indexes.
  • Fix several issues with PL/Python, PL/Perl and PL/Tcl
  • Improve pg_stat_statements' garbage collection
  • Improve collation handling in pgsql_fdw
  • Improve libpq's handling of out-of-memory conditions
  • Prevent psql crash when there is no current connection
  • Multiple fixes to pg_dump, including file and object permissions
  • Improve handling of privileges when dumping from old PostgreSQL versions
  • Fix issues with support of Alpha, PPC, AIX and Solaris platforms
  • Fix startup issue on Windows with Chinese locale
  • Fix Windows install.bat script to handle spaces in filenames
  • Make the numeric PostgreSQL version number available to extensions

This update also contains tzdata release 2015g, with updates for Cayman Islands, Fiji, Moldova, Morocco, Norfolk Island, North Korea, Turkey, Uruguay, and the new zone America/Fort_Nelson.

Final Update for 9.0

9.0.23 is the final update for major version 9.0, which is now End-Of-Life (EOL) as scheduled. Future security updates will not include version 9.0. As such, users of that version should plan to upgrade to another major version as soon as possible. For more information about the community's support policy and EOL schedule, see the Versioning Policy.

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 shut down PostgreSQL and update its binaries. Users who have skipped multiple update releases may need to perform additional post-update steps; see the Release Notes for details.

Links

Full View / NID: 56329 / Submitted by: The Zilla of Zuron

10.08.2015 - PostgreSQL 9.5 Beta 1 Released



View PostgreSQL-Press related news.

The PostgreSQL Global Development Group announces today that the first beta release of PostgreSQL 9.5 is available for download. This release should contain all features and APIs which will be in the final release with few, if any, changes. Users should begin testing their applications against 9.5 Beta 1 in preparation for the final release.

Changes Since Alpha2

Many bugs and issues reported by our users and contributors have been fixed since the release of Alpha2. These include:

  • significant adjustments to Row Level Security (RLS) semantics
  • deadlock with LWLock improvements
  • index corruption issue with BRIN indexes
  • couldn't connect using PGSSLMODE=require on Windows
  • various problems with commit timestamp tracking
  • hash join memory leak
  • inconsistent behavior of jsonb_set with array append

In particular, the semantics of Row Level Security have been changed to be consistent with the existing PostgreSQL GRANT-based permissions system. As an example, RLS now applies both the INSERT policies and the SELECT policies when INSERT with RETURNING is used. Users should test the RLS application of RLS policies and re-test any existing RLS configuration to ensure that there are no regressions for their use-cases. For more information, see the documentation on Create Policy and RLS.

If you reported an issue while testing PostgreSQL 9.5, please download Beta1 and test whether that issue has been fixed. If you have not yet tested version 9.5, now is the time for you to help out PostgreSQL development. Known issues which are still open are listed on the Open Items page.

Beta Schedule

This is first beta release of version 9.5, indicating that very few user-visible feature changes are expected before final release. The PostgreSQL Project will release additional betas as required for testing, followed by one or more release candidates, until the final release in late 2015. For more information, and suggestions on how to test the betas, see the Beta Testing page.

Full documentation and release notes of the new version is available online and also installs with PostgreSQL. Also see the What's New page for details on some features.

Links

Full View / NID: 56328 / Submitted by: The Zilla of Zuron

10.01.2015 - PHP 5.5.30 is available



View PHP related news. The PHP development team announces the immediate availability of PHP 5.5.30. This is a security release. Two security bugs were fixed in this release. All PHP 5.5 users are encouraged to upgrade to this version. For source downloads of PHP 5.5.30 please visit our downloads page, Windows binaries can be found on windows.php.net/download/. The list of changes is recorded in the ChangeLog.
Full View / NID: 56229 / Submitted by: The Zilla of Zuron

10.01.2015 - PHP 5.6.14 is available



View PHP related news. The PHP development team announces the immediate availability of PHP 5.6.14. This is a security release. Two security bugs were fixed in this release. All PHP 5.6 users are encouraged to upgrade to this version. For source downloads of PHP 5.6.14 please visit our downloads page, Windows binaries can be found on windows.php.net/download/. The list of changes is recorded in the ChangeLog.
Full View / NID: 56228 / Submitted by: The Zilla of Zuron

09.28.2015 - Barman 1.5.0 released



View PostgreSQL-Press related news.

2ndQuadrant is proud to announce the release of version 1.5.0 of Barman, Backup and Recovery Manager for PostgreSQL.

This major release features the get-wal command, which turns Barman into a WAL mine from which you can extract any transaction log file you need. Barman can now be easily integrated with any PostgreSQL standby server as a fallback method for WAL synchronisation.

Another important new feature is retry hook scripts that can be executed before or after a backup command or the archive of a WAL file. Differently from a standard hook script, already available in Barman, a retry hook script is executed indefinitely until it succeeds.

With version 1.5.0, Barman enhances its robustness, by adding checks on "wal_level" settings, by forbidding the deletion of a running backup, by requesting a successful "check" before initiating a backup, etc.

Barman now checks for conflicting paths, making sure that the same directory cannot be shared by more than a target (i.e. base backups, WAL archive, incoming directory, etc.), even across different servers within the same installation.

In terms of user experience, the "active" option grants users to temporarily disable a server in Barman, for operational purposes, while still accessing its catalogue.

Minor bugs have also been fixed.

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

Features in detail

Barman get-wal : No more standby servers that fall out of synchronisation with the master server, thanks to Barman's "get-wal" command. Design complex HA and DR architectures of PostgreSQL databases, knowing that you can now rely on an 'infinite' source of WAL files for any of your servers. Look at the "barman-wal-restore" script for an idea on how you can integrate "get-wal" with your PostgreSQL standby servers.

Retry hook scripts : You can now extend Barman by plugging your custom scripts before and after taking a backup operation or archiving a WAL file, knowing that Barman will repeat them until they succeed. You can now build your own pipeline around Barman, for example by storing a WAL in the cloud once it reaches Barman.

Links

Release notes

  • Add support for the "get-wal" command which allows users to fetch any WAL file from the archive of a specific server
  • Add support for retry hook scripts, a special kind of hook scripts that Barman tries to run until they succeed
  • Add "active" configuration option for a server to temporarily disable the server by setting it to "False"
  • Add "barman_lock_directory" global option to change the location of lock files (by default: 'barman_home')
  • Execute the full suite of checks before starting a backup, and skip it in case one or more checks fail
  • Forbid to delete a running backup
  • Analyse include directives of a PostgreSQL server during "backup" and "recover" operations
  • Add check for conflicting paths in the configuration of Barman, both intra (by temporarily disabling a server) and inter-server (by refusing any command, to any server).
  • Add check for "wal_level"
  • Add "barman-wal-restore" script to be used as "restore_command" on a standby server, in conjunction with "barman get-wal"
  • Implement a standard and consistent policy for error management
  • Improved cache management of backups
  • Improved management of configuration in unit tests
  • Tutorial and man page sources have been converted to Markdown format
  • Add code documentation through Sphinx
  • Complete refactor of the code responsible for managing the "backup" and the "recover" commands
  • Changed internal directory structure of a backup
  • Introduce "copy_method" option (currently fixed to "rsync")
  • Bug fixes:
    • Manage options without '=' in PostgreSQL configuration files
    • Preserve Timeline history files (Fixes: #70)
    • Workaround for rsync on SUSE Linux (Closes: #13 and #26)
    • Disables dangerous settings in postgresql.auto.conf (Closes: #68)
    • Fixed error in WAL rate calculation

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 and help DBAs during the recovery phase. Barman's most requested features include backup catalogues, incremental backup, retention policies, remote backup and recovery, archiving and compression of WAL files and backups. Barman is distributed under GNU GPL 3.

Full View / NID: 56136 / Submitted by: The Zilla of Zuron

09.24.2015 - JDBC 1203 released



View PostgreSQL-Press related news.

This release is primarily a bug fix for 1202 which focussed on performance and optimization. One notable feature was the addition of statement caching! The full changelog can be found here: https://jdbc.postgresql.org/documentation/changelog.html

For more information please visit: https://jdbc.postgresql.org/index.html

Full View / NID: 56137 / Submitted by: The Zilla of Zuron

09.22.2015 - PostgresDAC meets RAD Studio 10 Seattle!



View PostgreSQL-Press related news.

PostgresDAC v3.0.3 with support for Delphi and C++ Builder 10 Seattle is available immediately!

Download

You're welcome to download the PostgresDAC v3.0.3 right now at: http://microolap.com/products/connectivity/postgresdac/download/ or login to your private area on our site at http://microolap.com/my/downloads/

Feedback

Please don't hesitate to ask any questions or report bugs with our Support Ticketing system available at http://www.microolap.com/support/

Full View / NID: 56045 / Submitted by: The Zilla of Zuron

09.21.2015 - AWStats Logfile Analyzer Log Analyzer 7.4 is available



View AWStats related news. AWStats is a free powerful and featureful tool that generates advanced web, ftp or mail server statistics, graphically. This log analyzer works as a CGI or from command line and shows you all possible information your log contains, in few graphical web pages. It uses a partial information file to be able to process large log files, often and quickly. It can analyze log files from IIS (W3C log format), Apache log files (NCSA combined/XLF/ELF log format or common/CLF log format), WebStar and most of all web, proxy, wap, streaming servers, mail servers (and some ftp).
Full View / NID: 56032 / Submitted by: The Zilla of Zuron

09.04.2015 - PHP 5.6.13 is available



View PHP related news. The PHP development team announces the immediate availability of PHP 5.6.13. 11 security-related issues were fixed in this release. All PHP 5.6 users are encouraged to upgrade to this version. For source downloads of PHP 5.6.13 please visit our downloads page, Windows binaries can be found on windows.php.net/download/. The list of changes is recorded in the ChangeLog.
Full View / NID: 55822 / Submitted by: The Zilla of Zuron

09.04.2015 - PHP 5.5.29 is available



View PHP related news. The PHP development team announces the immediate availability of PHP 5.5.29. This is a security release. Many security-related issues were fixed in this release. All PHP 5.5 users are encouraged to upgrade to this version. For source downloads of PHP 5.5.29 please visit our downloads page, Windows binaries can be found on windows.php.net/download/. The list of changes is recorded in the ChangeLog.
Full View / NID: 55821 / Submitted by: The Zilla of Zuron

09.04.2015 - PHP 5.4.45 Released



View PHP related news. The PHP development team announces the immediate availability of PHP 5.4.45. Ten security-related issues were fixed in this release. All PHP 5.4 users are encouraged to upgrade to this version. For source downloads of PHP 5.4.45 please visit our downloads page, Windows binaries can be found on windows.php.net/download/. The list of changes is recorded in the ChangeLog. Please note that according to the PHP version support timelines, PHP 5.4.45 is the last scheduled release of PHP 5.4 branch. There may be additional release if we discover important security issues that warrant it, otherwise this release will be the final one in the PHP 5.4 branch. If your PHP installation is based on PHP 5.4, it may be a good time to start making the plans for the upgrade to PHP 5.5 or PHP 5.6.
Full View / NID: 55820 / Submitted by: The Zilla of Zuron

08.23.2015 - dbMigration .NET 1.0 released



View PostgreSQL-Press related news.

dbMigration .NET is a simple, easy and intuitive multiple database migration tool, With it you can easily migrate schema and data between different databases without complicated procedure. Supported databases: PostgreSQL, SQL Server, SQL Azure, LocalDB, MySQL, Oracle, IBM DB2, Informix, HP Vertica, NuoDB, Teradata, Sybase ASE, Firebird, SQLite, SQLCe, Access, dBase, FoxPro...etc.

Major features:

  • Automatic column matching
  • SQL preview
  • Filter source data
  • Show target results
  • Integrated with Database .NET
  • BLOB type support
  • Command-Line support

For more information please visit http://fishcodelib.com/DBMigration.htm

Full View / NID: 55653 / Submitted by: The Zilla of Zuron

08.20.2015 - SQL Relay 0.62 release announcement



View PostgreSQL-Press related news.

SQL Relay 0.62 is now generally available.

SQL Relay is a connection pool, load balancer, query router, and database proxy. It supports many databases, including PostgreSQL and provides API's for most popular programming languages and database abstraction layers.

Full View / NID: 55639 / Submitted by: The Zilla of Zuron

08.19.2015 - 2UDA Alpha 2 Release Available



View PostgreSQL-Press related news.

Enhanced alpha release of new data analytics application available.

2ndQuadrant is pleased to announce further enhancements to 2UDA (pronounced 'Tudor'), our new data analytics application suite currently under development, and available to try now.

This second alpha release brings a number of enhancements and product updates, based on user feedback and the continuous development of the core applications 2UDA unifies:

  • PostgreSQL server daemon is now an OS service (named "org.2ndQ.2UDA.postgres-9.5") on OS X
  • PostgreSQL server daemon is now an OS service (named "2uda-postgresql-9.5") on Linux (tested on Ubuntu 14.04, CentOS 7, openSUSE 13.2, & Fedora 22)
  • Windows installer is now certified from Microsoft and signed digitally
  • Latest PostgreSQL 9.5 after its Alpha 2 release has been included. Details of changes are listed
  • Latest Orange 3 has been included. This version uses the new tablesample patch in PostgreSQL rather than relying on blocksample extension.
  • Latest LibreOffice 5 has been included.
  • The installer now checks for server readiness before loading sample database. This prevents a bug where sample data got loaded while the server was still consolidating its connections.
  • Other small bugs and tweaks.

Download a copy now and let us know what you think: http://bit.ly/2UDA-A2

Full View / NID: 55650 / Submitted by: The Zilla of Zuron

08.17.2015 - CitusDB 4.1 Released



View PostgreSQL-Press related news.

CitusDB 4.1, which is based on the new PostgreSQL 9.4.4 release, is now GA. CitusDB is a scalable PostgreSQL database with massively parallel query processing for real-time Big Data applications. The 4.1 release is focused on improving usability and adding some of the most requested SQL features.

Full View / NID: 55573 / Submitted by: The Zilla of Zuron
  Most Viewed  
  Quick Links  
  Top Affiliates  
........