오픈소스의 일상

SQL로 공간데이터를 관리하고 있는분들만 보세요 PostGIS 2.X 사용하고 있다면 하루빨리 PostGIS 3.1.X 으로 업그레이드 시키세요. https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS UsersWikiPostgreSQLPostGIS – PostGIS Current best As of 03 September 4th, 2021 these versions are latest and give you best stable feature coverage. PostGIS Support Matrix Versions of PostgreSQL supported by which versions of PostGIS PostgreSQL versionPo..

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:..