Re: Why database is corrupted after re-booting - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Why database is corrupted after re-booting
Date
Msg-id 1130346610.21880.4.camel@jd.commandprompt.com
Whole thread Raw
In response to Re: Why database is corrupted after re-booting  ("Andrus" <eetasoft@online.ee>)
Responses Re: Why database is corrupted after re-booting
Re: Why database is corrupted after re-booting
List pgsql-general
On Wed, 2005-10-26 at 19:14 +0300, Andrus wrote:
> > To change partition types you need to re-format (resetting partitions
> > will lose data structure - reformat required).
>
> Troy,
>
> Whole my IDE drive is 20 GB FAT32 C: drive booting XP
> I have a lot of data in this drive so it is not possible to re-format. Also
> I do'nt want to create two logical disks in single drive.
>
> Is this prevents data corruption for Postgres, is there some utility which
> can convert C: drive to NTFS ?
> Can Partition Magic help ?

XP at least on install I believe has the ability to convert to NTFS.

Have you tried just right clicking on your C: selecting properties
and then seeing if there is a convert option?

>
> Andrus
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Why database is corrupted after re-booting
Next
From: Bruno Wolff III
Date:
Subject: Re: Generic Q about max(id) vs ORDER BY ID DESC LIMIT 1 -- SOLVED