這篇文章主要講解了“PostgreSQL數據庫啟動時socket存儲目錄的配置是什么”,文中的講解內容簡單清晰,易于學習與理解,下面請大家跟著小編的思路慢慢深入,一起來研究和學習“PostgreSQL數據庫啟動時socket存儲目錄的配置是什么”吧!
創新互聯專注于達坂城網站建設服務及定制,我們擁有豐富的企業做網站經驗。 熱誠為您提供達坂城營銷型網站建設,達坂城網站制作、達坂城網頁設計、達坂城網站官網定制、微信平臺小程序開發服務,打造達坂城網絡公司原創品牌,更為您提供達坂城網站排名全網營銷落地服務。unix_socket_directories參數默認為/tmp,由于該目錄是臨時目錄,以免誤操作,一般設置在其他目錄中。
下面把unix_socket_directories設置為/data/pg12,重新啟動
[pg12@localhost pg120db]$ grep 'unix' postgresql.conf unix_socket_directories = '/data/pg12' # comma-separated list of directories #unix_socket_directories = '/tmp' # comma-separated list of directories #unix_socket_group = '' # (change requires restart) #unix_socket_permissions = 0777 # begin with 0 to use octal notation [pg12@localhost pg120db]$ [pg12@localhost pg120db]$ pg_ctl restart pg_ctl: PID file "/data/pgsql/pg120db/postmaster.pid" does not exist Is server running? trying to start server anyway waiting for server to start....2019-11-18 18:17:35.123 CST [15542] LOG: starting PostgreSQL 12.0 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-16), 64-bit 2019-11-18 18:17:35.123 CST [15542] LOG: listening on IPv4 address "0.0.0.0", port 5432 2019-11-18 18:17:35.123 CST [15542] LOG: listening on IPv6 address "::", port 5432 2019-11-18 18:17:35.155 CST [15542] LOG: listening on Unix socket "/data/pg12/.s.PGSQL.5432" 2019-11-18 18:17:35.237 CST [15542] LOG: redirecting log output to logging collector process 2019-11-18 18:17:35.237 CST [15542] HINT: Future log output will appear in directory "pg_log". done server started
嘗試連接數據庫
[pg12@localhost pg120db]$ psql -d testdb psql: error: could not connect to server: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
提示找不到socket(默認在/tmp下),可使用指定主機&端口連接
但這樣的連接方式不是本地連接
[pg12@localhost ~]$ netstat -anpo|grep psql (Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.) tcp6 0 0 ::1:52206 ::1:5432 ESTABLISHED 16200/psql keepalive (7207.79/0/0)
設置參數PGHOST,使用本地連接(PGHOST behaves the same as the host connection parameter.)
[pg12@localhost pg120db]$ export PGHOST=/data/pg12 [pg12@localhost pg120db]$ psql -d testdb Expanded display is used automatically. psql (12.0) Type "help" for help. ... [pg12@localhost ~]$ netstat -anpo|grep psql (Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.) unix 3 [ ] STREAM CONNECTED 876042 15681/psql [pg12@localhost ~]$
或者使用-h指定為socket所在目錄
[pg12@localhost ~]$ psql -h /data/pg12 Expanded display is used automatically. psql (12.0) Type "help" for help. [local:/data/pg12]:5432 pg12@testdb=# ... [pg12@localhost ~]$ netstat -anpo|grep psql (Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.) unix 3 [ ] STREAM CONNECTED 880596 16309/psql [pg12@localhost ~]$
感謝各位的閱讀,以上就是“PostgreSQL數據庫啟動時socket存儲目錄的配置是什么”的內容了,經過本文的學習后,相信大家對PostgreSQL數據庫啟動時socket存儲目錄的配置是什么這一問題有了更深刻的體會,具體使用情況還需要大家實踐驗證。這里是創新互聯,小編將為大家推送更多相關知識點的文章,歡迎關注!
文章名稱:PostgreSQL數據庫啟動時socket存儲目錄的配置是什么-創新互聯
文章鏈接:http://m.newbst.com/article32/dchepc.html
成都網站建設公司_創新互聯,為您提供ChatGPT、網站設計公司、營銷型網站建設、軟件開發、域名注冊、網站導航
聲明:本網站發布的內容(圖片、視頻和文字)以用戶投稿、用戶轉載內容為主,如果涉及侵權請盡快告知,我們將會在第一時間刪除。文章觀點不代表本網站立場,如需處理請聯系客服。電話:028-86922220;郵箱:631063699@qq.com。內容未經允許不得轉載,或轉載時需注明來源: 創新互聯