\u73af\u5883\uff1a
\n\u5728macOS Catalina 10.15.6\u4e0a\u8fdb\u884c\u786e\u8ba4\uff0c\u8fdb\u884c\u6587\u7ae0\u91cd\u5199\u3002
\nDocker\u7248\u672c19.03.8\uff0c\u6784\u5efa\u7248\u672cafacb8b\u3002
\n\u5728macOS\u4e0a\uff0c\u4f7f\u7528\u7684\u662fzsh\u4f5c\u4e3ashell\uff0c\u4f46\u4e3b\u673a\u7aef\u7684\u63d0\u793a\u7b26\u5199\u4f5c\u201c\uff04\u201d\u3002<\/p>\n
\u5728\u5f53\u524d\u76ee\u5f55\u4e0b\u521b\u5efa\u4e00\u4e2a\u540d\u4e3avols\u7684\u6587\u4ef6\u5939\u3002<\/p>\n
mkdir ${PWD}\/vols\r\n<\/code><\/pre>\n\u542f\u52a8\u5bb9\u5668<\/h3>\n\n- \n
Container name pg_docker<\/ul>\n<\/li>\n<\/ul>\n <\/p>\n
\n- \n
\u30d1\u30b9\u30ef\u30fc\u30c9\u8a2d\u5b9a postgres POSTGRES_PASSWORD=postgres<\/ul>\n<\/li>\n<\/ul>\n <\/p>\n
\n- \n
\u30dd\u30fc\u30c8 host port:container port 5432:5432<\/ul>\n<\/li>\n<\/ul>\n <\/p>\n
\n- \n
volume\u3092\u30de\u30a6\u30f3\u30c8 $PWD\/vols:\/var\/lib\/postgresql\/<\/ul>\n<\/li>\n<\/ul>\n\u30ab\u30ec\u30f3\u30c8\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306evols\u306bdocker\u306epostgresql\u3092\u30de\u30a6\u30f3\u30c8<\/p>\n
docker run --rm --name pg-docker -e POSTGRES_PASSWORD=postgres -d -p 5432:5432 -v $PWD\/vols:\/var\/lib\/postgresql\/data postgres\r\n<\/code><\/pre>\n\u786e\u8ba4\u5bb9\u5668<\/h3>\n$ docker container ls\r\nCONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES\r\n7dc570e3835c postgres \"docker-entrypoint.s\u2026\" 16 hours ago Up 16 hours 0.0.0.0:5432->5432\/tcp pg-docker\r\n<\/code><\/pre>\n\u5728Container NAME\u4e2d\uff0c\u4f7f\u7528shell\u8fde\u63a5\u5230Container\u3002<\/h3>\n\n- \n
container\u306b\u63a5\u7d9a\u3001Shell\u3092\u7acb\u3061\u4e0a\u3052\u308b docker exec \u30b3\u30f3\u30c6\u30ca\u306b\u5165\u308b\u3068\u30d7\u30ed\u30f3\u30d7\u30c8\u304c\u5909\u308f\u308a\u307e\u3059<\/ul>\n<\/li>\n<\/ul>\n-it \u30a4\u30f3\u30bf\u30fc\u30e9\u30af\u30c6\u30a3\u30d6 tty\u3092\u6307\u5b9a
\n\/bin\/bash\u3000\u3000bash\u3092\u7acb\u3061\u4e0a\u3052\u308b<\/p>\n
postgres\u30e6\u30fc\u30b6\u30fc\u306b\u306a\u308b su – postgres\u3000\u3000\u307e\u305f\u3001\u30d7\u30ed\u30f3\u30d7\u30c8\u304c\u5909\u308f\u308a\u307e\u3059
\n\u4e00\u89a7\u3092\u8868\u793a\u3059\u308b psql -l<\/p>\n
$ docker container exec -it pg-docker \/bin\/bash\r\nroot@db8619e414e8:\/# su - postgres\r\npostgres@db8619e414e8:~$ psql -l \r\n List of databases\r\n Name | Owner | Encoding | Collate | Ctype | Access privileges \r\n-----------+----------+----------+------------+------------+-----------------------\r\n postgres | postgres | UTF8 | en_US.utf8 | en_US.utf8 | \r\n template0 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c\/postgres +\r\n | | | | | postgres=CTc\/postgres\r\n template1 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c\/postgres +\r\n | | | | | postgres=CTc\/postgres\r\n(3 rows)\r\n\r\n<\/code><\/pre>\n\u4f7f\u7528createdb\u547d\u4ee4\u521b\u5efa\u540d\u4e3amydb\u7684\u6570\u636e\u5e93\uff0c\u6784\u9020CREATE\u8bed\u53e5\u3002<\/p>\n
mydb=# CREATE TABLE weather (\r\n id serial,\r\n day date not null,\r\n city varchar(80) not null,\r\n temp_max numeric not null, -- \u6700\u4f4e\u6c17\u6e29\r\n temp_min numeric not null, -- \u6700\u9ad8\u6c17\u6e29\r\n wind real,\r\n PRIMARY KEY (id)\r\n);\r\n<\/code><\/pre>\n\u7528psql\u767b\u5f55\u5230mydb\u6570\u636e\u5e93\u5e76\u521b\u5efa\u8868\u683c<\/h3>\n\n- \n
\u4f7f\u7528psql\u8fdb\u5165\u540d\u4e3amydb\u7684\u6570\u636e\u5e93<\/ol>\n<\/li>\n<\/ol>\n <\/p>\n
\n- \n
\u521b\u5efaweather\u8868 CREATE TABLE<\/ol>\n<\/li>\n<\/ol>\n <\/p>\n
\n- \n
\u67e5\u770bweather\u8868\u7684\u5b9a\u4e49 \\d \u8868\u540d<\/ol>\n<\/li>\n<\/ol>\n <\/p>\n
\n- \n
\u63d2\u5165\u6570\u636e INSERT INTO<\/ol>\n<\/li>\n<\/ol>\n <\/p>\n
\n- \n
\u67e5\u770b\u6570\u636e SELECT<\/ol>\n<\/li>\n<\/ol>\n <\/p>\n
\n- \n
\u9000\u51fapsql \\q<\/ol>\n<\/li>\n<\/ol>\n <\/p>\n
\n- \n
\u9000\u51fapostgres\u7528\u6237 exit<\/ol>\n<\/li>\n<\/ol>\n <\/p>\n
\u9000\u51fadocker\u5bb9\u5668 exit<\/ol>\n\u5929\u6c14\u8868\u5b9a\u4e49
\nid\u5217 \u662f\u5e8f\u5217\u578b\u7684\u4e3b\u952e
\nday\u5217 \u662f\u65e5\u671f\u578b\u7684\uff0c\u4e0d\u80fd\u4e3a\u7a7a
\ntemp_max\u5217 \u662f\u6570\u5b57\u578b\u7684\uff0c\u4e0d\u80fd\u4e3a\u7a7a
\ntemp_min\u5217 \u662f\u6570\u5b57\u578b\u7684\uff0c\u4e0d\u80fd\u4e3a\u7a7a
\nwind\u5217 \u662f\u5b9e\u6570\u578b\u7684<\/p>\n
postgres@db8619e414e8:~$ psql mydb\r\npsql (12.3 (Debian 12.3-1.pgdg100+1))\r\nType \"help\" for help.\r\n\r\nmydb=# CREATE TABLE weather (\r\nmydb(# id serial,\r\nmydb(# day date not null,\r\nmydb(# city varchar(80) not null,\r\nmydb(# temp_max numeric not null, -- \u6700\u4f4e\u6c17\u6e29\r\nmydb(# temp_min numeric not null, -- \u6700\u9ad8\u6c17\u6e29\r\nmydb(# wind real,\r\nmydb(# PRIMARY KEY (id)\r\nmydb(# );\r\nCREATE TABLE\r\nmydb=# \r\n\r\nmydb=# \\d weather\r\n Table \"public.weather\"\r\n Column | Type | Collation | Nullable | Default \r\n----------+-----------------------+-----------+----------+-------------------------------------\r\n id | integer | | not null | nextval('weather_id_seq'::regclass)\r\n day | date | | not null | \r\n city | character varying(80) | | not null | \r\n temp_max | numeric | | not null | \r\n temp_min | numeric | | not null | \r\n wind | real | | | \r\nIndexes:\r\n \"weather_pkey\" PRIMARY KEY, btree (id)\r\n\r\nmydb=# INSERT INTO weather VALUES (0,'2019-11-18', 'test',21.3,10.5,0.7);\r\nINSERT 0 1\r\nmydb=# INSERT INTO weather VALUES (1,'2020-07-18', 'test',11.3,7.5,0.7);\r\nINSERT 0 1\r\n\r\nmydb=# select * from weather;\r\n id | day | city | temp_max | temp_min | wind \r\n----+------------+------+----------+----------+------\r\n 0 | 2019-11-18 | test | 21.3 | 10.5 | 0.7\r\n 1 | 2020-07-18 | test | 11.3 | 7.5 | 0.7\r\n(2 rows)\r\n\r\n\r\npostgres@db8619e414e8:~$ exit\r\nlogout\r\nroot@db8619e414e8:\/# exit\r\nexit\r\n$ \r\n<\/code><\/pre>\n\u786e\u8ba4\u56fe\u50cf\u5e76\u505c\u6b62\u5bb9\u5668<\/h3>\n\n- \n
docker image ls \u3067\u3001\u6700\u65b0\u7248\u306epostgres lateat\u304c\u53d6\u5f97\u3055\u308c\u3066\u3044\u308b<\/ul>\n<\/li>\n<\/ul>\n <\/p>\n
\n- \n
docker container ls -a \u30b3\u30f3\u30c6\u30ca\u306e\u78ba\u8a8d\u3000STATUS\u3067\u3001Up ~~~\u3092\u78ba\u8a8d<\/ul>\n<\/li>\n<\/ul>\n <\/p>\n
\n- \n
docker container stop pg-docker\u3000\u30b3\u30f3\u30c6\u30ca\u3092\u505c\u6b62<\/ul>\n<\/li>\n<\/ul>\n <\/p>\n
\n- \n
docker container ls -a \u30b3\u30f3\u30c6\u30ca\u306e\u78ba\u8a8d\u3000\u7dba\u9e97\u306b\u7247\u3065\u3044\u3066\u3044\u308b<\/ul>\n<\/li>\n<\/ul>\nrun\u3092\u3057\u305f\u3068\u304d\u306e\u30aa\u30d7\u30b7\u30e7\u30f3 –rm \u304c\u52b9\u3044\u3066\u3044\u308b<\/p>\n
$ docker image ls\r\nREPOSITORY TAG IMAGE ID CREATED SIZE\r\npostgres latest 4b52913b0a3a 2 days ago 313MB\r\nnginx latest 0901fa9da894 2 weeks ago 132MB\r\ncentos 7 b5b4d78bc90c 2 months ago 203MB\r\n\r\n$ docker container ls -a\r\nCONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES\r\ndb8619e414e8 postgres \"docker-entrypoint.s\u2026\" About an hour ago Up About an hour 0.0.0.0:5432->5432\/tcp pg-docker\r\n\r\n$ docker container stop pg-docker\r\npg-docker\r\n\r\n$ docker container ls -a \r\nCONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES\r\n<\/code><\/pre>\n\u4f7f\u7528Python\u4e3b\u673a\u4e0eDocker\u4e2d\u7684PostgreSQL\u5efa\u7acb\u8fde\u63a5\uff0c\u5e76\u4f7f\u7528Pandas\u3002<\/h3>\n
\u8bf7\u6267\u884c\u4ee5\u4e0b\u64cd\u4f5c\u4e4b\u4e00\u4ee5\u8fdb\u884c paraphrase:
\n1. \u5728\u6267\u884c\u8fd9\u4e2a\u547d\u4ee4\u4e4b\u524d\uff0c\u8bf7\u786e\u4fdd\u505c\u6b62\u524d\u4e00\u4e2a\u5bb9\u5668\uff0c\u6216\u8005\u91cd\u65b0\u8fd0\u884c docker container run \u547d\u4ee4
\n2. \u5728\u5b89\u88c5 psycopg2 \u4e4b\u524d\uff0c\u8bf7\u786e\u4fdd\u505c\u6b62\u4e4b\u524d\u7684\u5bb9\u5668\uff0c\u6216\u8005\u518d\u6b21\u8fd0\u884c docker container run \u547d\u4ee4\u3002<\/p>\n
$<\/span> python<\/span>\r\nPython<\/span> 3.7<\/span>.<\/span>5<\/span> (<\/span>default<\/span>,<\/span> Oct<\/span> 25<\/span> 2019<\/span>,<\/span> 10<\/span>:<\/span>52<\/span>:<\/span>18<\/span>)<\/span> \r\n[<\/span>Clang<\/span> 4.0<\/span>.<\/span>1<\/span> (<\/span>tags<\/span>\/<\/span>RELEASE_401<\/span>\/<\/span>final<\/span>)]<\/span> ::<\/span> Anaconda<\/span>,<\/span> Inc<\/span>.<\/span> on<\/span> darwin<\/span>\r\nType<\/span> \"help\"<\/span>,<\/span> \"copyright\"<\/span>,<\/span> \"credits\"<\/span> or<\/span> \"license\"<\/span> for<\/span> more<\/span> information<\/span>.<\/span>\r\n>>><\/span> import<\/span> psycopg2<\/span>\r\n>>><\/span> import<\/span> pandas<\/span> as<\/span> pd<\/span>\r\n>>><\/span> # \u63a5\u7d9a\u8a2d\u5b9a\r\n<\/span>...<\/span> conn<\/span> =<\/span> psycopg2<\/span>.<\/span>connect<\/span>(<\/span>\"dbname=mydb host=localhost port=5432 user=postgres password=postgres\"<\/span>)<\/span>\r\n>>><\/span> \r\n>>><\/span> query<\/span> =<\/span> \"SELECT * FROM weather;\"<\/span>\r\n>>><\/span> df<\/span> =<\/span> pd<\/span>.<\/span>read_sql<\/span>(<\/span>sql<\/span>=<\/span>query<\/span>,<\/span> con<\/span>=<\/span>conn<\/span>)<\/span>\r\n>>><\/span> df<\/span>\r\n id<\/span> day<\/span> city<\/span> temp_max<\/span> temp_min<\/span> wind<\/span>\r\n0<\/span> 0<\/span> 2019<\/span>-<\/span>11<\/span>-<\/span>18<\/span> test<\/span> 21.3<\/span> 10.5<\/span> 0.7<\/span>\r\n1<\/span> 1<\/span> 2019<\/span>-<\/span>12<\/span>-<\/span>18<\/span> test<\/span> 11.3<\/span> 7.5<\/span> 0.7<\/span>\r\n>>><\/span> exit<\/span>()<\/span>\r\n$<\/span>\r\n<\/code><\/pre>\n\u8fde\u63a5\u8bbe\u7f6e<\/h3>\n\n- \n
conn = psycopg2.connect()<\/ul>\n<\/li>\n<\/ul>\ndbname=DataBase\u540d or database=DataBase\u540d
\nuser=\u30e6\u30fc\u30b6\u30fc\u540d
\npassword=\u30d1\u30b9\u30ef\u30fc\u30c9
\nhost=URL
\nport=\u30dd\u30fc\u30c8\u756a\u53f7 default\u306e\u5834\u5408\u7701\u7565\u53ef<\/p>\n
\u7528Pandas\u7684pd.read_sql\u51fd\u6570\u8bfb\u53d6SQL\u67e5\u8be2\u7ed3\u679c\u5e76\u8bbe\u7f6e\u8fde\u63a5\u3002<\/h3>\n
\u53c2\u8003\u300a\u5728Docker\u4e2d\u4f7f\u7528PostgreSQL\u548cDocker\u6570\u636e\u5377\u6302\u8f7d\u300b\uff08https:\/\/medium.com\/faun\/postgresql-in-docker-mount-volume-3220fbd0afc4\uff09\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u4f7f\u7528Docker\u521b\u5efaPostgreSQL\uff0c\u5e76\u4f7f\u7528Python3\u7684pandas\u5e93\u8fdb\u884c\u64cd\u4f5c\u3002 \u73af\u5883\uff1a \u5728macOS […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-41576","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\n
Docker\u4e2d\u7684 PostgreSQL\u7b14\u8bb0 - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/docker\u4e2d\u7684-postgresql\u7b14\u8bb0\u3002\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Docker\u4e2d\u7684 PostgreSQL\u7b14\u8bb0\" \/>\n<meta property=\"og:description\" content=\"\u4f7f\u7528Docker\u521b\u5efaPostgreSQL\uff0c\u5e76\u4f7f\u7528Python3\u7684pandas\u5e93\u8fdb\u884c\u64cd\u4f5c\u3002 \u73af\u5883\uff1a \u5728macOS […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/docker\u4e2d\u7684-postgresql\u7b14\u8bb0\u3002\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-06T07:38:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-04T01:09:43+00:00\" \/>\n<meta name=\"author\" content=\"\u97f5, \u79d1\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u97f5, \u79d1\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/docker%e4%b8%ad%e7%9a%84-postgresql%e7%ac%94%e8%ae%b0%e3%80%82\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/docker%e4%b8%ad%e7%9a%84-postgresql%e7%ac%94%e8%ae%b0%e3%80%82\/\",\"name\":\"Docker\u4e2d\u7684 PostgreSQL\u7b14\u8bb0 - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2022-12-06T07:38:12+00:00\",\"dateModified\":\"2024-05-04T01:09:43+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/6530331a63adef3b3443a1fab53a0e6e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/docker%e4%b8%ad%e7%9a%84-postgresql%e7%ac%94%e8%ae%b0%e3%80%82\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/docker%e4%b8%ad%e7%9a%84-postgresql%e7%ac%94%e8%ae%b0%e3%80%82\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/docker%e4%b8%ad%e7%9a%84-postgresql%e7%ac%94%e8%ae%b0%e3%80%82\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Docker\u4e2d\u7684 PostgreSQL\u7b14\u8bb0\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/6530331a63adef3b3443a1fab53a0e6e\",\"name\":\"\u97f5, \u79d1\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g\",\"caption\":\"\u97f5, \u79d1\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/yunke\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/docker%e4%b8%ad%e7%9a%84-postgresql%e7%ac%94%e8%ae%b0%e3%80%82\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Docker\u4e2d\u7684 PostgreSQL\u7b14\u8bb0 - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/docker\u4e2d\u7684-postgresql\u7b14\u8bb0\u3002\/","og_locale":"zh_CN","og_type":"article","og_title":"Docker\u4e2d\u7684 PostgreSQL\u7b14\u8bb0","og_description":"\u4f7f\u7528Docker\u521b\u5efaPostgreSQL\uff0c\u5e76\u4f7f\u7528Python3\u7684pandas\u5e93\u8fdb\u884c\u64cd\u4f5c\u3002 \u73af\u5883\uff1a \u5728macOS […]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/docker\u4e2d\u7684-postgresql\u7b14\u8bb0\u3002\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2022-12-06T07:38:12+00:00","article_modified_time":"2024-05-04T01:09:43+00:00","author":"\u97f5, \u79d1","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u97f5, \u79d1","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"3 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/docker%e4%b8%ad%e7%9a%84-postgresql%e7%ac%94%e8%ae%b0%e3%80%82\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/docker%e4%b8%ad%e7%9a%84-postgresql%e7%ac%94%e8%ae%b0%e3%80%82\/","name":"Docker\u4e2d\u7684 PostgreSQL\u7b14\u8bb0 - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2022-12-06T07:38:12+00:00","dateModified":"2024-05-04T01:09:43+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/6530331a63adef3b3443a1fab53a0e6e"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/docker%e4%b8%ad%e7%9a%84-postgresql%e7%ac%94%e8%ae%b0%e3%80%82\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/docker%e4%b8%ad%e7%9a%84-postgresql%e7%ac%94%e8%ae%b0%e3%80%82\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/docker%e4%b8%ad%e7%9a%84-postgresql%e7%ac%94%e8%ae%b0%e3%80%82\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"Docker\u4e2d\u7684 PostgreSQL\u7b14\u8bb0"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/6530331a63adef3b3443a1fab53a0e6e","name":"\u97f5, \u79d1","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g","caption":"\u97f5, \u79d1"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/yunke\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/docker%e4%b8%ad%e7%9a%84-postgresql%e7%ac%94%e8%ae%b0%e3%80%82\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41576","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=41576"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41576\/revisions"}],"predecessor-version":[{"id":97420,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41576\/revisions\/97420"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=41576"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=41576"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=41576"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}