On linux, you can also do a
cp -rpuv. source destination
or script, something like this in good old bash:
ls directory | grep file extension copy.txt
list=$( /full path/copy.txt)
location=/target directory
scp $list user@host:$location
or rsync
rsync -avz --progress -e ssh
Le jeudi 01 mars 2012 à 14:01 -0800, Lonni J Friedman a écrit :
I've got a 3 node cluster (1 master/2 slaves) running 9.0.x with
streaming replication. I'm in the planning stages of upgrading to
9.1.x, and am looking into the most efficient way to do the upgrade
with the goal of minimizing
On Wed, 2012-03-21 at 09:12 +0100, Henk Bronk wrote:
On linux, you can also do a
cp -rpuv. source destination
My point was that we should not take shortcuts that avoid the work of a
full base backup for the replicas until we've determined a safe way to
do that.
As far as I know, nobody has
On Mon, Mar 19, 2012 at 03:07:02PM -0700, Jeff Davis wrote:
On Mon, 2012-03-19 at 15:30 -0400, Bruce Momjian wrote:
On Thu, Mar 01, 2012 at 02:01:31PM -0800, Lonni J Friedman wrote:
I've got a 3 node cluster (1 master/2 slaves) running 9.0.x with
streaming replication. I'm in the
On Tue, Mar 20, 2012 at 11:46 AM, Bruce Momjian br...@momjian.us wrote:
On Mon, Mar 19, 2012 at 03:07:02PM -0700, Jeff Davis wrote:
On Mon, 2012-03-19 at 15:30 -0400, Bruce Momjian wrote:
On Thu, Mar 01, 2012 at 02:01:31PM -0800, Lonni J Friedman wrote:
I've got a 3 node cluster (1 master/2
On Tue, Mar 20, 2012 at 11:56:29AM -0700, Lonni J Friedman wrote:
So how can you resume streaming without rebuilding the slaves?
Oh, wow, I never thought of the fact that the system tables will be
different? I guess you could assume the pg_dump restore is going to
create things exactly
On Tue, Mar 20, 2012 at 02:58:20PM -0400, Bruce Momjian wrote:
On Tue, Mar 20, 2012 at 11:56:29AM -0700, Lonni J Friedman wrote:
So how can you resume streaming without rebuilding the slaves?
Oh, wow, I never thought of the fact that the system tables will be
different? I guess you
On Tue, 2012-03-20 at 16:49 -0400, Bruce Momjian wrote:
On Tue, Mar 20, 2012 at 02:58:20PM -0400, Bruce Momjian wrote:
On Tue, Mar 20, 2012 at 11:56:29AM -0700, Lonni J Friedman wrote:
So how can you resume streaming without rebuilding the slaves?
Oh, wow, I never thought of the
actually rsync works fine on file level and is good for manual syncing.
it check really the files with the stat command, so a bit change will trigger
the copy
in practice you need to keep an eye on compleetness of the rsync action.
try to use it without compression for large data sets, it saves
On Tue, 2012-03-20 at 22:21 +0100, Henk Bronk wrote:
actually rsync works fine on file level and is good for manual syncing.
it check really the files with the stat command, so a bit change will trigger
the copy
in practice you need to keep an eye on compleetness of the rsync action.
Rsync
On Tue, Mar 20, 2012 at 8:27 PM, Jeff Davis pg...@j-davis.com wrote:
On Tue, 2012-03-20 at 22:21 +0100, Henk Bronk wrote:
actually rsync works fine on file level and is good for manual syncing.
it check really the files with the stat command, so a bit change will
trigger the copy
in
On Thu, Mar 01, 2012 at 02:01:31PM -0800, Lonni J Friedman wrote:
I've got a 3 node cluster (1 master/2 slaves) running 9.0.x with
streaming replication. I'm in the planning stages of upgrading to
9.1.x, and am looking into the most efficient way to do the upgrade
with the goal of minimizing
On Mon, Mar 19, 2012 at 12:30 PM, Bruce Momjian br...@momjian.us wrote:
On Thu, Mar 01, 2012 at 02:01:31PM -0800, Lonni J Friedman wrote:
I've got a 3 node cluster (1 master/2 slaves) running 9.0.x with
streaming replication. I'm in the planning stages of upgrading to
9.1.x, and am looking
On Mon, 2012-03-19 at 15:30 -0400, Bruce Momjian wrote:
On Thu, Mar 01, 2012 at 02:01:31PM -0800, Lonni J Friedman wrote:
I've got a 3 node cluster (1 master/2 slaves) running 9.0.x with
streaming replication. I'm in the planning stages of upgrading to
9.1.x, and am looking into the most
I've got a 3 node cluster (1 master/2 slaves) running 9.0.x with
streaming replication. I'm in the planning stages of upgrading to
9.1.x, and am looking into the most efficient way to do the upgrade
with the goal of minimizing downtime risk. After googling, the only
discussion that I've found
15 matches
Mail list logo