PaGoDump & PaGoRestore v9.0.4 are out

Microolap Technologies is happy to announce that new version of GUI utilities for backing up and restoring a PostgreSQL database provides full PostgreSQL v9.0.4 support. Support for 8.4.8, 8.3.15 and 8.2.21 versions added as well.

You’re welcome to download the latest release from our website at:
http://microolap.com/products/database/pagodump/download/

Full changelog:
[+] v8.2.21 dump & restore libraries added (pg_dump-8.2.21.dll, pg_restore-8.2.21.dll)
[+] v8.3.15 dump & restore libraries added (pg_dump-8.3.15.dll, pg_restore-8.3.15.dll)
[+] v8.4.8 dump & restore libraries added (pg_dump-8.4.8.dll, pg_restore-8.4.8.dll)
[+] v9.0.4 dump & restore libraries (pg_dump-9.0.4.dll, pg_restore-9.0.4.dll)
[+] v9.0.4 client libraries added
[*] Error logging improved
[*] Speed up parallel restore when the archive contains many large objects
[-] “Cannot use custom restore library, always ‘pg_restore.dll’ used” bug fixed
[-] Fix parallel restore to handle comments on POST_DATA items correctly
[-] Fix restore to cope with long lines (over 1KB) in TOC files

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

Advertisements

Extended trial for PgMDD

For all blog readers and @microolap followers! You may use special registration code to extend trial period for MicroOLAP Database Designer for PostgreSQL for two months. Just use in the registration window:

  • login: Blog Reader
  • key: 019TNG-A0EWBC-GKDNPG-9FW9HM-KU0RZC-GHN2K2-GGD0C0-55DJ38-6EG6WP-NX6K05

Thank you for using MicroOLAP Database Designer for PostgreSQL!
http://microolap.com/products/database/postgresql-designer/

PaGoDump & PaGoRestore v9.0.0 are out

Microolap Technologies is happy to announce that new version of GUI utilities for backing up and restoring a PostgreSQL database provides full PostgreSQL 9.x support.

You’re welcome to download the latest release from our website at:
http://microolap.com/products/database/pagodump/download/

PaGoDump changelog:
[!] Support for PostgreSQL 9.x introduced
[+] Allow to dump comments attached to columns of composite types
[+] Make “Verbose Messages” option output the client and server versions in text output mode
[*] Make “Drop Database” option also remove large objects
[-] Fix to properly dump large objects when standard_conforming_strings is enabled

PaGoRestore changelog:
[!] Support for PostgreSQL 9.x introduced
[*] Make “Clean Objects” option also remove large objects
[*] Now emits large-object data in hex format when generating script output

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

PostgreSQL v9.0.0 client libraries update

We (in MicroOLAP Technologies) just finished client libraries update for 9.0.0 version.

Quick facts:

  • Two packages were updated:
    • Deployment libraries shipped with PostgreSQL installation
    • Deployment libraries built with MinGW environment
  • Both packages are built against 9.0.0 version of PostgreSQL
  • Dump and restore libraries for 8.4.x, 8.3.x and 8.2.x PostgreSQL branches are included into “Deployment libraries built with MinGW environment” package
  • Included dump and restore libraries (pg_dump-x.x.x.dll, pg_restore-x.x.x.dll) may be used with PaGoDump and PaGoRestore utilities respectively.

Have a nice day!

PostgreSQL v8.4.3 client libraries update

We (in MicroOLAP Technologies) just finished client libraries update for 8.4.3 version.

Quick facts:

  • Two packages were updated:
    • Deployment libraries shipped with PostgreSQL installation
    • Deployment libraries built with MinGW environment
  • Both packages are built against 8.4.3 version of PostgreSQL
  • Comparing to 8.3.6 version libpq.dll library shipped with PostgreSQL installation depends on 12 libraries now (were 9 in 8.3.6)
  • Dump and restore libraries for 8.3.x and 8.2.x PostgreSQL branches are included into “Deployment libraries built with MinGW environment” package
  • Included dump libraries (pg_dump-8.2.16.dll, pg_dump-8.3.10.dll) may be used with PaGoDump utility either

Enjoy!

PostgreSQL vs MySQL: Russian reality

note This article available in Russian.

This post is some kind of statistic about campaign had place on the Russian IT-community site Habrahabr.ru. On behalf of the MicroOLAP company we gave away free personal licenses for Database Designers for PostgreSQL and MySQL there.

Popularity

I will not discover the exact licenses count, but will provide you with statistical torus:

Torus

Have no idea how to treat these results. I hope some implications will appear in the comments.

Membership

I may also share data on the approximation of the population “layers”

  • 80% — students and teachers (to learn),
  • 5% — freelancers,
  • 3% — state agencies,
  • 2% — girls (judging by their names 😉 ).

One more interesting fact. Database Designer for MySQL is in demand among studying youth and web-freelancers, but Database Designer for PostgreSQL is the matter of significant interest of corporative people. However we didn’t see any strange things that PostgreSQL is seriously considered as an alternative to Oracle, at least, for the new projects.

But we were surprised that nobody asked about support of EnterpriseDB, which is aggressively positioning itself as “PostgreSQL compatible with Oracle”:

Built upon PostgreSQL … offers deeper Oracle® compatibility.

PS

I didn’t include Database Designer for MsSQL in this report because of it’s pre-beta status. «Pre-beta» — is some kind of euphemism for us, application may be used freely — monitor will not blow up. 😉 Just there is no documentation yet and some bugs may reveal themselves.