我是 PostgreSQL 新手,在开始使用时遇到了很多问题。出于某种原因,当我尝试创建新数据库时,服务器崩溃并且无法重新启动。我做错了什么,如何解决这种情况?我还在使用安装在 Windows 10 操作系统上的 Ubuntu 18.04。
我一直在关注这个教程:https://www3.ntu.edu.sg/home/ehchua/programming/sql/PostgreSQL_GetStarted.html
事情是这样的:
postgres=# CREATE DATABASE courtney;
WARNING: terminating connection because of crash of another server process
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.
HINT: In a moment you should be able to reconnect to the database and repeat your command.
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!> \q
尝试重新启动时:
$ sudo service postgresql start
* Starting PostgreSQL 10 database server * Error: /usr/lib/postgresql/10/bin/pg_ctl /usr/lib/postgresql/10/bin/pg_ctl start -D /var/lib/postgresql/10/main -l /var/log/postgresql/postgresql-10-main.log -s -o -c config_file="/etc/postgresql/10/main/postgresql.conf" exited with status 1:
2019-05-05 13:03:27.879 DST [2502] LOG: listening on IPv4 address "127.0.0.1", port 5432
2019-05-05 13:03:27.973 DST [2502] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2019-05-05 13:03:28.189 DST [2503] LOG: database system was interrupted; last known up at 2019-05-05 11:18:20 DST
2019-05-05 13:03:28.189 DST [2503] PANIC: could not flush dirty data: Function not implemented
2019-05-05 13:03:28.189 DST [2502] LOG: startup process (PID 2503) was terminated by signal 6: Aborted
2019-05-05 13:03:28.189 DST [2502] LOG: aborting startup due to startup process failure
2019-05-05 13:03:28.204 DST [2502] LOG: database system is shut down
pg_ctl: could not start server
Examine the log output.