Vivek Khera vivek
Fri Dec 8 14:17:22 PST 2006
On Dec 8, 2006, at 4:11 AM, St?phane Schildknecht wrote:

>
> Knowing that, I guess backups have to be done on the master.  But,  
> what
> would be the risks to dump database on the slave without dumping the
> slony replication schema?

I dump schema from master, and data from a replica.  Just keep in  
mind that you need to test and adjust your restore procedures to  
handle this, and be aware of things you may wish to ignore in the  
dump, such as the slony schema data.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2530 bytes
Desc: not available
Url : http://gborg.postgresql.org/pipermail/slony1-general/attachments/20061208/6682b94d/attachment.bin 



More information about the Slony1-general mailing list