Bug#101177: postgresql: Postgres died, won't restart -- another case

[Ken Harris]

Package: postgresql
Version: 7.1.3-4

I'm seeing something similar here. Postgres died while a program
was dumping data into it, and I can't restart it. I'm getting

/usr/lib/postgresql/bin/postmaster: Startup proc 10178 exited with status 11 - abort

in /var/log/postgres.log (11 = segfault?).

It was asked if 7.1.3-4 cures this; I'm already using 7.1.3-4.

It was said Postgres creates a 16-20MB file on startup; I have 1.0GB free.
(Is this startup file size dependent on the database size?)

-- System Information
Debian Release: testing/unstable
Architecture: i386
Kernel: Linux picea 2.4.12 #2 Thu Nov 1 13:01:34 EST 2001 i686
Locale: LANG=C, LC_CTYPE=

Versions of packages postgresql depends on:
ii adduser 3.42 Add and remove users and groups to
ii debianutils 1.15 Miscellaneous utilities specific t
ii libc6 2.2.4-5 GNU C Library: Shared libraries an
ii libpgsql2.1 7.1.3-4 Shared library libpq.so.2.1 for Po
ii libreadline4 4.2-5 GNU readline and history libraries
ii libssl0.9.6 0.9.6b-2 SSL shared libraries
ii postgresql-client 7.1.3-4 Front-end programs for PostgreSQL
ii procps 1:2.0.7-8 The /proc file system utilities.
ii zlib1g 1:1.1.3-16 compression library - runtime

--
To UNSUBSCRIBE, email to debian-bugs-...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listm...@lists.debian.org

[Oliver Elphick]

Ken Harris wrote:
>Package: postgresql
>Version: 7.1.3-4
>
>I'm seeing something similar here. Postgres died while a program
>was dumping data into it, and I can't restart it. I'm getting
>
> /usr/lib/postgresql/bin/postmaster: Startup proc 10178 exited with status
> 11 - abort
>
>in /var/log/postgres.log (11 = segfault?).

Signal 11 is segfault; exit status 11 is different.

>It was asked if 7.1.3-4 cures this; I'm already using 7.1.3-4.
>
>It was said Postgres creates a 16-20MB file on startup; I have 1.0GB free.
>(Is this startup file size dependent on the database size?)

No. Your problem does not sound like lack of disk space (I recently had
that and that gives an exit status of 512).

Is there anything in the logs? If not, set debug_level = 2 in
/etc/postgresql/postgresql.conf and try again.

--
Oliver Elphick Oliver....@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C

"Lo, children are an heritage of the LORD; and the
fruit of the womb is his reward." Psalms 127:3