[PostgreSQL] How to exit from PostgreSQL command line utility: psql (psql 종료 방법)

Type \q

[PostgreSQL] Install PostgreSQL

1.Install Server & Libraries

#> yum -y install postgresql-server postgresql-contrib

2. Initialize database

#> postgresql-setup initdb

3. Edit configuration

#> su - postgres
$> cd data
$> vi pg_hba.conf

TYPE    DATABASE  USER    ADDRESS         METHOD
host    all       all     127.0.0.1/32    md5
host    all       all     192.168.0.0/24  md5
host    all       all     0.0.0.0/0       md5

$> vi postgresql.conf

4. Start server

#> systemctl start postgresql
#> systemctl status postgresql

5. Create DB

#> su - postgres
$> createdb [DB_NAME]

6. Create user and grant privilege

$> psql -s [DB_NAME]
$> create user [USER_NAME] password '[PASSWORD]';
$> GRANT ALL PRIVILEGES ON DATABASE [DB_NAME] TO [USER_NAME];

[Windows] Get encoding of a file in Windows (윈도우즈에서 파일 인코딩 확인)

1. Download GNUWin32 File Command

http://gnuwin32.sourceforge.net/packages/file.htm

2. Install GNUWin32 File Command and Set PATH

3. Use file command in CMD

[GitHub] Close issue when commit or push

Keywords for closing issues

The following keywords will close an issue via commit message:

• close
• closes
• closed
• fix
• fixes
• fixed
• resolve
• resolves
• resolved

Add keyword # [issue number]  in commit message.




https://help.github.com/articles/closing-issues-via-commit-messages/