详细介绍PostgreSQL数据库操作:C:\Users\Administrator>E:
E:\>D:
D:\>cd Tools
D:\Tools>cd PostgreSQL
D:\Tools\PostgreSQL>cd 17
D:\Tools\PostgreSQL\17>cd bin
D:\Tools\PostgreSQL\17\bin>dir
Volume in drive D is DATA
Volume Serial Number is CC36-E072
Directory of D:\Tools\PostgreSQL\17\bin
06/30/2025 02:45 PM <DIR> .
06/30/2025 02:50 PM <DIR> ..
05/07/2025 02:33 PM 132,608 clusterdb.exe
05/07/2025 02:33 PM 131,584 createdb.exe
05/07/2025 02:33 PM 136,192 createuser.exe
05/07/2025 02:33 PM 130,560 dropdb.exe
05/07/2025 02:33 PM 130,048 dropuser.exe
05/07/2025 02:33 PM 1,001,472 ecpg.exe
05/07/2025 02:33 PM 28,399,104 icudt67.dll
05/07/2025 02:33 PM 2,674,176 icuin67.dll
05/07/2025 02:33 PM 61,440 icuio67.dll
05/07/2025 02:33 PM 220,672 icutu67.dll
05/07/2025 02:33 PM 1,906,688 icuuc67.dll
05/07/2025 02:33 PM 243,200 initdb.exe
05/07/2025 02:33 PM 4,696,576 libcrypto-3-x64.dll
05/07/2025 02:33 PM 626,688 libcurl.dll
05/07/2025 02:33 PM 21,338 libcurl.lib
05/07/2025 02:33 PM 102,400 libecpg.dll
05/07/2025 02:33 PM 25,088 libecpg_compat.dll
05/07/2025 02:33 PM 1,850,401 libiconv-2.dll
05/07/2025 02:33 PM 475,769 libintl-9.dll
05/07/2025 02:33 PM 128,000 liblz4.dll
05/07/2025 02:33 PM 86,016 libpgtypes.dll
05/07/2025 02:33 PM 351,744 libpq.dll
05/07/2025 02:33 PM 779,776 libssl-3-x64.dll
05/07/2025 02:33 PM 52,736 libwinpthread-1.dll
05/07/2025 02:33 PM 2,112,000 libxml2.dll
05/07/2025 02:33 PM 413,696 libxslt.dll
05/07/2025 02:33 PM 727,552 libzstd.dll
05/07/2025 02:33 PM 81,920 oid2name.exe
05/07/2025 02:33 PM 256,000 pgbench.exe
05/07/2025 02:33 PM 162,304 pg_amcheck.exe
05/07/2025 02:33 PM 92,672 pg_archivecleanup.exe
05/07/2025 02:33 PM 295,936 pg_basebackup.exe
05/07/2025 02:33 PM 128,000 pg_checksums.exe
05/07/2025 02:33 PM 196,096 pg_combinebackup.exe
05/07/2025 02:33 PM 87,552 pg_config.exe
05/07/2025 02:33 PM 103,936 pg_controldata.exe
05/07/2025 02:33 PM 169,472 pg_createsubscriber.exe
05/07/2025 02:33 PM 129,536 pg_ctl.exe
05/07/2025 02:33 PM 601,088 pg_dump.exe
05/07/2025 02:33 PM 189,440 pg_dumpall.exe
05/07/2025 02:33 PM 90,112 pg_isready.exe
05/07/2025 02:33 PM 225,280 pg_receivewal.exe
05/07/2025 02:33 PM 110,080 pg_recvlogical.exe
05/07/2025 02:33 PM 122,368 pg_resetwal.exe
05/07/2025 02:33 PM 355,328 pg_restore.exe
05/07/2025 02:33 PM 225,792 pg_rewind.exe
05/07/2025 02:33 PM 98,304 pg_test_fsync.exe
05/07/2025 02:33 PM 86,528 pg_test_timing.exe
05/07/2025 02:33 PM 247,296 pg_upgrade.exe
05/07/2025 02:33 PM 154,112 pg_verifybackup.exe
05/07/2025 02:33 PM 161,792 pg_waldump.exe
05/07/2025 02:33 PM 113,664 pg_walsummary.exe
05/07/2025 02:33 PM 9,913,344 postgres.exe
05/07/2025 02:33 PM 628,736 psql.exe
05/07/2025 02:33 PM 143,360 reindexdb.exe
05/07/2025 02:33 PM 435,920 stackbuilder.exe
05/07/2025 02:33 PM 10,752 testplug.dll
05/07/2025 02:33 PM 146,944 vacuumdb.exe
05/07/2025 02:33 PM 81,408 vacuumlo.exe
05/07/2025 02:33 PM 257,536 wxbase328u_net_vc_x64_custom.dll
05/07/2025 02:33 PM 2,963,968 wxbase328u_vc_x64_custom.dll
05/07/2025 02:33 PM 193,024 wxbase328u_xml_vc_x64_custom.dll
05/07/2025 02:33 PM 11,264 wxmsw328u_adv_vc_x64_custom.dll
05/07/2025 02:33 PM 594,944 wxmsw328u_aui_vc_x64_custom.dll
05/07/2025 02:33 PM 8,295,424 wxmsw328u_core_vc_x64_custom.dll
05/07/2025 02:33 PM 708,096 wxmsw328u_html_vc_x64_custom.dll
05/07/2025 02:33 PM 886,784 wxmsw328u_xrc_vc_x64_custom.dll
05/07/2025 02:33 PM 91,136 zlib1.dll
68 File(s) 77,464,772 bytes
2 Dir(s) 589,092,765,696 bytes free
D:\Tools\PostgreSQL\17\bin>pg_ctl.exe start -D "D:\Tools\PostgreSQL\17\data"
waiting for server to start....2025-06-30 08:58:18.644 GMT [9764] LOG: syntax error in file "D:/Tools/PostgreSQL/17/data/postgresql.conf" line 281, near end of line
2025-06-30 08:58:18.644 GMT [9764] FATAL: configuration file "D:/Tools/PostgreSQL/17/data/postgresql.conf" contains errors
stopped waiting
pg_ctl: could not start server
Examine the log output.
D:\Tools\PostgreSQL\17\bin>pg_ctl.exe start -D "D:\Tools\PostgreSQL\17\data"
waiting for server to start....2025-06-30 16:59:57 CST LOG: redirecting log output to logging collector process
2025-06-30 16:59:57 CST HINT: Future log output will appear in directory "log".
1 file(s) copied.
done
server started
D:\Tools\PostgreSQL\17\bin>pg_ctl.exe status -D "D:\Tools\PostgreSQL\17\data"
pg_ctl: no server running
D:\Tools\PostgreSQL\17\bin>pg_ctl.exe status -D "D:\Tools\PostgreSQL\17\data"
pg_ctl: server is running (PID: 16288)
D:/Tools/PostgreSQL/17/bin/postgres.exe "-D" "D:\Tools\PostgreSQL\17\data"
D:\Tools\PostgreSQL\17\bin>pg_ctl.exe start -D "D:\Tools\PostgreSQL\17\data"
waiting for server to start....2025-06-30 17:13:06 CST LOG: redirecting log output to logging collector process
2025-06-30 17:13:06 CST HINT: Future log output will appear in directory "log".
done
server started
D:\Tools\PostgreSQL\17\bin>pg_ctl.exe status -D "D:\Tools\PostgreSQL\17\data"
pg_ctl: server is running (PID: 19608)
D:/Tools/PostgreSQL/17/bin/postgres.exe "-D" "D:/Tools/PostgreSQL/17/data"
D:\Tools\PostgreSQL\17\bin> 1 file(s) copied.
最新发布