[ADMIN] bi-directional syncing suggestions request

2013-08-08 Thread Paula Kirsch
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

Re: [ADMIN] Clarification when using Continous Archiving in 8.4

2013-08-08 Thread Bruce Momjian
On Tue, Jul 16, 2013 at 11:30:54AM -0500, Nestor A. Diaz wrote: > Hello People, > > In reference to my last post , my question is: It is possible to recover more > (subsequent) WAL files when I have already recover a postgres 8.4 database > using a PITR ? I have read on some places that it's not p

Re: [ADMIN] Recommended way to dump multi db cluster

2013-08-08 Thread Jan Lentfer
On Thu, 08 Aug 2013 10:56:19 +0200, lst_ho...@kwsoft.de wrote: as of now we do a pg_dumpall on most of our PostgreSQL instances. This has some drawbacks when restore of only one of the databases is required, because from what i can see pg_restore is not able to limit the restore to one database

[ADMIN] Recommended way to dump multi db cluster

2013-08-08 Thread lst_hoe02
Hello, as of now we do a pg_dumpall on most of our PostgreSQL instances. This has some drawbacks when restore of only one of the databases is required, because from what i can see pg_restore is not able to limit the restore to one database? With pg_dump per database the problem will arise