随笔分类 -  Database / PostgreSQL

PostgreSQL: backup
摘要：tar -xf base.tar.gz --directory /data chown -R postgres.postgres /data chown -R 0700 /data sudo -u postgres /usr/lib/postgresql/10/bin/pg_ctl start -- 阅读全文
posted @ 2022-02-14 10:39 ascertain 阅读(43) 评论(0) 推荐(0) 编辑
PostgreSQL: non-interactive input password
摘要：~/.pgpass hostname:port:database:username:password chmod 0600 ~/.pgpass PGPASSWORD=password psql --host=host --port=5432 --username postgres postgres 阅读全文
posted @ 2022-02-10 19:58 ascertain 阅读(29) 评论(0) 推荐(0) 编辑
schema
摘要：schema: \dnS+ 显示schema drop　schema public cascade; create schema public authorization postgres;grant all on schema public to postgres;grant all on sch 阅读全文
posted @ 2021-07-02 17:55 ascertain 阅读(103) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示