1. 下载源码: PostgreSQL: File Browser
2. 编译 debug 版本:
./configure --enable-cassert --enable-debug CFLAGS="-ggdb -O0 -g3 -fno-omit-frame-pointer"
make && make install
3. 添加 postgres 用户:
adduser postgres
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su - postgres
4. 启动 postgres 程序,初始化数据库,并且登录:
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start
/usr/local/pgsql/bin/createdb test
/usr/local/pgsql/bin/psql test
psql (13.3)
Type "help" for help.
test=# select pg_backend_pid()
test-# ;
pg_backend_pid
----------------
24184
(1 row)
test=# \q
5. 关于如何登录,可以通过 psql --help 查看选项,例如 :
General options:
-c, --command=COMMAND run only single command (SQL or internal) and exit
-d, --dbname=DBNAME database name to connect to (default: "key")
-f, --file=FILENAME execute commands from file, then exit