transfering data between DB's - Mailing list pgsql-novice

From johnf
Subject transfering data between DB's
Date
Msg-id 200712141206.54244.jfabiani@yolo.com
Whole thread Raw
List 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

pgsql-novice by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: remote user
Next
From: "Adam Conrad"
Date:
Subject: Postgres Help with TPC-H