- Create PostgreSQL server:
initdb --locale=C -E UTF-8 node1 - Start PostgreSQL server:
pg_ctl -D node1 -l logfile start - Connect via terminal:
psql -p [PORT] postgres - Create database:
create database [dbname]; - List databases:
\l - Select database:
\c [dbname] - List tables:
\dt - For public access:
- Add or edit the following line in your postgresql.conf:
listen_addresses = '*' - Add the following line as the first line of pg_hba.conf. It allows access to all databases for all users with an encrypted password:
# TYPE DATABASE USER CIDR-ADDRESS METHOD host all all 0.0.0.0/0 md5 - Type
\cto select default postgre database, and type\passwordto set password
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent