1、切换用户
su - postgres
2、登录数据库
psql
3、查看数据库超级用户, 这里的超级用户是pgsql,如下图:
postgres=> \du
4、切换为超级管理用户,成功后如下图:
postgres=> \c - pgsql 语法: \c - [user_name]
5、创建数据库和授权用户
create user demo_db with password 'demo_db12345';
create database demo_db with encoding='utf8' ;
grant all privileges on database demo_db to demo_db ;
6、连接建数据库后并改数据的归属用户
\connect demo_db;
create schema extensions;
create extension hstore schema extensions;
CREATE EXTENSION pg_trgm;
ALTER DATABASE demo_db SET search_path to "$user",public,extensions;
alter database demo_db owner to demo_db;
alter schema public owner to demo_db;
alter schema extensions owner to demo_db;
GRANT USAGE ON SCHEMA public to demo_db;
PostgreSQL给模糊搜索加索引 需要启用 CREATE EXTENSION pg_trgm;