Installing Ora2Pg and migration cost assessment
OVERVIEW To migrate the data from Oracle to Postgres, we using the utility Ora2Pg. Ora2Pg is a free tool used to migrate an Oracle or MySQL database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates. Ora2Pg can be used from reverse engineering ….Read more
PostgreSQL 10.1, 9.6.6, 9.5.10, 9.4.15, 9.3.20, and 9.2.24 released!
Corrective updates are available for all supported PostgreSQL branches: 10.1, 9.6.6, 9.5.10, 9.4.15, 9.3.20 and 9.2.24, which contain a batch of bug fixes, including fixes for problems that could lead to data corruption. The release of updates for the 9.3 branch will last until September 2018, 9.4 until December 2019, 9.5 until January 2021, 9.6 ….Read more
PostgreSQL and Collation. What changed in PostgreSQL 10.
Introduction Not so long ago, one of our customers turned to us with problem. The fact is that PostgreSQL refused to use the index on the text field if you try to make a selection using regular expressions (LIKE/ILIKE and POSIX). Our colleagues wondered why Postgres does not use the index, because the database used the ….Read more
The first PostGIS Meetup in Israel
About PostGIS PostGIS is an extension to Postgresql that implements the OpenGis standard. PostGIS follows the Simple Features for SQL specification from the Open Geospatial Consortium (OGC). This extension contains extensive functionality for working with spatial data. This allows you to write interesting an useful applications. In particular, OpenStreetMap uses PostGIS to display its maps. It is also widely used in ….Read more
What’s new in PostgreSQL 10? Part 5 – Authentication and Row Level Security
Introduction Historically, PostgreSQL used a single encryption method. It’s not-so-safe md5 algorithm. In 10 version provided support for new authentication method SCRAM-SHA-256 for password negotiation and storage. Also in 9.6 or earlier version of PostgreSQL when multiple policies were set for a table, policies were determined by OR condition. Now can using the AND condition. ….Read more