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

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

From: "Gurjeet Singh" <singh(dot)gurjeet(at)gmail(dot)com>
To: "Morris Goldstein" <morris(dot)x(dot)goldstein(at)gmail(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 01:16:26
Message-ID: 65937bea0804011816p733414efvba162e401f4f3165@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
On Tue, Apr 1, 2008 at 7:42 PM, Morris Goldstein <
morris(dot)x(dot)goldstein(at)gmail(dot)com> wrote:

> But that makes me wonder: what about this sequence of events:
>
> - 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.
>
>
200% correct.

-- 
gurjeet[(dot)singh](at)EnterpriseDB(dot)com
singh(dot)gurjeet(at){ gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB http://www.enterprisedb.com

Mail sent from my BlackLaptop device

In response to

pgsql-hackers by date

Next:From: sanjay sharmaDate: 2008-04-02 01:48:34
Subject: Re: column level privileges
Previous:From: Guillaume SmetDate: 2008-04-02 01:04:04
Subject: Re: Re: [HACKERS] How embarrassing: optimization of a one-shot query doesn't work

pgsql-general by date

Next:From: Douglas McNaughtDate: 2008-04-02 02:10:58
Subject: Re: dblink ,dblink_exec not participating in a Transaction??
Previous:From: Greg SmithDate: 2008-04-02 00:31:57
Subject: Re: simple update queries take a long time - postgres 8.3.1

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