postgresql13 for window 搭建及备份还原数据
安装
-
下载 win x86-64
https://www.enterprisedb.com/download-postgresql-binaries -
初始化
C:\install\postgres\pgsql\bin\initdb.exe -D C:\install\postgres\pgsql\data -E UTF8 -
启动服务
C:\install\postgres\pgsql\bin\pg_ctl -D C:\install\postgres\pgsql\data -l logfile.log start -
查看进程是否启动
netstat -aon | findstr 5432 -
登入
C:\install\postgres\pgsql\bin\psql.exe postgres -
查看所有数据库
\l -
修改连接参数及work大小
-
打开
C:\install\postgres\pgsql\data\postgresql.auto.conf
-
添加
# Do not edit this file manually! # It will be overwritten by the ALTER SYSTEM command. listen_addresses=‘*‘ max_connections=1000 statement_timeout=1800000 idle_in_transaction_session_timeout=600000 max_parallel_workers=8 max_parallel_workers_per_gather=6
-
注意: 修改配置参数后简易重启数据库
备份
- 命令
C:\install\postgres\pgsql\bin\pg_dumpall > D:\db\backup\pg_all_test.sql
恢复
- 命令
C:\install\postgres\pgsql\bin\psql -f D:\db\backup\pg_all_test.sql postgres
DB操作命令
-
停止
C:\install\postgres\pgsql\bin\pg_ctl -D C:\install\postgres\pgsql\data -l logfile.log stop -
启动
C:\install\postgres\pgsql\bin\pg_ctl -D C:\install\postgres\pgsql\data -l logfile.log start -
重载
C:\install\postgres\pgsql\bin\pg_ctl -D C:\install\postgres\pgsql\data -l logfile.log reload