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

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

From: "Morris Goldstein" <morris(dot)x(dot)goldstein(at)gmail(dot)com>
To: "Zdenek Kotala" <Zdenek(dot)Kotala(at)sun(dot)com>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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:31:21
Message-ID: 41b6f5c20804020731k5e89ec6fl2b215ff4dfdfd87e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
On Wed, Apr 2, 2008 at 8:44 AM, Zdenek Kotala <Zdenek(dot)Kotala(at)sun(dot)com> wrote:
> Morris Goldstein napsal(a):
> > - Postgres running normally on /dev/sda and /dev/sdb.
> > - Update to table in /dev/sdb tablespace is committed but still exists in
> WAL.
> > - Postgres crashes (e.g. power failure).
> > - Postgres starts with /dev/sda only.
> > - Recovery needs to update table in /dev/sdb tablespace.
> >
> > I assume bad things will happen in this case.
> >
>
>  yes, Probably best solution in this case is to implemented tablespace
> availability into postgreSQL and PostgreSQL shouldn't start when tablespace
> is missing.

I would rather see Postgres complain on the first reference to the
missing tablespace, (i.e. current behavior). Our schema has multiple
schemas, some of which are needed for our application at startup time;
others are needed later, once startup is complete.

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.

Morris

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2008-04-02 14:55:06
Subject: Re: Can Postgres 8.x start if some disks containing tablespaces are not mounted?
Previous:From: Greg Sabino MullaneDate: 2008-04-02 13:07:01
Subject: Re: [GENERAL] SHA1 on postgres 8.3

pgsql-general by date

Next:From: Roberts, JonDate: 2008-04-02 14:33:56
Subject: Re: dblink ,dblink_exec not participating in a Transaction??
Previous:From: Chris HooverDate: 2008-04-02 13:37:20
Subject: PGCon 2008, Are you going?

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