极客观点
项目管理
HarmonyOS
我使用windows11 上的 docker-desktop 4.12.0 (85629)，按照如下方式运行 postgres：docker run -d -p 5432:5432 -v D:\WorkSpaces\postgres\pgdata:/var/lib/postgresql/data -e POSTGRES_USER="postgres" -e POSTGRES_PASSWORD="postgres" --name=postgresd --privileged=true postgres:14.5-alpine
容器生成后，其配置如下：
[
{
"Id": "feab0942f6acefe00517de926c0f22e3f401307ae7e8d6c615cfff14f0a8a72c",
"Created": "2022-10-20T12:24:17.474989216Z",
"Path": "docker-entrypoint.sh",
"Args": [
"postgres"
],
"State": {
"Status": "running",
"Running": true,
"Paused": false,
"Restarting": false,
"OOMKilled": false,
"Dead": false,
"Pid": 7432,
"ExitCode": 0,
"Error": "",
"StartedAt": "2022-10-20T12:24:17.89827008Z",
"FinishedAt": "0001-01-01T00:00:00Z"
},
"Image": "sha256:aac01494762a1319624f6117a3d9d374540ec58095c2c9f84adb92619aec3b6e",
"ResolvConfPath": "/var/lib/docker/containers/feab0942f6acefe00517de926c0f22e3f401307ae7e8d6c615cfff14f0a8a72c/resolv.conf",
"HostnamePath": "/var/lib/docker/containers/feab0942f6acefe00517de926c0f22e3f401307ae7e8d6c615cfff14f0a8a72c/hostname",
"HostsPath": "/var/lib/docker/containers/feab0942f6acefe00517de926c0f22e3f401307ae7e8d6c615cfff14f0a8a72c/hosts",
"LogPath": "/var/lib/docker/containers/feab0942f6acefe00517de926c0f22e3f401307ae7e8d6c615cfff14f0a8a72c/feab0942f6acefe00517de926c0f22e3f401307ae7e8d6c615cfff14f0a8a72c-json.log",
"Name": "/postgresd",
"RestartCount": 0,
"Driver": "overlay2",
"Platform": "linux",
"MountLabel": "",
"ProcessLabel": "",
"AppArmorProfile": "",
"ExecIDs": null,
"HostConfig": {
"Binds": [
"D:\\WorkSpaces\\postgres\\pgdata:/var/lib/postgresql/data"
],
"ContainerIDFile": "",
"LogConfig": {
"Type": "json-file",
"Config": {}
},
"NetworkMode": "default",
"PortBindings": {
"5432/tcp": [
{
"HostIp": "",
"HostPort": "5432"
}
]
},
"RestartPolicy": {
"Name": "no",
"MaximumRetryCount": 0
},
"AutoRemove": false,
"VolumeDriver": "",
"VolumesFrom": null,
"CapAdd": null,
"CapDrop": null,
"CgroupnsMode": "host",
"Dns": [],
"DnsOptions": [],
"DnsSearch": [],
"ExtraHosts": null,
"GroupAdd": null,
"IpcMode": "private",
"Cgroup": "",
"Links": null,
"OomScoreAdj": 0,
"PidMode": "",
"Privileged": true,
"PublishAllPorts": false,
"ReadonlyRootfs": false,
"SecurityOpt": [
"label=disable"
],
"UTSMode": "",
"UsernsMode": "",
"ShmSize": 67108864,
"Runtime": "runc",
"ConsoleSize": [
70,
185
],
"Isolation": "",
"CpuShares": 0,
"Memory": 0,
"NanoCpus": 0,
"CgroupParent": "",
"BlkioWeight": 0,
"BlkioWeightDevice": [],
"BlkioDeviceReadBps": null,
"BlkioDeviceWriteBps": null,
"BlkioDeviceReadIOps": null,
"BlkioDeviceWriteIOps": null,
"CpuPeriod": 0,
"CpuQuota": 0,
"CpuRealtimePeriod": 0,
"CpuRealtimeRuntime": 0,
"CpusetCpus": "",
"CpusetMems": "",
"Devices": [],
"DeviceCgroupRules": null,
"DeviceRequests": null,
"KernelMemory": 0,
"KernelMemoryTCP": 0,
"MemoryReservation": 0,
"MemorySwap": 0,
"MemorySwappiness": null,
"OomKillDisable": false,
"PidsLimit": null,
"Ulimits": null,
"CpuCount": 0,
"CpuPercent": 0,
"IOMaximumIOps": 0,
"IOMaximumBandwidth": 0,
"MaskedPaths": null,
"ReadonlyPaths": null
},
"GraphDriver": {
"Data": {
"LowerDir": "/var/lib/docker/overlay2/3906949956f90ce9016b842b5dcae47e2967e444086faedb6b869c4c190a3fc1-init/diff:/var/lib/docker/overlay2/b524188d4cc3454c10a7f522ab4fdc117dbf6bf00cf5bd40284048a5bba09c9f/diff:/var/lib/docker/overlay2/bee4e2c6da4f5ac331e3bf46cf7757b84976296e2387dc764dceea8edf8b768a/diff:/var/lib/docker/overlay2/3377672e6bd86b46721d9c2d9d832f9dcda9dc4c4777a775de03616824d498b0/diff:/var/lib/docker/overlay2/37658bc198dcb790f13d622c4ad5f698c2a23797f8d0466a3c5bd82d8cd670fa/diff:/var/lib/docker/overlay2/54cfbc764cfdee02fa8bf3bd2b62fd13f45b53229b6e76404da13af5d50d8458/diff:/var/lib/docker/overlay2/a58cddffe31ff0d02a6a4597d0cb16f70893b17285a66f5951b9cd0709822d31/diff:/var/lib/docker/overlay2/adb61c1f86f8fa95bbd0ac009f77953150e58306023b495b613f675921e61dce/diff:/var/lib/docker/overlay2/dbb13b5055d8d562a7ed49b62a4dcbc58ca9f1b5899cf44915d1bc5a1b5bfedc/diff",
"MergedDir": "/var/lib/docker/overlay2/3906949956f90ce9016b842b5dcae47e2967e444086faedb6b869c4c190a3fc1/merged",
"UpperDir": "/var/lib/docker/overlay2/3906949956f90ce9016b842b5dcae47e2967e444086faedb6b869c4c190a3fc1/diff",
"WorkDir": "/var/lib/docker/overlay2/3906949956f90ce9016b842b5dcae47e2967e444086faedb6b869c4c190a3fc1/work"
},
"Name": "overlay2"
},
"Mounts": [
{
"Type": "bind",
"Source": "D:\\WorkSpaces\\postgres\\pgdata",
"Destination": "/var/lib/postgresql/data",
"Mode": "",
"RW": true,
"Propagation": "rprivate"
}
],
"Config": {
"Hostname": "feab0942f6ac",
"Domainname": "",
"User": "",
"AttachStdin": false,
"AttachStdout": false,
"AttachStderr": false,
"ExposedPorts": {
"5432/tcp": {}
},
"Tty": false,
"OpenStdin": false,
"StdinOnce": false,
"Env": [
"POSTGRES_USER=postgres",
"POSTGRES_PASSWORD=postgres",
"PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin",
"LANG=en_US.utf8",
"PG_MAJOR=14",
"PG_VERSION=14.5",
"PG_SHA256=d4f72cb5fb857c9a9f75ec8cf091a1771272802f2178f0b2e65b7b6ff64f4a30",
"PGDATA=/var/lib/postgresql/data"
],
"Cmd": [
"postgres"
],
"Image": "postgres:14.5-alpine",
"Volumes": {
"/var/lib/postgresql/data": {}
},
"WorkingDir": "",
"Entrypoint": [
"docker-entrypoint.sh"
],
"OnBuild": null,
"Labels": {},
"StopSignal": "SIGINT"
},
"NetworkSettings": {
"Bridge": "",
"SandboxID": "46cf34967d36089b91b2f6a46fdff9d0c6cc113f804fee9aad0cffef46f35d44",
"HairpinMode": false,
"LinkLocalIPv6Address": "",
"LinkLocalIPv6PrefixLen": 0,
"Ports": {
"5432/tcp": [
{
"HostIp": "0.0.0.0",
"HostPort": "5432"
}
]
},
"SandboxKey": "/var/run/docker/netns/46cf34967d36",
"SecondaryIPAddresses": null,
"SecondaryIPv6Addresses": null,
"EndpointID": "a609a0b9aaea0deb602edb64de297f4cdc77f93243961797f5d920ea733c4ed0",
"Gateway": "172.17.0.1",
"GlobalIPv6Address": "",
"GlobalIPv6PrefixLen": 0,
"IPAddress": "172.17.0.3",
"IPPrefixLen": 16,
"IPv6Gateway": "",
"MacAddress": "02:42:ac:11:00:03",
"Networks": {
"bridge": {
"IPAMConfig": null,
"Links": null,
"Aliases": null,
"NetworkID": "c9035ea26f04126260dcc73c792c44ae5a79d676b6fd515f3704e11ff210521a",
"EndpointID": "a609a0b9aaea0deb602edb64de297f4cdc77f93243961797f5d920ea733c4ed0",
"Gateway": "172.17.0.1",
"IPAddress": "172.17.0.3",
"IPPrefixLen": 16,
"IPv6Gateway": "",
"GlobalIPv6Address": "",
"GlobalIPv6PrefixLen": 0,
"MacAddress": "02:42:ac:11:00:03",
"DriverOpts": null
}
}
}
}
]这看起来一切都很正常，但接下来问题出来了
我进入容器：docker exec -it postgresd /bin/bash
psql -U postgres 或者 psql -U "postgres" 均报错说角色不存在，我有什么地方做错了吗？
同样的问题，我在macbook pro上就没有问题，哪位大神能救救我，万分感谢！
错误: 角色不存在