Copy database between two PostgreSQL servers

Question

Is there some tool to copy database from one PostgreSQL to other on the fly NOT INVOLVING BACKUPS/RESTORES? The tool which automatically keeps database structure on slave server in sync with master server. Probably the tool with differential mode looking at records' primary keys.

I could use replication, but the problem is that it ties two servers in a permanent manner, and I do not need a continuous replication. I need to start it manually. It should terminate when finishes.

I had started to write my own .NET tool using reflection etc, but thought that may be somebody has already written such a tool.

Richard Huxton · Accepted Answer · 2012-12-07 13:30:21Z

2

Replication is the term you are looking for.

There are many variations on how to do this. Start by reading the manual and then google a little.

If the whole-system replication built-in to recent versions of PostgreSQL isn't to your taste then try searching for "slony" or "pg-pool" or "bucardo" (among others).

answered Dec 7, 2012 at 13:30

Richard Huxton

23.6k5 gold badges43 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Paul Over a year ago

Is the replication possible on Herkou?

Richard Huxton Over a year ago

Then the problem is that your question isn't accurate and neither will any answers be. Sit down and think exactly what you want to achieve and try posting another question. Make sure you are clear about what you want copied, what you will be changing and what should happen if something has been changed in both databases between updates.

Collectives™ on Stack Overflow

Copy database between two PostgreSQL servers

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related