transfering data between DB's

From: johnf <jfabiani(at)yolo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: transfering data between DB's
Date: 2007-12-14 20:06:54
Message-ID: 200712141206.54244.jfabiani@yolo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Happy Holidays,
2 developers.
Two DB's one on my workstation and the other DB on a different workstation.

The problem:
As one developer makes changes to his DB and those changes can be either data
or structure - the other developer needs to update his DB.

If the changed table is backed up and then restored on the a different
workstation the sequence data is lost and does not work correctly.

I'm sure this is not a new problem for the software guys developing postgres
applications.

When just data changes occur I'd like some way to transfer just the data
between DB's. And I would like a simple way to setup structure changes
between the tables.

So how is it handled?
--
John Fabiani

Browse pgsql-novice by date

  From Date Subject
Next Message Adam Conrad 2007-12-16 01:36:46 Postgres Help with TPC-H
Previous Message A. Kretschmer 2007-12-13 20:24:17 Re: remote user