MicrOLAP Database Designer for PostgreSQL v1.10.0 is out!

PgMDD boxDatabase Designer for PostgreSQL is an comprehensive CASE tool which works natively under Windows OS family and Linux under Wine/WineHQ 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 the server,
  • export diagram to the common graphic formats or as SQL script,
  • create detailed printings and reports.

Improved and enhanced long awaited release is available. It introduces support for the latest v9.4 SQL grammar as well as improved support for inheritance functionality. Modify Engine allows mark constraints as NOT VALID. Several non critical bugs fixed.

You’re welcome to download the Database Designer for PostgreSQL 1.10.0 right now at:

Full changelog:
[!] SQL Executor and Validator support v9.4 grammar now
[!] Support for table inheritance improved dramatically
[+] “Always make PK columns first” option introduced in Diagram Options
[+] Allow CHECK constraints to be declared NOT VALID in Modify script
[+] Allow FOREIGN KEY constraints to be declared NOT VALID in Modify script
[+] Shortcut for “Save As..” and “Export” menu items added
[+] SQL keywords are properly highlighted according to 9.4 version
[*] Comments now shown at Preview tab of Table Editor by default
[*] Handling of incorrect file paths improved in Generate and Modify Database
[*] Merging of reversed user types with existing in model improved during Reverse Engineering
[-] “Changing domain schema doesn’t affect table representation where domain used” bug fixed
[-] “Changing some options in the Model Options doesn’t activate OK & Apply buttons” bug fixed
[-] “Column default values containing backslashes are corrupted after reloading model” bug fixed
[-] “Leak proof option doesn’t shown in the Function editor after reopen” bug fixed
[-] “LEAKPROOF attribute causes syntax error in the SQL Executor” bug fixed

Please don’t hesitate to ask any questions or report bugs with our Support Ticketing system available at

Tagged with: , , , ,
Posted in Announces

Get PostgreSQL sources using SVN

As you probably know PostgreSQL sources are managed by Git version control system. Which is great, but for me as SVN user it would be much better to get access to the sources using familiar tools, e.g. TortoiseSVN. Mainly because I don’t need write access, read mode only. There is a workaround for such guys.

First of all, there is a mirror of PostgreSQL sources on the GitHub. And the second, GitHub supports SVN protocol using the bridge to communicate svn commands to GitHub.

So in my case I need only trunk with the latest commits. I’ve created an empty folder and made Checkout to the https://github.com/postgres/postgres/trunk URL.Image

Tagged with: , , , ,
Posted in Coding, PostgreSQL

PostgresDAC 2.12.0 meets RAD Studio XE6!

PostgresDAC v2.12.0 with support for Delphi XE6 and C++ Builder XE6 is available immediately!

Full change log:
[!] Support for Delphi XE6 and C++ Builder XE6 introduced
[!] TPSQLDump allows non-Latin characters in output file names
[*] “W1000 Symbol ‘DefaultFields’ is deprecated'” warning eliminated
[*] “W1030 Invalid compiler directive: ‘True'” warning eliminated

You’re welcome to download the PostgresDAC v2.12.0 right now at:
or login to your private area on our site at

Tagged with: , , , , ,
Posted in Announces

PostgresDAC 2.11.1 is immediately available

The MicroOLAP team is proud to announce the release of PostgresDAC v2.11.1 which resolves significant bugs and introduces new TPSQLCopy functionality.

If you are currently using PostgresDAC v2.11.0 in production, we recommend that you apply this update immediately. For other versions of the 2.x branches, applying the update is recommended at the next convenient opportunity.

PostgresDAC v2.11.1 is mostly maintenance release. Most notably this release fixes errors with TPSQLDump and TPSQLRestore components.

Full change log:
[+] TPSQLCopy.LoadFromProgram method added
[+] TPSQLCopy.SaveToProgram method added
[-] “ftMemo values with one byte client_encoding (not UTF8) are broken” bug fixed
[-] Bug with dump causing by environment settings is fixed

You’re welcome to download the PostgresDAC v2.11.1 right now at:
or login to your private area on our site at

Tagged with: , , , ,
Posted in Announces

2013 in review

The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.

Here’s an excerpt:

The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 14,000 times in 2013. If it were a concert at Sydney Opera House, it would take about 5 sold-out performances for that many people to see it.

Click here to see the complete report.

Posted in Announces

2013 Black Friday Sale Has Been Launched!

2013 Black Friday Sale Has Been Launched!

We, here in MicroOLAP, would like to wish a happy and awesome Thanksgiving day!

Special prices have been activated for all our products! Take advantage of MicroOLAP’s special “BlackFriday” discount for all licenses until December 3, 2013 and get 50% off!

Learn more >>

Tagged with:
Posted in General

Dump and restore of PostgreSQL: version compatibility FAQ

Compress PostgreSQLMany newbies are confused about how PostgreSQL dump and restore work. And even more questions appeared about version mismatches of the server itself and tools used. After fresh PostgresDAC release we’ve faced with the same questions.

Utilities used for dump and restore are called pg_dump and pg_restore respectively. Delphi developers may use TPSQLDump and TPSQLRestore components which are fully compatible with native tools.

So here I’m trying to create some kind of a FAQ.

Let’s assume version is a concatenation of Major, Minor and Build numbers separated by dots, e.g. 9.3.2

Q: Can I downgrade the database version, e.g. from 9.3 to 8.4?
A: If you mean official supported way of doing this, then no, you can’t. You may however use pg_dump in plain text output mode and manually fix all incompatibilities.

Q: Can I create dump of old server with new pg_dump?
A: Yes, sure. All versions since 7.0 are supported now. But if you use custom format, be ready the same or higher version of pg_restore will be needed.

Q: Can I create dump of new server with old pg_dump?
A: pg_dump must have the same major and minor version or higher, e.g. pg_dump v9.2.3 will work on v9.2.5, 9.2.x, 9.1.x, 8.x etc. and will not work for versions like 9.3.x, 9.4.x etc.

Q: What if I want to restore custom dump archive to the old server anyway?
A: You should use pg_restore to generate plain SQL script, manually edit it to fix version mismatches.

Q: Will pg_restore “understand” archives of newer versions of pg_dump?
A: No. The rule is simple: pg_restore will work with pg_dump output of the same major and minor version or lower, e.g. pg_restore v9.3.x will understand pg_dump output v9.3.x, 9.2.x, 9.1.x, 8.x etc. and will not work with output from versions like 9.4.x.

Q: Can I use new output format of the pg_dump with old server version, e.g. directory output for 8.4 server?
A: Yes, you can.

Q: Can I use new parallel functionality with old servers?
A: Yes, you can, but there is a limitation for pre-9.2 servers. See description for –no-synchronized-snapshots parameter.

PS All these statements are correct for the PostgresDAC’s TPSQLDump and TPSQLRestore components.

Tagged with: , , ,
Posted in PostgresDAC, PostgreSQL
Map of wandering

Get every new post delivered to your Inbox.

Join 78 other followers