On 4/13/2015 12:07 AM, Alban Hertroys wrote:
> That's easier to backup, sure, but you can't restore a single customer's schema easily that way. So if one customer messes up their data big time, you'll need to restore a backup for all customers in the DB.
if you use pg_dump -Fc, then you can specify the schema at pg_restore time.
--
john r pierce, recycling bits in santa cruz