오픈소스의 일상

CREATE OR REPLACE FUNCTION [스키마].[Function명] ( [변수] varchar ) RETURNS TABLE ( ex_string text, ex_area numeric) AS $BODY$ DECLARE -- 변수 선언구문 추가 BEGIN -- 로직 추가 RETURN query EXECUTE 'SELECT ex_string as ex_string, ex_area as ex_area FROM [테이블명]'; END $BODY$ LANGUAGE plpgsql VOLATILE COST 100 Function 리턴값을 Table 주의할 점 Function을 활용하여 쿼리 결과값을 테이블구조로 받을 싶을때는 꼭 리턴조건에 RETURNS TABLE ( ex_string text, ex_a..

1. 설치 참고 : https://postgrest.org/en/stable/tutorials/tut0.html#step-3-install-postgrest Tutorial 0 - Get it Running — PostgREST 9.0.0 documentation Welcome to PostgREST! In this pre-tutorial we’re going to get things running so you can create your first simple API. PostgREST is a standalone web server which turns a PostgreSQL database into a RESTful API. It serves an API that is customized based..

1. vsftpd 설치 [root@flas www]# ps -ax | grep vsftpd 6334 pts/1 S+ 0:00 grep --color=auto vsftpd [root@flas www]# yum -y install vsftpd ... Dependencies Resolved ======================================================================================================== Package Arch Version Repository Size ================================================================================================..

psql -h flas -d flas_db -U flas_gis -d idn_point_5181.dump 조만간 자세히 작성하겠습니다.

1. httpd 설치 및 정상설치 여부 확인 [root@flas ~]# yum install -y httpd Loaded plugins: fastestmirror, langpacks Loading mirror speeds from cached hostfile * base: mirror.kakao.com * centos-sclo-rh: mirror.kakao.com * epel: mirrors.nipa.cloud * extras: mirror.kakao.com * updates: mirror.kakao.com Resolving Dependencies --> Running transaction check ---> Package httpd.x86_64 0:2.4.6-97.el7.centos.2 will be ..

[root@flas ~]# yum install java-1.8.0-openjdk [root@flas ~]# yum install java-1.8.0-openjdk-devel -- 들어가서 설치위치 확인 [root@flas ~]# cd /usr/lib/jvm/ --환경변수 등록 [root@flas ~]# readlink -f /usr/bin/java /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.312.b07-1.el7_9.x86_64 -- JAVA_HOME, PATH, CLASSPATH 등록 [root@flas ~]# vi /etc/profile .... JAVA_HOME=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.312.b07-1.el7_9.x86_64 ..

1. 계정생성 및 비밀번호 변경 [root@flas ~]# su - postgres Last login: Wed Dec 22 08:55:09 KST 2021 on pts/0 -- 사용자 생성 -bash-4.2$ createuser 사용자ID -- 디비 생성 및 사용자 할당 -bash-4.2$ createdb flas_db -O 사용자ID -bash-4.2$ psql -d flas_db psql (11.14) Type "help" for help. -- 비밀번호 변경 flas_db=# alter user postgres with password '비밀번호'; ALTER ROLE -- 비밀번호 변경 flas_db=# alter user 사용자ID with password '비밀번호'; ALTER ROLE f..

1. PostGIS 3.1.X 설치 및 확인 - PostGIS는 민감하기에 설치과정을 전부 표기함 [root@flas /]# yum install postgis31_11.x86_64 -y Loaded plugins: fastestmirror, langpacks Loading mirror speeds from cached hostfile * base: mirror.kakao.com * centos-sclo-rh: mirror.kakao.com * epel: mirrors.nipa.cloud * extras: mirror.kakao.com * updates: mirror.kakao.com Resolving Dependencies --> Running transaction check ---> Package p..

1. libxml2-devel [root@flas /]# yum install libxml2-devel -y Loaded plugins: fastestmirror, langpacks Loading mirror speeds from cached hostfile * base: mirror.kakao.com * extras: mirror.kakao.com * updates: mirror.kakao.com Resolving Dependencies --> Running transaction check ---> Package libxml2-devel.x86_64 0:2.9.1-6.el7_9.6 will be installed --> Processing Dependency: zlib-devel for package:..

1. Centos 업데이트 [root@flas ~]# yum update -y Loaded plugins: fastestmirror, langpacks Determining fastest mirrors * base: mirror.kakao.com * extras: mirror.kakao.com * updates: mirror.kakao.com base | 3.6 kB 00:00 extras | 2.9 kB 00:00 updates | 2.9 kB 00:00 (1/4): base/7/x86_64/group_gz | 153 kB 00:00 (2/4): extras/7/x86_64/primary_db | 243 kB 00:00 (3/4): base/7/x86_64/primary_db | 6.1 MB 00:00..