Re: PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb - Mailing list pgsql-general

From Bhushan Pathak
Subject Re: PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb
Date
Msg-id CAHJHQJ5BboLZAZtGveDOvOi8WM28dzzLVxxFGQ35yHvDL9BZLA@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb
Re: PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb
List pgsql-general

I do not have any earlier versions of postgres installed, neither a parallel instance running. In the pgstartup.log file, only the segfault error is recorded, nothing else.

I have downloaded the following RPMs from http://yum.postgresql.org/9.2/redhat/rhel-5.6-x86_64/

postgresql92-9.2.4-1PGDG.rhel5.x86_64.rpm          
postgresql92-libs-9.2.4-1PGDG.rhel5.x86_64.rpm
postgresql92-contrib-9.2.4-1PGDG.rhel5.x86_64.rpm  
postgresql92-server-9.2.4-1PGDG.rhel5.x86_64.rpm

A core file was not generated. I will try with adding the ulimit command to the service script. Attached is the service script.

Thanks
Bhushan Pathak

On Fri, Jun 6, 2014 at 8:09 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Bhushan Pathak <bhushan.pathak02@gmail.com> writes:
>>> Stopping postgresql service:                              [  OK  ]
>>> Starting postgresql service:                              [FAILED]
>>>
>>> pgstartup log has the same line  -
>>> Segmentation fault (core dumped)
>>>
>>> Where is this core dump file generated? How do we proceed further from
>>> here?

FWIW, I'd expect any such core to be generated either in postgres'
home directory or the $PGDATA directory, depending on what is
failing when.  If you don't see a core, it's likely because the failing
program is running under "ulimit -c 0", which is the default environment
for daemons (for security reasons).  Try adding "ulimit -c unlimited"
to the start script and/or the postgres user's ~/.bash_profile to see
if you can get a core file for debugging.

The issue seems like it must trace back to some difference in the
normal shell environment of the postgres user versus the environment
set up by "service" ... but it's not clear yet what that difference
is.

Also, it's not very clear whether you're trying to use the Red Hat/CentOS
packaging of PG, or the PGDG packaging.  As Adrian alluded to, those are
not terribly compatible --- if you've got fragments of both laying about,
that could be causing issues.

                        regards, tom lane

Attachment

pgsql-general by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Trigger to convert UNIX time to timestamp without time zone.
Next
From: Devrim Gündüz
Date:
Subject: Re: PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb