Home > By category > Servers >Other Server Applications > PostgreSQL Sync



PostgreSQL Sync

  • Downloads: 
  • Views: 
  • Rating:

The PostgreSQL Sync application was developed to be a simple and easy database synchronization tool.

As I'm using rsync on a regular base I thought why isn't there a tool for databases that simply does nothing more than synchronizing two databases on demand - no sophisticated triggers or additional changes of the database.

psync is a simple application synchronizes two PostgreSQL databases. The concept can be adapted or even encapsulated that also other databases can be used.

The idea of psync is to use two database connections and update the tables and their content like this:
- fetch all tables of source and destination databases
- for each table in source do:
create table if not exist on destination
sync content of table
- foreach table in destination do:
delete table if not exists on source

Although the algorithm looks simple there are many problems to overcome.
- Duplicating tables
- Handling of special columns, e.g. oid for large objects
- Constraints on tables
- Special structures of extensions

Free download from Shareware Connection - The PostgreSQL Sync application was developed to be a simple and easy database synchronization tool.

Publisher: Martin Faust | License: Shareware
Version: 1.0 | Size: 30 KB | Platform: WinOther
Released Date: | Rating: 0 | Title: PostgreSQL Sync

Author Url: http://www.codeproject.com
Program Info Url: http://www.codeproject.com
Download Url: http://www.codeproject.com/KB/database/psync/psync.zip

PostgreSQL Sync keywords:
PostgreSQL Sync related downloads:

Free FLV to MP4 Converter for Mac - Free FLV to MP4 Converter for Mac is an ideal Mac FLV to MP4 Converter in converting FLV to MP4 Mac. Apart from convert FLV video to MP4 for Mac, this FLV to MP4 converter can also convert FLV to many other video formats as you wish.

Free Call Of Duty MW3 Screensaver - Free Call Of Duty MW3 Screensaver,Free Call Of Duty Modern Warfare 3 Screensaver

Empty Tables - Empty Tables is a lightweight utility that enables you to quickly delete information from database tables using a customizable command.

Hide My Browser Free - Hide My Browser Free - hide windows freeware. Using Hide My Browser Free you can hide windows (browser windows), minimize all windows, close browsers windows by hotkeys or from program toolbar. Hide your windows with our free hide windows software.

PostgreSQL Maestro - PostgreSQL Maestro is a powerful Windows database management solution for PostgreSQL administration and development. PostgreSQL Maestro provides you with graphical user interface (GUI), which allows you to perform database operations easy and fast.

Shareware Connection periodically updates pricing and software information of 'PostgreSQL Sync' from company source 'Martin Faust' , so some information may be slightly out-of-date. You should confirm all information before relying on it. Software piracy is theft,  Using 'PostgreSQL Sync' crack, password, serial numbers, registration codes, key generators is illegal and prevent future development of PostgreSQL Sync.

New Reviews

Panda Cloud Cleaner - PC security has become a tricky and complicated subject both for home users and network supervisors, with complexity and risk factors multiplying over the years. Using a single antivirus app may not be enough anymore. That explains why many users ...

BitKiller - Dealing with various types of data efficiently holds the key to success in any computing task. Apart from generating new data and modifying existing files, it becomes necessary to delete existing files at times. While most users resort to using ...

Trend Micro HouseCall - With time, PC users find it increasingly difficult to keep their systems free of malware and rogue apps, despite using latest and feature packed security software. This is mostly owing to the evolving nature of malware and newer types of ...

Sony Movie Studio 13 Platinum - Sony enjoys a prime position in consumer level media software development and its Movie Studio has a large fan following. However, in recent years competition from Adobe and Corel has caught up. The recent overhaul of Sony’s video editor ...

Avast Endpoint Protection Suite Plus - PC security has become a vital aspect of computing nowadays and business users face the heat more than home users. While installing and handling a standalone antivirus suite is neither tedious nor time consuming, the scenario is different in ...

Apple iMovie - For higher end video editing and post production related needs on Mac OS, the preferred choice is FCP in most instances. However, not all Mac users need to deal with a feature laden, sophisticated editor for casual needs. For casual to moderate ...

NovaBench - PC performance benchmarking is something that may not interest average users much but tech savvy lot resort to such apps to find out prowess and capability of their laptops and desktops. While there are quite a few PC benchmarking apps in market, ...

Cryper - Nowadays PC users can no longer rely completely on any security software. Newer ways of data theft and exploits are emerging on the horizon, making PC security a complicated and worrisome thing. If you are particular about the data you store in ...

CleanMyDrive - PC experts unanimously agree that using Macs tend to be a smoother and faster experience than running Windows based PCs but the Apple laptops and desktops also need maintenance and performance tweaking, occasionally. Regular web browsing, ...

Norton Zone - With a lot of your data being stored in some cloud service or other, it becomes necessary after a point to zero in on any one service rather than using many at the same time. As it is, major software companies are resorting to cloud based service ...




New Downloads

Entity Developer for SQL
Server Express Edition

Entity Developer is a free
powerful modeling and code
generation tool for ADO.

Windows Server 2003
Access-based Enumeration

Windows Server 2003
Access-based Enumeration makes
visible only those files or
folders that the user has the
rights to ...

tinyREST

Small Java based REST server.

AxioWorks SQList Manager

AxioWorks SQList Manager is
designed to provide you with a
solution for displaying the
content of SharePoint sites as
a ...

Update for Windows Server
2008 x64 Edition (KB968912)

Install this update to extend
support for Key Management
Service (KMS) to provide
activation for Windows 7 and
Windows ...

jHTTPd for Windows

jHTTPd is a simple HTTP/1.

TinyUpLoader

This utility upload files to
ftp server.

jubito Server

jubito Server provides you
with an intuitive platform
that enables you to
interconnect hardware and
software components, ...

ULS Deobfuscator

ULS Deobfuscator is a
SharePoint helper designed to
enable users to view ULS log
files.

SQLite Expert Personel

SQLite Expert is a powerful
visual tool that enables you
to easily administer your
SQLite3 databases and gain ...

Windows Server AppFabric
x64

Windows Server AppFabric x64
is a set of integrated
technologies that make it
easier to build, scale and
manage Web and ...

IntraMessenger Server

This instant messaging is
corporate oriented
(enterprise), with local
networks (LAN) or internet for
effective ...