Re: schema or database - Mailing list pgsql-general

From John R Pierce
Subject Re: schema or database
Date
Msg-id 552B6BD6.6040606@hogranch.com
Whole thread Raw
In response to Re: schema or database  (Alban Hertroys <haramrae@gmail.com>)
List pgsql-general
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
messesup 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



pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: schema or database
Next
From: "David G. Johnston"
Date:
Subject: Re: Limiting user from changing its own attributes