pgsql实现如何导入导出数据库

导出数据库

pg_dump -h localhost -p 5432 -U venuspostgres -d waflogdata -f /waflogdata.sql

导入数据库

psql -U postgres(用户名)  数据库名(缺省时同用户名) < 文件.sql

psql -U postgres waflogdata < waflogdata.sql

从docker导出pgsql数据库

通过docker ps获取容器id

[root@localhost mediacms]# docker ps
CONTAINER ID   IMAGE                      COMMAND                   CREATED        STATUS                  PORTS                                         NAMES
c50e6c7cedec   mediacms/mediacms:latest   "./deploy/docker/ent…"   21 hours ago   Up 21 hours             0.0.0.0:80->80/tcp, :::80->80/tcp, 9000/tcp   mediacms_web_1
d8225dea4cd6   mediacms/mediacms:latest   "./deploy/docker/ent…"   21 hours ago   Up 21 hours             80/tcp, 9000/tcp                              mediacms_celery_worker_1
255ad894f6ea   mediacms/mediacms:latest   "./deploy/docker/ent…"   21 hours ago   Up 21 hours             80/tcp, 9000/tcp                              mediacms_celery_beat_1
a88971256c7f   redis:alpine               "docker-entrypoint.s…"   21 hours ago   Up 21 hours (healthy)   6379/tcp                                      mediacms_redis_1
8edaf2076f21   postgres:15.2-alpine       "docker-entrypoint.s…"   21 hours ago   Up 21 hours (healthy)   5432/tcp                                      mediacms_db_1

先把数据库导出到容器中

docker exec 8edaf2076f21 pg_dump -U mediacms -h localhost -p 5432  -f /var/lib/postgresql/data/mediacms.sql mediacms

下载到本地

[root@localhost mediacms]#  docker cp 8edaf2076f21:/var/lib/postgresql/data/mediacms.sql  /root/
                                               Successfully copied 130kB to /root/