[ADMIN] Running Postgres on a HP-Ux 10.10 System - Mailing list pgsql-admin

From Reiner Nippes
Subject [ADMIN] Running Postgres on a HP-Ux 10.10 System
Date
Msg-id 199901270918.EAA24778@hub.org
Whole thread Raw
List pgsql-admin
Hello everybody,

I trying to run PostgreSQL 6.4 (or 6.4.2) on a HP-Ux 10.10. The
problem is that the backend process is dieing after two SQL errors.
When I do the following the backend will die:

psql test
=> SALACT * FROM test;
Error ....
=> SALACT * FROM test;
Error ....

Well nobody is using a database in this way nevertheless I feel that
my something in my system is not configured the way it should be.

I tried to compile version 6.4 and 6.4.2 either with gcc 2.7.2.3 and
2.8.1. The result is the same.

The exit code of the backend process is 138.

Any help welcome.

Reiner Nippes
UMS GmbH, Ulm - Germnay

From the log file:
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
ERROR:  pg_atoi: error in "34.5": can't parse ".5"
AbortCurrentTransaction
StartTransactionCommand
query: INSERT INTO INT2_TBL(f1) VALUES ('32767');
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
query: INSERT INTO INT2_TBL(f1) VALUES ('-32767');
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
ERROR:  pg_atoi: error reading "100000": Result too large
AbortCurrentTransaction
/data/app/postgres/bin/postmaster: reaping dead processes...
/data/app/postgres/bin/postmaster: CleanupProc: pid 17725 exited with status 138
/data/app/postgres/bin/postmaster: CleanupProc: reinitializing shared memory and semaphores
shmem_exit(0) [#0]

pgsql-admin by date:

Previous
From: Dmitry Pletnev
Date:
Subject: initdb - segmentation failed
Next
From: "Oliver Elphick"
Date:
Subject: Re: [ADMIN] configuring pg_hba.conf...