MC빼인트와 함께

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