| 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
| 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? |
| 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? |