pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedbackup database tablespace with rsync?
2+ messages / 2 participants
[nested] [flat]
* backup database tablespace with rsync?
@ 2007-10-20 02:11 chester c young <chestercyoung@yahoo.com>
0 siblings, 1 reply; 2+ messages in thread
From: chester c young @ 2007-10-20 02:11 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: backup database tablespace with rsync?
@ 2007-10-20 09:01 Scott Marlowe <scott.marlowe@gmail.com>
parent: chester c young <chestercyoung@yahoo.com>
0 siblings, 0 replies; 2+ messages in thread
From: Scott Marlowe @ 2007-10-20 09:01 UTC (permalink / raw)
To: chester c young <chestercyoung@yahoo.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-10-20 09:01 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-10-20 02:11 backup database tablespace with rsync? chester c young <chestercyoung@yahoo.com>
2007-10-20 09:01 ` Scott Marlowe <scott.marlowe@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox