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: pgsql-general(at)postgresql(dot)org
Subject: Re: Can Postgres 8.x start if some disks containing tablespaces are not mounted?
Date: 2008-03-31 17:58:32
Message-ID: 47F12648.1030506@sun.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
Morris Goldstein napsal(a):
> Suppose I have a database with $PGDATA on /dev/sda, and a tablespace
> directory on /dev/sdb. Will Postgres start successfully if /dev/sda is
> mounted and /dev/sdb is not? If not, why not?

It is not good idea to run PostgreSQL in your scenario. However PostgeSQL needs 
only catalog tables to start. Until you don't touch data stored on unmounted 
disk you should not get any error.


		Zdenek

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2008-03-31 18:10:35
Subject: Re: Can Postgres 8.x start if some disks containing tablespaces are not mounted?
Previous:From: Morris GoldsteinDate: 2008-03-31 17:54:57
Subject: Can Postgres 8.x start if some disks containing tablespaces are not mounted?

pgsql-general by date

Next:From: Tom LaneDate: 2008-03-31 18:10:35
Subject: Re: Can Postgres 8.x start if some disks containing tablespaces are not mounted?
Previous:From: BenDate: 2008-03-31 17:55:32
Subject: Re: Schema design question

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