Thread: Fat16/32 linking problems

Hi,
I have a little trouble with running Postgress on a embedded linux with
only Fat availible.
it runs for hours, but the it crashes and I cannot start it again.
Any Ideas ?

LOG:  database system was shut down at 2008-09-23 15:32:05 UTC
LOG:  checkpoint record is at 0/C4643C
LOG:  redo record is at 0/C4643C; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 2371; next OID: 25547
PANIC:  could not link file "/home/es4/pgsql/pg_xlog/xlogtemp.3438" to
"/home/es4/pgsql/pg_xlog/000000010000000000000001" (initialization of
log file 0, segment 1): Operation not permitted
LOG:  startup process (PID 3438) was terminated by signal 6
LOG:  aborting startup due to startup process failure



Jonny

On Tue, 23 Sep 2008 16:07:45 +0200
Jonny Rabovsky <jonny@rabovsky.de> wrote:

> Hi,
> I have a little trouble with running Postgress on a embedded linux
> with only Fat availible.
> it runs for hours, but the it crashes and I cannot start it again.
> Any Ideas ?

As I recall, NTFS is required for Win32.

Joshua D. Drake

>
> LOG:  database system was shut down at 2008-09-23 15:32:05 UTC
> LOG:  checkpoint record is at 0/C4643C
> LOG:  redo record is at 0/C4643C; undo record is at 0/0; shutdown TRUE
> LOG:  next transaction ID: 2371; next OID: 25547
> PANIC:  could not link file "/home/es4/pgsql/pg_xlog/xlogtemp.3438"
> to "/home/es4/pgsql/pg_xlog/000000010000000000000001" (initialization
> of log file 0, segment 1): Operation not permitted
> LOG:  startup process (PID 3438) was terminated by signal 6
> LOG:  aborting startup due to startup process failure
>
>
>
> Jonny
>


--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/

Jonny Rabovsky <jonny@rabovsky.de> writes:
> I have a little trouble with running Postgress on a embedded linux with
> only Fat availible.

I think we assume that link() is available on Unix systems, and that
probably doesn't work on FAT :-(.  Need to find yourself a real Unix
file system.

(I'm pretty sure we don't support FAT on Windows, either...)

            regards, tom lane

Thanks a lot,

I converted the filesystem to ext2 ..... works fine :-)

regards, Jonny Rabovsky



Tom Lane schrieb:
> Jonny Rabovsky <jonny@rabovsky.de> writes:
>
>> I have a little trouble with running Postgress on a embedded linux with
>> only Fat availible.
>>
>
> I think we assume that link() is available on Unix systems, and that
> probably doesn't work on FAT :-(.  Need to find yourself a real Unix
> file system.
>
> (I'm pretty sure we don't support FAT on Windows, either...)
>
>             regards, tom lane
>