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 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

PostgresDAC v2.11.0 with comprehensive dump\restore functionality is out!

This release is fully dedicated to the dump and restore functionality. Libraries are rewritten from scratch for the latest 9.3 and 9.2 servers. Support for previous versions is discontinued. New modern thread friendly Directory output format introduced. New parallel dump mode implemented. A bunch of features added as well as all known bugs are fixed.

Full change log:
[!] v9.3.1 client libraries added (x86 and x64 platforms)
[!] v9.3.1 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
[!] TPQSQLDump supports Directory output format from now
[!] TPQSQLDump supports parallel processing
[+] v9.2.5 dump & restore libraries (pg_dump-9.2.5.dll, pg_restore-9.2.5.dll) added
[+] doNoSynchronizedSnapshots option added to TPSQLDump.Options
[+] roNoSecurityLabels option added to TPSQLRestore.Options
[+] TPSQLDump.ExcludeTablesData property added
[+] TPSQLDump.Jobs property added
[+] TPSQLDump.Sections property added
[+] TPSQLRestore.SchemaName property added
[+] TPSQLRestore.Sections property added
[+] TPSQLRestore.TableNames property added
[*] Make TPSQLDump put SEQUENCE SET items in the data not pre-data section of the archive
[*] Support for old dump and restore libraries is discontinued (v8.x, v9.1)
[*] tar files emitted by TPSQLDump are POSIX conformant now
[*] TPSQLDump excludes data of unlogged tables when running on a hot-standby server
[*] TPSQLDump outputs functions in a more predictable order
[*] TPSQLRestore now accepts POSIX-conformant tar files
[-] Fixed bugs in the restore.sql script emitted byTPSQLDump in tar output format
[-] Fixed TPSQLDump for views with circular dependencies and no relation options
[-] Fixed TPSQLDump’s handling of DROP DATABASE commands if doClean option specified

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

Tagged with: , , , , ,
Posted in Announces

MicroOLAP Database Designer for PostgreSQL 1.9.2 released

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.

This is mostly maintenance release fixing many bugs in several areas. Everybody should consider upgrading to this version as soon as possible.

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

Full changelog:
[+] Several models may be passed through command line for opening
[+] Support added for Element property of scalar types
[*] Added missing carriage return at the end of tables statements in the Modify Database script
[*] Error messages improved in the SQL Executor
[*] Find Objects result tree now contains proper images for objects found
[*] Object editor may be open pressing Enter in Find Objects dialog
[*] Opening SQL Executor will create empty model if needed
[*] Processing of tables improved in the Modify Database
[*] SQL parser improved to prevent out of range errors
[*] Statement Error dialog opens at the owner window center from now
[*] Subject corrected for exception tracer messages
[*] Tab order fixed in the Generate and Modify dialogs
[-] “ERangeError occurs when mouse selection area leaves model bounds” bug fixed
[-] “Generate and Modify dialogs: Columns Default Values option is enabled even if Create Table unchecked” bug fixed
[-] “Generate and Modify dialogs: Rules option is enabled even if Create View unchecked” bug fixed
[-] “Index out of bounds possible error prevented for views in Database Modify” subj fixed
[-] “Model file passed through command line (double clicked in Explorer) doesn’t open” bug fixed
[-] “Modify Database produce COMMENT statements even if option unchecked” bug fixed
[-] “Modify Database produce TRIGGER statements even if option unchecked” bug fixed
[-] “Range check error when generating SQL with scalars without in\out functions” 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

PostgresDAC v2.10.0 with RAD Studio XE5 and PostgreSQL 9.3 support is out!

PostgresDAC v2.10.0 with support for Delphi XE5, C++ Builder XE5 and PostgreSQL 9.3 available immediately!

Full change log:
[!] Delphi XE5 and C++ Builder XE5 support introduced
[!] PostgreSQL 9.3 support added
[!] OpenSSL 1.0.1e libraries added
[+] EPSQLDatabaseError.ErrorSchemaName property added
[+] EPSQLDatabaseError.ErrorTableName property added
[+] EPSQLDatabaseError.ErrorColumnName property added
[+] EPSQLDatabaseError.ErrorDatatypeName property added
[+] EPSQLDatabaseError.ErroConstraintName property added
[-] “Filtering DateTime field not working in early versions Delphi” bug fixed

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

Tagged with: , , , , ,
Posted in Announces
Map of wandering

Get every new post delivered to your Inbox.

Join 73 other followers