Re: Can Postgres 8.x start if some disks containing tablespaces are not mounted?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Morris Goldstein" <morris(dot)x(dot)goldstein(at)gmail(dot)com>
Cc: "Zdenek Kotala" <Zdenek(dot)Kotala(at)sun(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Can Postgres 8.x start if some disks containing tablespaces are not mounted?
Date: 2008-04-02 14:55:06
Message-ID: 27824.1207148106@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

"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
> schema.

[ 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message carty mc 2008-04-02 14:57:30 Re: dblink ,dblink_exec not participating in a Transaction??
Previous Message Tatsuo Ishii 2008-04-02 14:44:33 Re: PGCon 2008, Are you going?

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2008-04-02 15:17:47 Re: varadic patch
Previous Message Morris Goldstein 2008-04-02 14:31:21 Re: Can Postgres 8.x start if some disks containing tablespaces are not mounted?