[{"_1":2,"_167":-5,"_168":-5},"loaderData",{"_3":4,"_13":14,"_21":22,"_142":143},"root",{"_5":-5,"_6":-7,"_7":8,"_9":-7,"_10":11,"_12":-7},"currentUser","primaryEmail","siteVerification","6LeIxAcTAAAAAJcZVRqyHh71UMIEGNQ_MXjiZKhI","toast","enableDev",false,"incidentStatus","routes/_layout",{"_15":-5,"_16":17,"_18":17,"_19":11,"_20":11},"username","isAskGordonEnabled",true,"isUsingNewTemplate","showMinimalLanding","showHoneypotTrap","routes/_layout.r.$namespace.$reponame",{"_23":24,"_25":-5,"_26":11,"_27":11,"_28":29,"_30":31,"_32":-5,"_33":11,"_34":35,"_84":-5,"_85":86,"_135":-5,"_136":11,"_137":17,"_138":11,"_139":-5,"_140":141},"canonicalUrl","https://hub.docker.com/r/wjf8882300/postgres/tags","mcpServer","canSeeDockerfile","canSeeAutobuilds","namespace","wjf8882300","reponame","postgres","cloudBuildSource","isAutobuildsAvailable","repo",{"_36":37,"_38":39,"_41":42,"_43":44,"_45":11,"_46":47,"_48":49,"_50":51,"_53":31,"_28":29,"_54":55,"_56":40,"_57":58,"_59":60,"_61":62,"_63":-5,"_64":58,"_65":66,"_67":11,"_68":29,"_69":70,"_75":11,"_76":77,"_81":29,"_82":83},"categories",[],"content_types",[40],"image","date_registered","2020-01-20T03:10:13.532529Z","description","Postgresql，基于官方12版本，增加了备份目录PGDATA/../backup","is_private","last_updated","2023-06-29T12:54:45.119714Z","last_modified","2024-10-16T13:48:34.145251Z","media_types",[52],"application/vnd.docker.container.image.v1+json","name","pull_count",193,"repository_type","star_count",0,"status",1,"status_description","active","source","collaborator_count","full_description","```\ndocker run -it --rm -d --name postgres -e POSTGRES_PASSWORD=xxx -p 5432:5432 -v /data/postgresql/data:/var/lib/postgresql/data -v /data/postgresql/backup:/var/lib/postgresql/backup wjf8882300/postgres:12\n```\n\nDockerfile\n```\nFROM postgres:12\n \nCOPY ./docker-entrypoint.sh /usr/local/bin/docker-entrypoint.sh\nRUN chmod +x /usr/local/bin/docker-entrypoint.sh\nENTRYPOINT [\"docker-entrypoint.sh\"]\nCMD [\"postgres\"]\n```\n\ndocker-entrypoint.sh\n```\n#!/usr/bin/env bash\nset -Eeo pipefail\n# TODO swap to -Eeuo pipefail above (after handling all potentially-unset variables)\n \n# usage: file_env VAR [DEFAULT]\n# ie: file_env 'XYZ_DB_PASSWORD' 'example'\n# (will allow for \"$XYZ_DB_PASSWORD_FILE\" to fill in the value of\n# \"$XYZ_DB_PASSWORD\" from a file, especially for Docker's secrets feature)\nfile_env() {\n local var=\"$1\"\n local fileVar=\"${var}_FILE\"\n local def=\"${2:-}\"\n if [ \"${!var:-}\" ] && [ \"${!fileVar:-}\" ]; then\n echo >&2 \"error: both $var and $fileVar are set (but are exclusive)\"\n exit 1\n fi\n local val=\"$def\"\n if [ \"${!var:-}\" ]; then\n val=\"${!var}\"\n elif [ \"${!fileVar:-}\" ]; then\n val=\"$(< \"${!fileVar}\")\"\n fi\n export \"$var\"=\"$val\"\n unset \"$fileVar\"\n}\n \n# check to see if this file is being run or sourced from another script\n_is_sourced() {\n # https://unix.stackexchange.com/a/215279\n [ \"${#FUNCNAME[@]}\" -ge 2 ] \\\n && [ \"${FUNCNAME[0]}\" = '_is_sourced' ] \\\n && [ \"${FUNCNAME[1]}\" = 'source' ]\n}\n \n# used to create initial postgres directories and if run as root, ensure ownership to the \"postgres\" user\ndocker_create_db_directories() {\n local user; user=\"$(id -u)\"\n \n mkdir -p \"$PGDATA\"\n # 此处是新加的\n mkdir -p \"$PGDATA\"/../backup\n chmod 700 \"$PGDATA\"\n # 此处是新加的\n chmod 700 \"$PGDATA\"/../backup\n \n # ignore failure since it will be fine when using the image provided directory; see also https://github.com/docker-library/postgres/pull/289\n mkdir -p /var/run/postgresql || :\n chmod 775 /var/run/postgresql || :\n \n # Create the transaction log directory before initdb is run so the directory is owned by the correct user\n if [ -n \"$POSTGRES_INITDB_WALDIR\" ]; then\n mkdir -p \"$POSTGRES_INITDB_WALDIR\"\n if [ \"$user\" = '0' ]; then\n find \"$POSTGRES_INITDB_WALDIR\" \\! -user postgres -exec chown postgres '{}' +\n fi\n chmod 700 \"$POSTGRES_INITDB_WALDIR\"\n fi\n \n # allow the container to be started with `--user`\n if [ \"$user\" = '0' ]; then\n find \"$PGDATA\" \\! -user postgres -exec chown postgres '{}' +\n # 此处是新加的\n find \"$PGDATA\"/../backup \\! -user postgres -exec chown postgres '{}' +\n find /var/run/postgresql \\! -user postgres -exec chown postgres '{}' +\n fi\n}\n \n# initialize empty PGDATA directory with new database via 'initdb'\n# arguments to `initdb` can be passed via POSTGRES_INITDB_ARGS or as arguments to this function\n# `initdb` automatically creates the \"postgres\", \"template0\", and \"template1\" dbnames\n# this is also where the database user is created, specified by `POSTGRES_USER` env\ndocker_init_database_dir() {\n # \"initdb\" is particular about the current user existing in \"/etc/passwd\", so we use \"nss_wrapper\" to fake that if necessary\n # see https://github.com/docker-library/postgres/pull/253, https://github.com/docker-library/postgres/issues/359, https://cwrap.org/nss_wrapper.html\n if ! getent passwd \"$(id -u)\" &> /dev/null && [ -e /usr/lib/libnss_wrapper.so ]; then\n export LD_PRELOAD='/usr/lib/libnss_wrapper.so'\n export NSS_WRAPPER_PASSWD=\"$(mktemp)\"\n export NSS_WRAPPER_GROUP=\"$(mktemp)\"\n echo \"postgres:x:$(id -u):$(id -g):PostgreSQL:$PGDATA:/bin/false\" > \"$NSS_WRAPPER_PASSWD\"\n echo \"postgres:x:$(id -g):\" > \"$NSS_WRAPPER_GROUP\"\n fi\n \n if [ -n \"$POSTGRES_INITDB_WALDIR\" ]; then\n set -- --waldir \"$POSTGRES_INITDB_WALDIR\" \"$@\"\n fi\n \n eval 'initdb --username=\"$POSTGRES_USER\" --pwfile=<(echo \"$POSTGRES_PASSWORD\") '\"$POSTGRES_INITDB_ARGS\"' \"$@\"'\n \n # unset/cleanup \"nss_wrapper\" bits\n if [ \"${LD_PRELOAD:-}\" = '/usr/lib/libnss_wrapper.so' ]; then\n rm -f \"$NSS_WRAPPER_PASSWD\" \"$NSS_WRAPPER_GROUP\"\n unset LD_PRELOAD NSS_WRAPPER_PASSWD NSS_WRAPPER_GROUP\n fi\n}\n \n# print large warning if POSTGRES_PASSWORD is long\n# error if both POSTGRES_PASSWORD is empty and POSTGRES_HOST_AUTH_METHOD is not 'trust'\n# print large warning if POSTGRES_HOST_AUTH_METHOD is set to 'trust'\n# assumes database is not set up, ie: [ -z \"$DATABASE_ALREADY_EXISTS\" ]\ndocker_verify_minimum_env() {\n # check password first so we can output the warning before postgres\n # messes it up\n if [ \"${#POSTGRES_PASSWORD}\" -ge 100 ]; then\n cat >&2 <<-'EOWARN'\n \n WARNING: The supplied POSTGRES_PASSWORD is 100+ characters.\n \n This will not work if used via PGPASSWORD with \"psql\".\n \n https://www.postgresql.org/message-id/flat/E1Rqxp2-0004Qt-PL%40wrigleys.postgresql.org (BUG #6412)\n https://github.com/docker-library/postgres/issues/507\n \n EOWARN\n fi\n if [ -z \"$POSTGRES_PASSWORD\" ] && [ 'trust' != \"$POSTGRES_HOST_AUTH_METHOD\" ]; then\n # The - option suppresses leading tabs but *not* spaces. :)\n cat >&2 <<-'EOE'\n Error: Database is uninitialized and superuser password is not specified.\n You must specify POSTGRES_PASSWORD to a non-empty value for the\n superuser. For example, \"-e POSTGRES_PASSWORD=password\" on \"docker run\".\n \n You may also use \"POSTGRES_HOST_AUTH_METHOD=trust\" to allow all\n connections without a password. This is *not* recommended.\n \n See PostgreSQL documentation about \"trust\":\n https://www.postgresql.org/docs/current/auth-trust.html\n EOE\n exit 1\n fi\n if [ 'trust' = \"$POSTGRES_HOST_AUTH_METHOD\" ]; then\n cat >&2 <<-'EOWARN'\n ********************************************************************************\n WARNING: POSTGRES_HOST_AUTH_METHOD has been set to \"trust\". This will allow\n anyone with access to the Postgres port to access your database without\n a password, even if POSTGRES_PASSWORD is set. See PostgreSQL\n documentation about \"trust\":\n https://www.postgresql.org/docs/current/auth-trust.html\n In Docker's default configuration, this is effectively any other\n container on the same system.\n \n It is not recommended to use POSTGRES_HOST_AUTH_METHOD=trust. Replace\n it with \"-e POSTGRES_PASSWORD=password\" instead to set a password in\n \"docker run\".\n ********************************************************************************\n EOWARN\n fi\n}\n \n# usage: docker_process_init_files [file [file [...]]]\n# ie: docker_process_init_files /always-initdb.d/*\n# process initializer files, based on file extensions and permissions\ndocker_process_init_files() {\n # psql here for backwards compatiblilty \"${psql[@]}\"\n psql=( docker_process_sql )\n \n echo\n local f\n for f; do\n case \"$f\" in\n *.sh)\n # https://github.com/docker-library/postgres/issues/450#issuecomment-393167936\n # https://github.com/docker-library/postgres/pull/452\n if [ -x \"$f\" ]; then\n echo \"$0: running $f\"\n \"$f\"\n else\n echo \"$0: sourcing $f\"\n . \"$f\"\n fi\n ;;\n *.sql) echo \"$0: running $f\"; docker_process_sql -f \"$f\"; echo ;;\n *.sql.gz) echo \"$0: running $f\"; gunzip -c \"$f\" | docker_process_sql; echo ;;\n *.sql.xz) echo \"$0: running $f\"; xzcat \"$f\" | docker_process_sql; echo ;;\n *) echo \"$0: ignoring $f\" ;;\n esac\n echo\n done\n}\n \n# Execute sql script, passed via stdin (or -f flag of pqsl)\n# usage: docker_process_sql [psql-cli-args]\n# ie: docker_process_sql --dbname=mydb <<<'INSERT ...'\n# ie: docker_process_sql -f my-file.sql\n# ie: docker_process_sql > \"$PGDATA/pg_hba.conf\"\n}\n \n# start socket-only postgresql server for setting up or running scripts\n# all arguments will be passed along as arguments to `postgres` (via pg_ctl)\ndocker_temp_server_start() {\n if [ \"$1\" = 'postgres' ]; then\n shift\n fi\n \n # internal start of server in order to allow setup using psql client\n # does not listen on external TCP/IP and waits until start finishes\n set -- \"$@\" -c listen_addresses='' -p \"${PGPORT:-5432}\"\n \n PGUSER=\"${PGUSER:-$POSTGRES_USER}\" \\\n pg_ctl -D \"$PGDATA\" \\\n -o \"$(printf '%q ' \"$@\")\" \\\n -w start\n}\n \n# stop postgresql server after done setting up user and running scripts\ndocker_temp_server_stop() {\n PGUSER=\"${PGUSER:-postgres}\" \\\n pg_ctl -D \"$PGDATA\" -m fast -w stop\n}\n \n# check arguments for an option that would cause postgres to stop\n# return true if there is one\n_pg_want_help() {\n local arg\n for arg; do\n case \"$arg\" in\n # postgres --help | grep 'then exit'\n # leaving out -C on purpose since it always fails and is unhelpful:\n # postgres: could not access the server configuration file \"/var/lib/postgresql/data/postgresql.conf\": No such file or directory\n -'?'|--help|--describe-config|-V|--version)\n return 0\n ;;\n esac\n done\n return 1\n}\n \n_main() {\n # if first arg looks like a flag, assume we want to run postgres server\n if [ \"${1:0:1}\" = '-' ]; then\n set -- postgres \"$@\"\n fi\n \n if [ \"$1\" = 'postgres' ] && ! _pg_want_help \"$@\"; then\n docker_setup_env\n # setup data directories and permissions (when run as root)\n docker_create_db_directories\n if [ \"$(id -u)\" = '0' ]; then\n # then restart script as postgres user\n exec gosu postgres \"$BASH_SOURCE\" \"$@\"\n fi\n \n # only run initialization on an empty data directory\n if [ -z \"$DATABASE_ALREADY_EXISTS\" ]; then\n docker_verify_minimum_env\n \n # check dir permissions to reduce likelihood of half-initialized database\n ls /docker-entrypoint-initdb.d/ > /dev/null\n \n docker_init_database_dir\n pg_setup_hba_conf\n \n # PGPASSWORD is required for psql when authentication is required for 'local' connections via pg_hba.conf and is otherwise harmless\n # e.g. when '--auth=md5' or '--auth-local=md5' is used in POSTGRES_INITDB_ARGS\n export PGPASSWORD=\"${PGPASSWORD:-$POSTGRES_PASSWORD}\"\n docker_temp_server_start \"$@\"\n \n docker_setup_db\n docker_process_init_files /docker-entrypoint-initdb.d/*\n \n docker_temp_server_stop\n unset PGPASSWORD\n \n echo\n echo 'PostgreSQL init process complete; ready for start up.'\n echo\n else\n echo\n echo 'PostgreSQL Database directory appears to contain a database; Skipping initialization'\n echo\n fi\n fi\n \n exec \"$@\"\n}\n \nif ! _is_sourced; then\n _main \"$@\"\nfi\n```","has_starred","hub_user","immutable_tags_settings",{"_71":11,"_72":73},"enabled","rules",[74],".*","is_automated","permissions",{"_78":17,"_79":11,"_80":11},"read","write","admin","user","storage_size",467832470,"orgData","recentTags",[87,125],{"_88":40,"_89":90,"_91":92,"_93":94,"_95":96,"_97":98,"_46":114,"_115":90,"_116":29,"_117":52,"_53":118,"_119":120,"_121":105,"_122":114,"_123":62,"_124":17},"content_type","creator",6645177,"digest","sha256:fe04ab019e47721e85e7bba66cc7b5f55af317c99a19e6844870a022affa7bd1","full_size",232147109,"id",465855152,"images",[99],{"_100":101,"_91":92,"_102":103,"_104":105,"_106":107,"_108":109,"_110":103,"_111":-5,"_112":94,"_59":62,"_113":-5},"architecture","amd64","features","","last_pulled","2026-09-14T23:38:47.072799031Z","last_pushed","2023-06-29T12:54:45Z","os","linux","os_features","os_version","size","variant","2023-06-29T12:54:45.101709Z","last_updater","last_updater_username","media_type","12-postgis","repository",8343877,"tag_last_pulled","tag_last_pushed","tag_status","v2",{"_88":40,"_89":90,"_93":126,"_95":127,"_97":128,"_46":133,"_115":90,"_116":29,"_117":52,"_53":134,"_119":120,"_121":131,"_122":133,"_123":62,"_124":17},114113168,83216908,[129],{"_100":101,"_91":130,"_102":103,"_104":131,"_106":132,"_108":109,"_110":103,"_111":-5,"_112":126,"_59":62,"_113":-5},"sha256:4af643137e222ffc2690ca8c46927c2691774baa7a166b1469c21f66bc05ece6","2026-09-15T01:47:38.855360099Z","2020-06-30T11:26:04Z","2020-06-30T11:26:03.932189Z","12","sbxKitMetadata","isPotentialSpam","isHubSbxKitsEnabled","displaySecurityMetadata","tagAttestations","tagsHaveAttestations",[],"routes/_layout.r.$namespace.$reponame.tags",{"_34":144,"_151":152,"_140":165,"_166":11},{"_36":145,"_38":146,"_41":42,"_43":44,"_45":11,"_46":47,"_48":49,"_50":147,"_53":31,"_28":29,"_54":55,"_56":40,"_57":58,"_59":60,"_61":62,"_63":-5,"_64":58,"_65":66,"_67":11,"_68":29,"_69":148,"_75":11,"_76":150,"_81":29,"_82":83},[],[40],[52],{"_71":11,"_72":149},[74],{"_78":17,"_79":11,"_80":11},"tags",{"_153":154,"_155":-5,"_156":-5,"_157":158},"count",2,"next","previous","results",[159,162],{"_88":40,"_89":90,"_91":92,"_93":94,"_95":96,"_97":160,"_46":114,"_115":90,"_116":29,"_117":52,"_53":118,"_119":120,"_121":105,"_122":114,"_123":62,"_124":17},[161],{"_100":101,"_91":92,"_102":103,"_104":105,"_106":107,"_108":109,"_110":103,"_111":-5,"_112":94,"_59":62,"_113":-5},{"_88":40,"_89":90,"_93":126,"_95":127,"_97":163,"_46":133,"_115":90,"_116":29,"_117":52,"_53":134,"_119":120,"_121":131,"_122":133,"_123":62,"_124":17},[164],{"_100":101,"_91":130,"_102":103,"_104":131,"_106":132,"_108":109,"_110":103,"_111":-5,"_112":126,"_59":62,"_113":-5},[],"canDeleteTags","actionData","errors"]

wjf8882300/postgres

Tags for wjf8882300/postgres