PostgreSQL 11.0 删除操作 Segmentation fault 解决方案

 12020-03-25 02:30:59.813 UTC [1] LOG:  server process (PID 89) was terminated by signal 11: Segmentation fault
 22020-03-25 02:30:59.813 UTC [1] DETAIL:  Failed process was running: DELETE FROM a;
 32020-03-25 02:30:59.815 UTC [1] LOG:  terminating any other active server processes
 42020-03-25 02:30:59.817 UTC [74] WARNING:  terminating connection because of crash of another server process
 52020-03-25 02:30:59.817 UTC [74] DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
 62020-03-25 02:30:59.817 UTC [74] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
 72020-03-25 02:30:59.833 UTC [1] LOG:  all server processes terminated; reinitializing
 82020-03-25 02:30:59.861 UTC [91] LOG:  database system was interrupted; last known up at 2020-03-25 02:30:49 UTC
 92020-03-25 02:31:00.032 UTC [91] LOG:  database system was not properly shut down; automatic recovery in progress
102020-03-25 02:31:00.036 UTC [91] LOG:  redo starts at 0/1652540

1VACUUM FULL ANALYZE; 

 1CREATE TABLE a (
 2     id bigint
 3);
 4
 5INSERT INTO a (id) VALUES (1); 
 6
 7ALTER TABLE ONLY a ADD CONSTRAINT a_pkey PRIMARY KEY (id);
 8
 9CREATE TABLE b (
10     a_id bigint
11);
12
13ALTER TABLE ONLY b ADD CONSTRAINT b_a_id_fkey FOREIGN KEY (a_id) REFERENCES a(id);
14
15ALTER TABLE a ADD x BOOLEAN NOT NULL DEFAULT FALSE; 

1root=# DELETE FROM a;
2server closed the connection unexpectedly
3	This probably means the server terminated abnormally
4	before or while processing the request.
5The connection to the server was lost. Attempting reset: Failed.