backup database tablespace with rsync?

From: chester c young <chestercyoung(at)yahoo(dot)com>
To: sql pgsql <pgsql-sql(at)postgresql(dot)org>
Subject: backup database tablespace with rsync?
Date: 2007-10-20 02:11:29
Message-ID: 451865.61216.qm@web54302.mail.re2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

postgres A, db 'test', tablespace /pg/test1
postgres B, db 'test', tablespace /pg/test2

tablespace /pg/test1 only has A db 'test'
tablespace /pg/test2 only has B db 'test'

if
- A and B shut down
- /pg/test1 copied to /pg/test2
- A and B restarted

would B db 'test' be running the data that was in A db 'test'?

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mike Adams 2007-10-20 05:45:11 Re: Refactored queries needing validation of syntactic equivalence
Previous Message 李彦 Ian Li 2007-10-18 02:24:50 Re: two queryes in a single tablescan