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: 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 18:10:35
Message-ID: 15645.1206987035@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:
> 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 will start, but you will have unpleasant failures when you try to use
tables in the secondary tablespace ... note that if autovacuum is on,
that is likely to happen even without any explicit action on your part.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: sanjay sharmaDate: 2008-03-31 18:21:06
Subject: Re: Submission of Feature Request : RFC- for Implementing Transparent Data Encryption in P
Previous:From: Zdenek KotalaDate: 2008-03-31 17:58:32
Subject: Re: Can Postgres 8.x start if some disks containing tablespaces are not mounted?

pgsql-general by date

Next:From: Pavan DeolaseeDate: 2008-03-31 18:34:25
Subject: Re: [HACKERS] ANALYZE getting dead tuple count hopelessly wrong
Previous:From: Zdenek KotalaDate: 2008-03-31 17:58:32
Subject: Re: Can Postgres 8.x start if some disks containing tablespaces are not mounted?

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