Install Postgresql for windows scoop

• https://www.postgresql.org/

Install Postgresql for windows scoop

scoop install postgresql

Path

PGPATH = C:\Users\username\scoop\apps\postgresql\current
PGDATA = %PGPATH%\bin
PATH = %PATH%;%PGPATH%\bin;

Start / Stop

pg_ctl start
pg_ctl stop
pg_ctl --help

PG Admin

[Window+s] pgadmin

user / database

psql -U postgres

psql (11.1)
도움말을 보려면 help를 입력하십시오.

# 사용자 생성
postgres=# create user username with password 'password';
CREATE ROLE

# 데이터베이스 생성
postgres=# create database databasename;
CREATE DATABASE

config

# data\postgresql.conf
listen_address = '*'

# data\pg_hba.conf
host    all             all             0.0.0.0/32              trust

pg_ctl restart

Add New Server for PGAdmin