- 备份

```bash
pg_dump -U db_user -W -F p db_name > /path/to/your/file/dump_name.sql
```

- 导入备份

```bash
psql -U db_user db_name < /path/to/your/file/dump_name.sql
```

- 创建用户及授权

```bash
create database DB_NAME;
create user DB_USER with encrypted password 'USER_PASSWORD';
grant all privileges on database DB_NAME to DB_USER;
```

- 查看用户

```bash
\du
```

- 查看表

```bash
\dt
```