Re: emergency outage requiring database restart

Merlin Moncure wrote:

> single user mode dumps core :(
> 
> bash-4.1$ postgres --single -D /var/lib/pgsql/9.5/data castaging
> LOG:  00000: could not change directory to "/root": Permission denied
> LOCATION:  resolve_symlinks, exec.c:293
> Segmentation fault (core dumped)
> 
> Core was generated by `postgres --single -D /var/lib/pgsql/9.5/data castaging'.
> Program terminated with signal 11, Segmentation fault.
> #0  0x0000000000797d6f in ?? ()
> Missing separate debuginfos, use: debuginfo-install
> postgresql95-server-9.5.2-1PGDG.rhel6.x86_64
> (gdb) bt
> #0  0x0000000000797d6f in ?? ()
> #1  0x000000000079acf1 in RelationCacheInitializePhase3 ()
> #2  0x00000000007b35c5 in InitPostgres ()
> #3  0x00000000006b9b53 in PostgresMain ()
> #4  0x00000000005f30fb in main ()

Maybe rm global/pg_internal.init
and try again?

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services