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

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

From: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(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 12:44:08
Message-ID: 47F37F98.60005@sun.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
Morris Goldstein napsal(a):

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

yes, Probably best solution in this case is to implemented tablespace 
availability into postgreSQL and PostgreSQL shouldn't start when tablespace is 
missing.

		Zdenek

In response to

Responses

pgsql-hackers by date

Next:From: Greg Sabino MullaneDate: 2008-04-02 12:55:40
Subject: Re: Friendly help for psql
Previous:From: Dimitri FontaineDate: 2008-04-02 10:33:56
Subject: Re: GiST opclass and varlena

pgsql-general by date

Next:From: Greg Sabino MullaneDate: 2008-04-02 13:07:01
Subject: Re: [GENERAL] SHA1 on postgres 8.3
Previous:From: Albe LaurenzDate: 2008-04-02 12:18:25
Subject: Re: Foreign keys causing conflicts leading toserialization failures

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