1、docker pull postgres:13
2、docker run -d –name postgres13 -e POSTGRES_USER=postgres -e POSTGRES_PASSWORD=postgres -v /home/sunyuhua/docker/postgresql/data:/var/lib/postgresql/data -v /etc/localtime:/etc/localtime –restart=always -p 15432:5432 postgres:13
3、 docker exec -it postgres13 /bin/bash
4、创建查询用户,并赋值权限
psql -U postgres
CREATE ROLE sa WITH SUPERUSER LOGIN PASSWORD ‘xxxxx’;
create user sa with password ‘xxxxxxx’;
grant all PRIVILEGES on database postgres to sa;
grant all PRIVILEGES on all tables in schema public TO sa;
服务器托管,北京服务器托管,服务器租用 http://www.fwqtg.net
机房租用,北京机房租用,IDC机房托管, http://www.fwqtg.net
博客地址:https://www.cnblogs.com/zylyehuo/ 参考资料 ORB-SLAM3配置及安装教程 ORB-SLAM3配置安装及运行 环境配置 Win 11pro VMware 17Pro Ubuntu 18.04 Eigen3 Pang…