"Morris Goldstein" <morris(dot)x(dot)goldstein(at)gmail(dot)com> writes:
> Without going into a lot of details about our application, I'll just
> say that the ability to start Postgres with just the "startup schema"
> present is incredibly useful. On a SAN, we put this startup schema
> on a volume that is permanently bound to a node, and the other schema
> on a volume that can fail over to another node. Tablespaces allow us
> to start Postgres and then fail back the volume containing the second
[ retrieves eyebrows from ceiling... ] Have you actually tested this?
It sounds to me like you are thinking you can reattach the tablespace
to a different database instance, which is guaranteed not to work.
You've got to fail over the entire instance as a whole.
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Alvaro Herrera||Date: 2008-04-02 15:17:47|
|Subject: Re: varadic patch|
|Previous:||From: Morris Goldstein||Date: 2008-04-02 14:31:21|
|Subject: Re: Can Postgres 8.x start if some disks containing tablespaces are not mounted?|
pgsql-general by date
|Next:||From: carty mc||Date: 2008-04-02 14:57:30|
|Subject: Re: dblink ,dblink_exec not participating in a Transaction??|
|Previous:||From: Tatsuo Ishii||Date: 2008-04-02 14:44:33|
|Subject: Re: PGCon 2008, Are you going?|