>
> All that said, my guess is you're doing this to support horizontal
> scale-out, which means you'll probably need to do this more than once, and
> it'd presumably be nice for you and your customers if this didn't require
> downtime. I would look at having a way to create a partial replica using
On 4/29/15 6:04 PM, Dave Owens wrote:
A. Text-processing a dump of the original database, filtering only the
rows in which I am interested, while loading the dump into the new database.
B. Copying the original database (CREATE DATABASE smalldb WITH TEMPLATE
bigdb), then modifying the schema so
Greetings,
We are migrating a subset of our customers to a new set of servers. This
requires that we migrate their data stored in postgresql (v9.1.15, Linux)
to a new database. The new database happens to reside in the same cluster,
but in the future this may not be the case. We are using a sep
