Description
PaGoDump is a GUI Windows utility for backing up a PostgreSQL database built with Microolap PostgresDAC. It makes consistent backups even if the database is being used concurrently. PaGoDump does not block other users accessing the database (readers or writers), also it works with databases with any names (unicode) and dump them to any files (unicode again).
Dumps can be output in script or archive file formats. Script dumps are plain-text files containing the SQL commands required to reconstruct the database to the state it was in at the time it was saved. To restore from such a script, feed it to psql. Script files can be used to reconstruct the database even on other machines and other architectures; with some modifications even on other SQL database products.
The alternative archive file formats must be used with pg_restore to rebuild the database. They allow pg_restore to be selective about what is restored, or even to reorder the items prior to being restored. The archive file formats are designed to be portable across architectures.
When used with one of the archive file formats and combined with pg_restore, PaGoDump provides a flexible archival and transfer mechanism. PaGoDump can be used to backup an entire database, then pg_restore can be used to examine the archive and/or select which parts of the database are to be restored. The most flexible output file format is the "COMPRESS" format. It allows for selection and reordering of all archived items, and is compressed by default. The TAR format is not compressed and it is not possible to reorder data when loading, but it is otherwise quite flexible; moreover, it can be manipulated with standard Unix tools such as tar.
Related:
Backup - Dump - Pgsql - Postgres - Postgresql - Schema - Table - Tool Free
User Reviews:
Related:
Habanero Pro v1.1Habanero is an object-relational mapping (ORM) architecture for .Net that maps object-oriented code to relational databases. It persists data to...By: Eric Savage |
Demo |
Oracle Reports Barcode PLL with PL SQL Source 1.2Add barcodes to Oracle Reports with this library. The bar code library is a PLL file that formats data from fields in the report to barcode fonts....By: Brant Anderson |
Demo |
Rapid Query 1.0Rapid Query is a database (administration tool) manager supporting Access, MySQL, PostgreSQL, SQL Server, Oracle databases and ODBC sources. It has...By: Damir Bulic |
Shareware |
ModelRight Community 3Whether you are a beginner or an expert database modeler, ModelRight 3 is your answer when you need a database modeling tool that surpasses the...By: Tim Guinther |
Freeware |
Access Object Navigator 3.0Access Object Navigator 3.0 is a complete user interface for Access database solutions. It is an Access add-on that provides you the Outlook-like...By: Sasa Smiljanec |
Demo |
# 1 PostgreSQL Manager - Navicat PostgreSQL Client (supports Access to PostgreSQL) 8.0.20Navicat (PostgreSQL GUI - supports Access to PostgreSQL) |
Shareware |
Dacio's Mysql backup 1.0Dacio's Mysql backup is an efficient MySQL backup software capable of storing all table and form datas in a file system as a dump file. Using this...By: Dacio |
Freeware |
PostgresDAC 2.6.4PostgresDAC: a PostgreSQL BDE replacement for Delphi 4-6 and BCB 5. It allows you to create Delphi/BCB5 applications with direct access to...By: Edward Smirnov |
Shareware |
MySQLBackUp 1.0MySQLBackUp With the component very simply backup (dump), restore and table-struct information from MySQL tables or whole databases. A demo program... |
Freeware |
EMS SQL Manager 2005 Lite for PostgreSQLEMS SQL Manager Lite for PostgreSQL is a light and easy-to-use freeware graphical tool for PostgreSQL administration. PostgreSQL Manager works with... |
Freeware |
- PostgreSQL
Sophisticated open-source Object-Relational DBMS supporting almost all SQL constructs, including subselects, transactions,... - PostgreSQL Manager
Graphical tool for PostgreSQL administration and development. - PostgreSQL Autodoc
Automated creation of PostgreSQL documentation in Dia, Docbook, HTML, and GraphViz formats. - PostgreSQL History Document
Capsule history of POSTGRES-related database management systems. - Performance Tuning PostgreSQL
This article aims to help demystify PostgreSQL database performance tuning. - Search PostgreSQL Sites
A searchengine for PostgreSQL-Documentation. Sample application for Tsearch2. - PostgreSQL JDBC Driver
Type 4 JDBC driver for PostgreSQL. [Open Source, Other] - PostGIS: Geographic objects for PostgreSQL
Spatially enables the server, allowing it to be used as a backend spatial database for geographic information systems (GIS). - Recursive functions in PostGreSQL PGSQL
An example of how to display a recursive tree in pgsql. - Distribution Analysis module for PostgreSQL
Graphical parameter distribution and function relations analysis software for PostgreSQL