bi-directional syncing suggestions request

Поиск
Список
Период
Сортировка
От Paula Kirsch
Тема bi-directional syncing suggestions request
Дата
Msg-id CAHaXFPKRAk7B-qRHZjecpyV-UXQ+A8OBG9ZtA+SH9eRxLj=zmA@mail.gmail.com
обсуждение исходный текст
Список pgsql-admin
Hi. I'm looking for suggestions for the best solution to the following situation.

I have a database roughly 300 meg with 30 tables.

For fieldwork, a copy is running on my mac laptop where I can pull up information and add new entries.

The data analysis and further development is done back at the office on copy running on a linux server. The development and analysis work occasionally results in schema changes.

As a result, the situation is bi-directional, so not a master-slave replication situation and I'm not a professional dba. It is my personal research data, so I don't have to worry about other users.

My question is whether there is any recommended best practice for bi-directional syncing (schema changes would only be one direction, but data entries could flow both ways)?

Any suggestions would be appreciated.

Paula

В списке pgsql-admin по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Clarification when using Continous Archiving in 8.4
Следующее
От: Albe Laurenz
Дата:
Сообщение: Re: After upgrading from 9.1.1 to 9.1.9, pgadmin's server status window gives error