On 02/21/2015 05:25 PM, David Steele wrote:
On 2/21/15 6:08 PM, Adrian Klaver wrote:
Currently the built in replication solutions work at the cluster level,
not at the database level. There are third party tools, Slony and
Bucardo come to mind, that can work at a more focused level.
Again, it depends in what kind of access your customers have to the
database. Logical backups can be done on a per-database basis (and are
very practical for small datasets), but physical backups (which are more
efficient) must backup the entire cluster (except for the third-party
solutions noted above that have their own challenges).
You said you don't want to give a lot of information, but the optimal
solution depends on how your customers connect to their database:
1) Entirely through an application or API
2) Directly to the db via psql, PgAdmin, JDBC, etc.
Without that information it's hard to give really solid advice.
Sorry, to be more specific our application is on top of a java
framework. Similar to Ruby On Rails. Customers don't interface with the
database at all, only through the website which provides our services.
--Sam
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general