| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Douglas McNaught | 2008-04-02 02:10:58 | Re: dblink ,dblink_exec not participating in a Transaction?? |
| Previous Message | Greg Smith | 2008-04-02 00:31:57 | Re: simple update queries take a long time - postgres 8.3.1 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | sanjay sharma | 2008-04-02 01:48:34 | Re: column level privileges |
| Previous Message | Guillaume Smet | 2008-04-02 01:04:04 | Re: Re: [HACKERS] How embarrassing: optimization of a one-shot query doesn't work |