# psql -d template1 -U pgsql
> alter user pgsql with password 'pgsql_password'; # Use username instead of "pgsql"
修改root密码
创建用户和数据库
# createuser -U pgsql -P bob # -P will ask for password
# createdb -U pgsql -O bob bobdb # new bobdb is owned by bob
# dropdb bobdb # Delete database bobdb
# dropuser bob # Delete user bob
授予远程访问权限
配置$PGSQL_DATA_D/postgresql.conf文件,修改listen_addresses = '*'
备份和恢复
备份恢复指定数据库
# pg_dump --clean dbname > dbname_sql.dump
# psql dbname < dbname_sql.dump
备份恢复所有数据库
# pg_dumpall --clean > full.dump
# psql -f full.dump postgres
登录数据库
psql -U dbuser -d exampledb -h 127.0.0.1 -p 5432