호짱의 개발 블로그

[PostgreSQL] 자동증가 값 초기화 SELECT SETVAL('{테이블명}_{컬럼명}_seq', 1, FALSE); 확인하는 방법은 pgAdmin 기준으로Schememas => public => Sequences 메뉴로 가면 시퀀스 항목을 볼 수 있다.

[PostgreSQL] the environment variable comspec does not seem to point to the cmd.exe There has been an error. The environment variable COMSPEC does not seem to point to the cmd.exe or there is a trailing semicolon present. Please fix this variable and restart installation. PostgreSQL 설치 중 위와 같은 오류가 나왔을 때 해결방법 https://babyadventure.tistory.com/57 Windows 11 PostgreSQL 설치 오류PostgreSQL을 공부하기 위해 공식 홈..

[Linux] 사용자 루트 폴더 격리 https://help.ishosting.com/en/how-to-restrict-ssh-user-access-to-a-specific-directory How to Restrict SSH User Access to a Specific Directory?There are many reasons for granting user permissions only to certain directories, especially for web servers. But the main reason is security. You can use chroot (change root) to restrict user accesshelp.ishosting.com https://www.tecmi..