docker 创建postgresql服务 作者: minqike 时间: 2024-06-16 分类: Docker ```shell mkdir /opt/docker/postgre15 docker run --name my_postgres \ -v /opt/docker/postgre15:/var/lib/postgresql/data \ -e POSTGRES_PASSWORD=Root123Root123 \ -p 5432:5432 \ -d postgres:15.3 ``` # 修改时区 show time zone; select * from pg_timezone_names; ## 修改配置文件/opt/docker/postgre15/postgresql.conf ``` log_timezone = 'PRC' timezone = 'PRC' ``` ```sql select now(); select datname,pg_encoding_to_char(encoding) as encoding,datcollate,datctype from pg_database; ``` ### transform_null_equals 可以设置 transform_null_equals 把 = null 翻译成 is null 避免踩坑 标签: none