On 06/01/07 16:25, Andrew Sullivan wrote:
On Fri, Jun 01, 2007 at 03:58:01PM -0500, Ron Johnson wrote:
What you need are disk blocks to be mirrored to a machine at the DR
site. Or "continuous PITR" to the DR machine.
I thought you could already do this? (I'm not, but I was pretty sure
someone reported doing it already.)
From within PG, or "manually"?
This then begs the question: are CREATE|ALTER TABLESPACE commands
stored in the xlogs?
(I'll spare the rant about begging the question.) Since they're
transactional, they must be, no?
I wasn't sure whether they were a special case or not.
--
Ron Johnson, Jr.
Jefferson LA USA
Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
