Bhushan Pathak <bhushan.pathak02@xxxxxxxxx> 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
