{"id":178,"date":"2025-02-16T19:25:40","date_gmt":"2025-02-16T11:25:40","guid":{"rendered":"http:\/\/113.45.254.23\/?p=178"},"modified":"2025-02-16T19:25:41","modified_gmt":"2025-02-16T11:25:41","slug":"%e5%ae%89%e8%a3%85pgadmin-4-postgresql%e7%ae%a1%e7%90%86%e5%b7%a5%e5%85%b7","status":"publish","type":"post","link":"http:\/\/113.45.254.23\/?p=178","title":{"rendered":"\u5b89\u88c5pgAdmin 4 PostgreSQL\u7ba1\u7406\u5de5\u5177"},"content":{"rendered":"\n

\u601d\u7ef4\u5bfc\u56fe<\/p>\n\n\n\n

\"\"<\/div><\/figure>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n

root@server10:~# curl https:\/\/www.postgresql.org\/media\/keys\/ACCC4CF8.asc | gpg –dearmor | sudo tee \/usr\/share\/keyrings\/postgresql-key.gpg >\/dev\/null \u4e0b\u8f7dpostgresql\u6570\u636e\u5e93\u7684gpg\u7684\u5bc6\u94a5<\/p>\n\n\n\n

  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current<\/p>\n\n\n\n

                                 Dload  Upload   Total   Spent    Left  Speed<\/p>\n\n\n\n

100  4812  100  4812    0     0   3034      0  0:00:01  0:00:01 –:–:–  3034<\/p>\n\n\n\n

root@server10:~#<\/p>\n\n\n\n

sudo sh -c ‘echo “deb [signed-by=\/usr\/share\/keyrings\/postgresql-key.gpg arch=amd64] http:\/\/apt.postgresql.org\/pub\/repos\/apt $(lsb_release -cs)-pgdg main” > \/etc\/apt\/sources.list.d\/pgdg.list’   <\/p>\n\n\n\n

\u5c06postgresql\u5b58\u50a8\u5e93\u6dfb\u52a0\u5230ubuntu24.04\u7cfb\u7edf\u4e2d<\/p>\n\n\n\n

root@server10:~# curl -fsSL https:\/\/www.pgadmin.org\/static\/packages_pgadmin_org.pub | sudo gpg –dearmor -o \/usr\/share\/keyrings\/pgadmin4.gpg<\/p>\n\n\n\n

\u4e0b\u8f7dpgadmin4\u5b58\u50a8\u5e93gpg\u7684\u5bc6\u94a5<\/p>\n\n\n\n

File ‘\/usr\/share\/keyrings\/pgadmin4.gpg’ exists. Overwrite? (y\/N) y<\/p>\n\n\n\n

root@server10:~#<\/p>\n\n\n\n

root@server10:~# sudo echo “deb [arch=amd64 signed-by=\/usr\/share\/keyrings\/pgadmin4.gpg] https:\/\/ftp.postgresql.org\/pub\/pgadmin\/pgadmin4\/apt\/$(lsb_release -cs) pgadmin4 main”\\<\/p>\n\n\n\n

| sudo tee \/etc\/apt\/sources.list.d\/pgadmin4.list                                                  \u5c06pgadmin4\u6dfb\u52a0\u5230ubuntu\u7cfb\u7edf\u4e2d<\/p>\n\n\n\n

deb [arch=amd64 signed-by=\/usr\/share\/keyrings\/pgadmin4.gpg] https:\/\/ftp.postgresql.org\/pub\/pgadmin\/pgadmin4\/apt\/noble pgadmin4 main<\/p>\n\n\n\n

root@server10:~#<\/p>\n\n\n\n

root@server10:~# apt update \u66f4\u65b0\u6570\u636e\u6e90<\/p>\n\n\n\n

\"\"<\/div><\/figure>\n\n\n\n

root@server10:~# apt install pgadmin4-web    \u5b89\u88c5pgadmin4-web\u5ba2\u6237\u7aef<\/p>\n\n\n\n

\"\"<\/div><\/figure>\n\n\n\n

root@server100:~# apt install postgresql postgresql-contrib \u5b89\u88c5postgresql\u6570\u636e\u5e93<\/p>\n\n\n\n

\"\"<\/div><\/figure>\n\n\n\n

root@server100:~# systemctl is-enabled postgresql \u91cd\u542fpostgresql\u6570\u636e\u5e93\uff0c\u5e76\u8bbe\u7f6e\uff08Ubuntu\u7cfb\u7edf\uff09\u5f00\u673a\u542f\u52a8<\/p>\n\n\n\n

enabled<\/p>\n\n\n\n

root@server100:~# systemctl status postgresql \u67e5\u770bpostgresql\u6570\u636e\u5e93\u7684\u72b6\u6001<\/p>\n\n\n\n

\u25cf postgresql.service – PostgreSQL RDBMS<\/p>\n\n\n\n

     Loaded: loaded (\/usr\/lib\/systemd\/system\/postgresql.service; enabled; preset: enabled)<\/p>\n\n\n\n

     Active: active (exited) since Mon 2025-02-10 09:54:11 CST; 34s ago<\/p>\n\n\n\n

   Main PID: 11615 (code=exited, status=0\/SUCCESS)<\/p>\n\n\n\n

        CPU: 1ms<\/p>\n\n\n\n

Feb 10 09:54:11 server100 systemd[1]: Starting postgresql.service – PostgreSQL RDBMS…<\/p>\n\n\n\n

Feb 10 09:54:11 server100 systemd[1]: Finished postgresql.service – PostgreSQL RDBMS.<\/p>\n\n\n\n

root@server100:~#<\/p>\n\n\n\n

root@server100:~#<\/p>\n\n\n\n

root@server100:~# sudo -u postgres psql \u767b\u5f55postgresql\u6570\u636e\u5e93<\/p>\n\n\n\n

psql (17.2 (Ubuntu 17.2-1.pgdg24.04+1))<\/p>\n\n\n\n

Type “help” for help.<\/p>\n\n\n\n

postgres=# CREATE role alice WITH SUPERUSER CREATEROLE LOGIN ENCRYPTED PASSWORD ‘alicepassword’;<\/p>\n\n\n\n

\u521b\u5efaalice\u89d2\u8272\uff0c\u5e76\u8bbe\u7f6e\u6210\u8d85\u7ea7\u7528\u6237\uff1b\u521b\u5efa\u89d2\u8272\u7684\u767b\u5f55\u52a0\u5bc6\u5bc6\u7801\u4e3aalicepassword<\/p>\n\n\n\n

CREATE ROLE<\/p>\n\n\n\n

postgres=# \\du \u67e5\u8be2\u6570\u636e\u5e93\u7684\u7528\u6237\u5217\u8868<\/p>\n\n\n\n

                             List of roles<\/p>\n\n\n\n

 Role name |                         Attributes                         <\/p>\n\n\n\n

———–+————————————————————<\/p>\n\n\n\n

 alice     | Superuser, Create role<\/p>\n\n\n\n

 postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS<\/p>\n\n\n\n

postgres=# CREATE DATABASE alice; \u521b\u5efaalice\u6570\u636e\u5e93<\/p>\n\n\n\n

CREATE DATABASE<\/p>\n\n\n\n

postgres=# GRANT ALL PRIVILEGES ON DATABASE alice TO alice; \u5c06alice\u6570\u636e\u5e93\u5168\u90e8\u6388\u6743\u7ed9alice\u7528\u6237<\/p>\n\n\n\n

GRANT<\/p>\n\n\n\n

postgres=# \\l \u67e5\u770b\u5217\u8868<\/p>\n\n\n\n

postgres=# \\q \u9000\u51fa\uff08\u4e13\u7528\u8bed\u6cd5\uff0c\u5176\u4ed6\u6570\u636e\u5e93\u4e0d\u7528\uff09<\/p>\n\n\n\n

\"\"<\/div><\/figure>\n\n\n\n

root@server100:~# apt install pgadmin4-web                                        \u5b89\u88c5pgadmin4-web\u5ba2\u6237\u7aef<\/p>\n\n\n\n

root@server100:~# \/usr\/pgadmin4\/bin\/setup-web.sh                                     \u8fd0\u884cpgadmin\u7684\u5b89\u88c5\u811a\u672c<\/p>\n\n\n\n

Setting up pgAdmin 4 in web mode on a Debian based platform…<\/p>\n\n\n\n

Creating configuration database…<\/p>\n\n\n\n

NOTE: Configuring authentication for SERVER mode.<\/p>\n\n\n\n

\"\"<\/div><\/figure>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\"\"<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"

\u601d\u7ef4\u5bfc\u56fe root@server10:~# curl https:\/\/www.postgresql.org\/m […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[4,7],"class_list":["post-178","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-linux","tag-pgsql"],"_links":{"self":[{"href":"http:\/\/113.45.254.23\/index.php?rest_route=\/wp\/v2\/posts\/178","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/113.45.254.23\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/113.45.254.23\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/113.45.254.23\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/113.45.254.23\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=178"}],"version-history":[{"count":1,"href":"http:\/\/113.45.254.23\/index.php?rest_route=\/wp\/v2\/posts\/178\/revisions"}],"predecessor-version":[{"id":194,"href":"http:\/\/113.45.254.23\/index.php?rest_route=\/wp\/v2\/posts\/178\/revisions\/194"}],"wp:attachment":[{"href":"http:\/\/113.45.254.23\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=178"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/113.45.254.23\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=178"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/113.45.254.23\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=178"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}