Post

postgres-0-install-and-run-mac

Posted
By gonnichiwa. 1 min read

작성목적

  • postgres install과 제어 메모

설치

https://wiki.postgresql.org/wiki/Homebrew

1

$ brew install postgresql

서비스 시작

1

$ brew services start postgresql

서비스 확인

1
2
3

$ brew services list

postgresql@14 started jae-hunjeong ~/Library/LaunchAgents/homebrew.mxcl.postgresql@14.plist

superuser 생성

1
2
3
4
5
6
7
8
9
10
11

$ psql postgres

postgres=# create role postgres with login password '1234';
CREATE ROLE

postgres=# alter user postgres with superuser;
ALTER ROLE

postgres=# \q

$

확인

  • dbeaver에서 conn test함

서비스 종료

  • (brew services list로 확인한 postgresql@14) ```sh $ brew services stop postgresql@14 postgresql@14 none

$ brew services list postgresql@14 none

1
2
3
4
5
6
7
8


### 서비스 삭제 on mac

```sh
$ brew services stop postgresql@15
$ brew uninstall --force postgresql@15
$ rm -rf $(brew --prefix)/var/postgresql@15
Postgres
postgres
This post is licensed under CC BY 4.0 by the author.