If the following error occurs when you start Postgresql, /var/log/messages May 24 10:25:10 your_server_name postmaster[76948]: 2021-05-24 10:25:10.895 JST [76948] FATAL: data directory "/data" has group or world access May 24 10:25:10 your_server_name postmaster[76948]: 2021-05-24 10:25:10.895 JST [76948] DETAIL: Permissions should be u=rwx (0700). Change a permission of the directory # sudo chm..
su - root vi /etc/postgresql/{Version}/main/pg_hba.conf 에서 아래 구문 추가host all all 0.0.0.0/0 md5 vi /etc/postgresql/{Version}/main/postgresql.conf 에서 아래 구문 추가listen_addresses = '*' # what IP address(es) to listen on; 재시작/etc/init.d/posgresql restart
SELECT 111 ~ E'^[-+]?\\d*\\.?\\d+(?:[eE][-+]?\\d+)?$' FROM dual --결과 값 : t SELECT 1.11 ~ E'^[-+]?\\d*\\.?\\d+(?:[eE][-+]?\\d+)?$' FROM dual --결과 값 : t SELECT -111 ~ E'^[-+]?\\d*\\.?\\d+(?:[eE][-+]?\\d+)?$' FROM dual --결과 값 : t SELECT 'aaa' ~ E'^[-+]?\\d*\\.?\\d+(?:[eE][-+]?\\d+)?$' FROM dual --결과 값 : f --t : true f : false
- Total
- Today
- Yesterday
- Nexus
- PostgreSQL
- Playbook
- rsync
- 리눅스
- groovy
- Password manager
- 쓰레드덤프
- ssl
- URL Encoding
- Config History
- DevOps
- Linux
- Ansible
- vagrant
- 쉘스크립트
- iTerm2
- Thread Dump
- 플레이북
- Jenkins
- openssl
- JVM
- 엔시블
- Docker
- 엔서블
- 젠킨스
- Shell Script
- nginx
- 데브옵스
- 파이프라인
일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | 6 | |
7 | 8 | 9 | 10 | 11 | 12 | 13 |
14 | 15 | 16 | 17 | 18 | 19 | 20 |
21 | 22 | 23 | 24 | 25 | 26 | 27 |
28 | 29 | 30 |