Home Linux with CentOS
Post
Cancel

Linux with CentOS

PostgreSQL 설치

1. 설치

  • 공홈 또는 출처 중 하나 들어가서 그대로 설치

2. 비번 설정

1
# passwd postgres

3. 비번 변경 및 확인

1
2
3
[JonahWeimer@localhost ~]$ sudo -i-----------------------------------------
[sudo] password for JonahWeimer: 비번 입력
1
2
3
4
5
6
[root@localhost ~]# su - postgres
[postgres@localhost ~]$ id
uid=26(postgres) gid=26(postgres) groups=26(postgres) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[postgres@localhost ~]$ psql
psql (13.2)
Type "help" for help.
1
2
3
4
5
6
7
postgres=# SET password_encryption='scram-sha-256';
SET
postgres=# ALTER USER postgres WITH PASSWORD 'postgres';
ALTER ROLE
postgres=# exit
[postgres@localhost /]$ exit
logout

4. 설정파일 편집

1
# vi /var/lib/pgsql/12/data/pg_hba.conf
1
2
3
4
5
6
7
8
9
10
11
12
13
14
// 이렇게 편집
# TYPE  DATABASE        USER            ADDRESS                 METHOD
local   all             postgres                                scram-sha-256
# "local" is for Unix domain socket connections only
local   all             all                                     scram-sha-256
# IPv4 local connections:
host    all             all             127.0.0.1/32            scram-sha-256
# IPv6 local connections:
host    all             all             ::1/128                 scram-sha-256
# Allow replication connections from localhost, by a user with the
# replication privilege.
local   replication     all                                     peer
host    replication     all             127.0.0.1/32            ident
host    replication     all             ::1/128                 ident

5. 설정 후 재기동

1
# systemctl restart postgresql-13

6. 실행(모두 같음)

1
2
3
4
5
[root@localhost ~]# psql -U postgres
Password for user postgres: 
psql (13.2)
Type "help" for help.
postgres=# \q
1
2
3
4
5
6
7
[root@localhost ~]# psql -U postgres -W
Password: 
psql (13.2)
Type "help" for help.
postgres=# \q
[root@localhost ~]# exit
logout
1
2
3
4
5
6
7
[postgres@localhost ~]$ psql -U postgres
Password for user postgres: 
psql (13.2)
Type "help" for help.
postgres=# \q
[postgres@localhost ~]$ exit
logout
1
2
3
4
5
[JonahWeimer@localhost ~]$ psql -U postgres -W
Password: 
psql (13.2)
Type "help" for help.
postgres=# \q

7. pgAdmin 설치

1
2
// 설치 후 실행 : linux pgadmin4는 아이디로 로그인이 필요하므로 계정 생성과정을 거쳐야 함.
# /usr/pgadmin4/bin/setup-web.sh

8. 접속

  • http://localhost/pgadmin4

untitled

9. 출처

  • https://www.tecmint.com/install-postgressql-and-pgadmin-in-centos-8/
  • https://m.blog.naver.com/PostView.nhn?blogId=jodi999&logNo=221337438660&proxyReferer=https:%2F%2Fwww.google.com%2F
  • https://info-lab.tistory.com/182
  • [공식] https://www.postgresql.org/download/linux/

Intellij 설치

1. 설치

  • 공홈에서 tar파일 다운로드
  • 파일 다운로드 디렉토리로 이동, 터미널에 다음 실행
1
sudo tar -xvzf ~/Downloads/ideaIC-2020.2.tar.gz
1
sudo mv idea-IC-202.6397.94 idea
1
/(download directory)/idea/bin/idea.sh

2. git token

  • intellij 화면에서 git 로그인 하면 됨

3. java 환경변수 등록

4. 출처

  • https://www.javahelps.com/2020/12/install-intellij-idea-20202-and-older.html

WiFi 연결

무선 wifi 연결(wpa_psk 방식)

1
2
3
4
5
6
7
8
9
10
$ iwconfig //디바이스 이름 확인

$ ifconfig enp1s0 down //유선랜 다운
$ ifconfig wlp2s0 up //무선랜 활성화

$ su
$ cd /etc/wpa_supplicant
$ vim wpa_supplicant.conf //vi 편집기로 편집
 // i(insert) -> 수정완료(esc) -> 저장(:wq + Enter)

1
2
3
4
5
6
7
8
9
10
11
 // 편집내용
  network = {
   ssid="wifiName"
   #psk="wifiPassword"
   psk=new_create_psk
   proto=RSN
   key_mgmt=WPA-PSK
   pairwise=CCMP TKIP
   group=CCMP
  }

1
2
3
4
$ iwconfig wlp2s0 essid "wifiName"
$ wpa_supplicant -iwlp2s0 -c /etc/wpa_supplicant/wpa_supplicant.conf &
$ dhclient -v wlp2s0
// 모두 입력 후 다시 연결하면 됨.

기타

1
$ su -c "yum install java-1.8.0-openjdk"
  • visual studio
    • https://code.visualstudio.com/docs/setup/linux
  • nodejs
    • https://nirsa.tistory.com/193
  • su (로그아웃 없이 계정 전환)
    • https://withcoding.com/106
  • git 설치
  • 쿠버네티스 설치 통합
    • https://www.atlantic.net/vps-hosting/how-to-install-kubernetes-with-minikube-on-centos-8/
  • kubectl
    • https://kubernetes.io/docs/tasks/tools/install-kubectl-linux/
  • minikube
    • https://minikube.sigs.k8s.io/docs/start/
    • https://minikube.sigs.k8s.io/docs/drivers/docker/
    • https://waspro.tistory.com/587
    • https://m.blog.naver.com/noggame/222046965262
  • docker
    • https://docs.docker.com/engine/install/centos/#installation-methods
    • https://sidepower.tistory.com/124
    • https://docs.docker.com/engine/install/linux-postinstall/
    • https://www.leafcats.com/190

Reference

This post is licensed under CC BY 4.0 by the author.
Contents