PaGoDump - PostgreSQL Changelog

What's new in PaGoDump - PostgreSQL 9.5.1

Oct 4, 2017
  • v9.5.1 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • v9.4.5 dump & restore libraries (pg_dump-9.4.5.dll, pg_restore-9.4.5.dll) added
  • v9.3.7 dump & restore libraries (pg_dump-9.3.7.dll, pg_restore-9.3.7.dll) added
  • "Enable Row Security" extended option added
  • "Use IF EXISTS clause" extended option added
  • Avoid dump/reload problems when using both plpython2 and plpython3
  • Make PaGoDump mark a view's triggers to be processed after its rule, to prevent possible failure during parallel restore
  • PaGoRestore handles inherited NOT VALID check constraints correctly
  • PaGoRestore handles object privileges sanely when dumping from a server too old to have a particular privilege type
  • PaGoRestore supports cases where the postgres or template1 database is in a non-default tablespace
  • Support for shell types (not fully defined) to PaGoRestore added
  • Temporary files created during a PaGoRestore run with tar-format output are not world-readable now
  • "Improper quoting of domain constraint names in PaGoDump" bug fixed
  • Assorted corner-case bugs in PaGoRestore's processing of extension member objects fixed
  • Assorted minor memory leaks in PaGoRestore fixed
  • Selection of default zlib compression level in PaGoRestore's directory output format Fixed

New in PaGoDump - PostgreSQL 9.4.2 (Jun 18, 2015)

  • PostgreSQL v9.4.2 support introduced.
  • Support for 9.3.7 and 9.2.11 versions added as well.
  • Some bugs fixed.

New in PaGoDump - PostgreSQL 9.3.4 (Apr 15, 2014)

  • Brand new refactored libraris with 9.2 and 9.3 versions support added
  • Directory format added to PaGoDump
  • PaGoDump ExcludeTablesData property added
  • PaGoDump allows non-Latin characters in output file names
  • tar files emitted by PaGoDump are POSIX conformant now
  • PaGoDump better handle views containing partial GROUP BY lists from now
  • PaGoDump excludes data of unlogged tables when running on a hot-standby server
  • PaGoDump outputs functions in a more predictable order
  • PaGoDump's handling of inherited table columns improved
  • Compression of plain-text output format in PaGoDump fixed
  • Fix bugs in the restore.sql script emitted byPaGoDump in tar output format
  • Fix PaGoDump for views with circular dependencies and no relation options
  • Fix PaGoDump to dump user-defined casts between auto-generated types, such as table rowtypes
  • Fix PaGoDump's handling of DROP DATABASE commands if doClean option specified
  • Make PaGoDump put SEQUENCE SET items in the data not pre-data section of the archive
  • Missed quoting of foreign server names in PaGoDump fixed
  • Platform-specific infinite loop in PaGoDump avoided

New in PaGoDump - PostgreSQL 9.2.1 (Nov 23, 2012)

  • v9.2.1 client libraries added
  • v9.2.1 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • v9.1.5 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • TPSQLDump better handle views containing partial GROUP BY lists from now

New in PaGoDump - PostgreSQL 9.1.3 (Jun 7, 2012)

  • Connection library ignores ENOTDIR errors when looking for an SSL client certificate file
  • PaGoDump's handling of inherited table columns improved
  • Arbitrary limitation on length of common name in SSL certificates removed
  • Compression of plain-text output format in PaGoDump fixed
  • Contents of an extension's configuration tables aren't dumped if the extension itself is not being dumped
  • Fix PaGoDump to dump user-defined casts between auto-generated types, such as table rowtypes
  • Missed quoting of foreign server names in PaGoDump fixed
  • Newlines are converted to spaces in names written in PaGoDump comments
  • Platform-specific infinite loop in PaGoDump avoided

New in PaGoDump - PostgreSQL 9.0.4 (Oct 28, 2011)

  • 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

New in PaGoDump - PostgreSQL 9.0.0 (Oct 28, 2011)

  • 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

New in PaGoDump - PostgreSQL 8.4.3 (Oct 28, 2011)

  • Support for PostgreSQL 8.4.3 introduced
  • Support for several dump libraries added (8.2.16, 8.3.10, 8.4.3)
  • Dump file extension changes automatically depending on output format setting now
  • --execute and --exit-on-success command line parameters added
  • Empty "Compression Level" value is treated as 0 (no compression) from now
  • "Impossible to choose DB from other server if another server connection options were entered before" bug fixed
  • "Only localhost connections are available" critical bug fixed
  • "Options are still used in the repetitive dump even if unchecked" bug fixed

New in PaGoDump - PostgreSQL 8.4.1 (Oct 28, 2011)

  • Support for PostgreSQL 8.4.1 introduced
  • Support for several dump libraries added (8.3.8, 8.4.1)
  • "Ignore Version" option restored for pre-8.4.x libraries

New in PaGoDump - PostgreSQL 8.4.0 (Nov 2, 2009)

  • Support for PostgreSQL 8.4.0 added
  • "Lock Wait Timeout" option added
  • Support for "No Tablespace" funtionality added
  • Using a specified role allowed
  • "Ignore Version" option removed as deprecated since PosgreSQL v8.4
  • Order "Only Data" output to dump fixed
  • "Schema excluding is leading to the application fail" bug fixed