Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2008-04-02 15:17:47
Subject: Re: varadic patch
Previous:From: Morris GoldsteinDate: 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 mcDate: 2008-04-02 14:57:30
Subject: Re: dblink ,dblink_exec not participating in a Transaction??
Previous:From: Tatsuo IshiiDate: 2008-04-02 14:44:33
Subject: Re: PGCon 2008, Are you going?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group