Thread: backup database tablespace with rsync?

backup database tablespace with rsync?

From
chester c young
Date:
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 


Re: backup database tablespace with rsync?

From
"Scott Marlowe"
Date:
On 10/19/07, chester c young <chestercyoung@yahoo.com> wrote:
> 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'?

You can't rsync just pieces of the db.  you have to copy the whole database