사용중인 데이터베이스 보기,변경
| \c [database_name] |
데이터베이스 내의 테이블 목록 보기(상세)
| \dt \dt+ |
테이블의 형태보기(컬럼별)
| \d [table_name] \d+ [table_name] |
[링크 : https://www.postgresqltutorial.com/postgresql-administration/postgresql-show-tables/]
| postgresql permission denied for schema public (0) | 2024.07.25 |
|---|---|
| 라즈베리에 phppgadmin. 안되잖아? (0) | 2024.07.24 |
| phppgadmin (0) | 2024.07.23 |
| postgresql 15.7 on rpi (0) | 2024.07.22 |
| postgresql cli (0) | 2024.07.21 |
계정생성하고 database생성하고 테이블 만들려는데.. 어라?
| ERROR: permission denied for schema public |
찾아보니 권한과 소유권을 둘 다 줘야 가능한 듯.
권한만 줘서는 동일한 에러가 발생한다.
| GRANT ALL ON DATABASE mydb TO admin; ALTER DATABASE mydb OWNER TO admin; |
[링크 : https://stackoverflow.com/questions/74110708/postgres-15-permission-denied-for-schema-public]
| postgresql 리스트 명령 (0) | 2024.07.25 |
|---|---|
| 라즈베리에 phppgadmin. 안되잖아? (0) | 2024.07.24 |
| phppgadmin (0) | 2024.07.23 |
| postgresql 15.7 on rpi (0) | 2024.07.22 |
| postgresql cli (0) | 2024.07.21 |
접속 시도해보니 안되길래
버전 확인
| phpPgAdmin 7.13.0 (PHP 8.2.7) |
postgresql은 아래와 같은데..
| $ psql --version psql (PostgreSQL) 15.7 ( 15.7-0+deb12u1) |
그래서 phpPgAdmin 버전으로 찾아보니..
7.13.0 이후로는 안나오는것 같고(2020년 11월 9일.. 4년 가까이 과거..)
그 당시 지원되는게 Postgres 13 / 14.. 15니 될리가 없었...나?
| phpPgAdmin 7.13.0 Now Available! Posted on 2020-11-09 by phpPgAdmin Project Related Open Source I’m pleased to announce the latest release of phpPgAdmin, version 7.13.0. This release incorporates the following changes: Add support for Postgres 13 Add provisional support for Postgres 14 Upgrade Jquery library to 3.4.1 (Nirgal) Allow users to see group owned databases when using “owned only” Fix bug where sorting on selects dumped you to the table screen (MichaMEG) |
[링크 : https://www.postgresql.org/about/news/phppgadmin-7130-now-available-2107/]
죽은 프로젝트 인 듯.. 걍 사용을 포기하는게 낫겠다..
| postgresql 리스트 명령 (0) | 2024.07.25 |
|---|---|
| postgresql permission denied for schema public (0) | 2024.07.25 |
| phppgadmin (0) | 2024.07.23 |
| postgresql 15.7 on rpi (0) | 2024.07.22 |
| postgresql cli (0) | 2024.07.21 |
pgadmin은 써봐도 phppgadmin은 첨인가...
[링크 : https://www.rosehosting.com/blog/how-to-install-phppgadmin-on-ubuntu-22-04/]
+
생각해보니 pgadmin 이라고 웹기반으로 하는 녀석이었지
phpmyadmin 처럼 apache에서 웹을 띄워서 하진 않았던 것 같다.
| postgresql permission denied for schema public (0) | 2024.07.25 |
|---|---|
| 라즈베리에 phppgadmin. 안되잖아? (0) | 2024.07.24 |
| postgresql 15.7 on rpi (0) | 2024.07.22 |
| postgresql cli (0) | 2024.07.21 |
| psql copy to (0) | 2020.02.10 |
예전에 해봤는데 안되길래 포기했던 녀석들..
이제는 시간이 지났으니 잘 되려나?
ssh -D
[링크 : https://superuser.com/questions/408031/differences-between-ssh-l-to-d]
wget은 socks proxy 미지원,curl 사용 필요
[링크 : https://askubuntu.com/questions/1327783/can-you-set-socks5-proxy-from-linux-command-line]
--proxy-server="socks5://myproxy:8080"
[링크 : https://www.chromium.org/developers/design-documents/network-stack/socks-proxy/]
[링크 : https://thesafety.us/proxy-setup-chrome-windows]
[링크 : https://datawookie.dev/blog/2023/12/ssh-tunnel-dynamic-port-forwarding/]
| ssh ecdsa 미지원(ubuntu 22.04) (0) | 2023.05.30 |
|---|---|
| ubuntu ssh x11 forwarding시 gnome 화면 끌어오기 (0) | 2022.07.11 |
| ssh 슈도 터미널 실행 (0) | 2022.04.25 |
| ssh Are you sure you want to continue connecting (yes/no)? (0) | 2022.04.25 |
| sshd 에서 ssh 로그인 끄고 sftp만 허용하기 (0) | 2022.04.01 |
예전 centos 할 때 랑은 또 경로가 달라져서 헷갈리네
설정 변경
| # cat /etc/postgresql/15/main/pg_hba.conf local all postgres peer # TYPE DATABASE USER ADDRESS METHOD # "local" is for Unix domain socket connections only local all all md5 # IPv4 local connections: host all all 127.0.0.1/32 scram-sha-256 # IPv6 local connections: host all all ::1/128 scram-sha-256 # Allow replication connections from localhost, by a user with the # replication privilege. local replication all peer host replication all 127.0.0.1/32 scram-sha-256 host replication all ::1/128 scram-sha-256 |
서비스 재기동
| $ sudo systemctl restart postgresql |
postgres 계정으로 로그인 후 계정 및 database 생성
| pi@raspberrypi:~ $ sudo su - postgres postgres@raspberrypi:~$ psql psql (15.7 ( 15.7-0+deb12u1)) Type "help" for help. postgres=# create user username with password 'userpassword'; CREATE ROLE postgres=# create database userdb; CREATE DATABASE materials=> \q postgres@raspberrypi:~$ |
일반 계정에서 특정 사용자로 로그인
| pi@raspberrypi:~ $ psql -U username userdb Password for user username: psql (15.7 ( 15.7-0+deb12u1)) Type "help" for help. userdb=> \q |
[링크 : https://zipeya.tistory.com/entry/postgresql-DB생성-및-접속-시-Peer-authentication에러-발생-시-해야할-것]
| 라즈베리에 phppgadmin. 안되잖아? (0) | 2024.07.24 |
|---|---|
| phppgadmin (0) | 2024.07.23 |
| postgresql cli (0) | 2024.07.21 |
| psql copy to (0) | 2020.02.10 |
| postgresql 제약조건 관련 (0) | 2020.02.07 |
이전에는 대부분 pgadmin 이라는 웹기반으로 사용하다 보니 콘솔에서 쓸 방법 찾는 중
[링크 : https://www.postgresql.org/docs/current/app-psql.html]
[링크 : https://kwomy.tistory.com/m/9]
[링크 : https://kugancity.tistory.com/m/entry/postgre-sql-command-line에서-사용하기]
| phppgadmin (0) | 2024.07.23 |
|---|---|
| postgresql 15.7 on rpi (0) | 2024.07.22 |
| psql copy to (0) | 2020.02.10 |
| postgresql 제약조건 관련 (0) | 2020.02.07 |
| postgresql database / table 복제 및 동기화 (0) | 2020.02.07 |
meld 에서 항상 옆으로 길게 보이다 보니 어떻게 설정을 해야 하나 찾아보는데
용어가 나중에 겨우 기억나서 검색..
word wrap
아무튼 Meld - Preference - 편집기 - 표시 에서
Enable text wrapping 과
Do not split words over two lines 를 체크해주면 된다.
[링크 : https://superuser.com/questions/1716173/meld-wrap-lines-keep-whole-words]
| meld for windows 비교 내용이 안나오는 문제 (0) | 2014.03.31 |
|---|---|
| meld for windows (0) | 2014.03.31 |
| meld 에서 문법강조 켜기(syntax highlighter on Meld) (0) | 2011.10.15 |
| meld - GUI merge tool for linux (0) | 2009.04.06 |
| GUI diff tool - meld (6) | 2009.02.13 |
x86 에서 arm을 qemu를 통해 해보고 싶어져서 찾아보는 중
| $ sudo apt install qemu-system-arm |
[링크 : https://ubuntu.com/server/docs/boot-arm64-virtual-machines-on-qemu]
| $ sudo apt-get install gcc-arm-linux-gnueabihf libc6-dev-armhf-cross qemu-user-static |
[링크 : https://gist.github.com/luk6xff/9f8d2520530a823944355e59343eadc1]
| colo qemu (0) | 2019.03.25 |
|---|---|
| qcow2 (0) | 2019.02.01 |
| qemu on windows (0) | 2012.04.24 |
| qemu 사용하기 (0) | 2012.04.11 |
| qemu / qemu-launcher (0) | 2012.04.08 |
아.. 역시 컴퓨터를 바꾸면 잘되는구나.. (어?)
심심해서 키넥트 본체는 연결안하고 허브만 연결했더니 당연하게(?) 허브만 뜬다.
파란 부분은 키넥트 본체를 꼽아야만 뜨는 부분
| $ sudo dmesg -w [ 1780.341670] usb 4-4: new SuperSpeed USB device number 8 using xhci_hcd [ 1781.804378] usb 3-4: new high-speed USB device number 7 using xhci_hcd [ 1781.954783] usb 3-4: New USB device found, idVendor=045e, idProduct=02d9, bcdDevice= 0.70 [ 1781.954794] usb 3-4: New USB device strings: Mfr=1, Product=2, SerialNumber=0 [ 1781.954797] usb 3-4: Product: NuiSensor Adaptor [ 1781.954800] usb 3-4: Manufacturer: Microsoft Corporation [ 1781.955676] hub 3-4:1.0: USB hub found [ 1781.955807] hub 3-4:1.0: 1 port detected [ 1783.324924] usb 4-4: New USB device found, idVendor=045e, idProduct=02d9, bcdDevice= 0.73 [ 1783.324936] usb 4-4: New USB device strings: Mfr=1, Product=2, SerialNumber=0 [ 1783.324940] usb 4-4: Product: NuiSensor Adaptor [ 1783.324942] usb 4-4: Manufacturer: Microsoft Corporation [ 1783.326192] hub 4-4:1.0: USB hub found [ 1783.326380] hub 4-4:1.0: 1 port detected [ 1783.808453] usb 4-4.1: new SuperSpeed USB device number 9 using xhci_hcd [ 1783.829395] usb 4-4.1: New USB device found, idVendor=045e, idProduct=02d8, bcdDevice= 1.00 [ 1783.829404] usb 4-4.1: New USB device strings: Mfr=1, Product=2, SerialNumber=4 [ 1783.829408] usb 4-4.1: Product: Xbox NUI Sensor [ 1783.829410] usb 4-4.1: Manufacturer: Microsoft [ 1783.829413] usb 4-4.1: SerialNumber: 501441643042 |
빌드하고 실행하니
| ~/src/libfreenect2/build/bin$ ./Protonect Version: 0.2.0 Environment variables: LOGFILE=<protonect.log> Usage: ./Protonect [-gpu=<id>] [gl | cl | clkde | cuda | cudakde | cpu] [<device serial>] [-noviewer] [-norgb | -nodepth] [-help] [-version] [-frames <number of frames to process>] To pause and unpause: pkill -USR1 Protonect [Info] [Freenect2Impl] enumerating devices... [Info] [Freenect2Impl] 10 usb devices connected [Info] [Freenect2Impl] found valid Kinect v2 @4:5 with serial 501441643042 [Info] [Freenect2Impl] found 1 devices libva info: VA-API version 1.14.0 libva error: vaGetDriverNameByIndex() failed with unknown libva error, driver_name = (null) [Error] [VaapiRgbPacketProcessorImpl] vaInitialize(display, &major_ver, &minor_ver): unknown libva error [Info] [Freenect2DeviceImpl] opening... [Info] [Freenect2DeviceImpl] transfer pool sizes rgb: 20*16384 ir: 60*8*33792 [Info] [Freenect2DeviceImpl] opened [Info] [Freenect2DeviceImpl] starting... [Debug] [Freenect2DeviceImpl] status 0x090000: 9729 [Debug] [Freenect2DeviceImpl] status 0x090000: 9731 [Info] [Freenect2DeviceImpl] submitting rgb transfers... [Info] [Freenect2DeviceImpl] submitting depth transfers... [Debug] [DepthPacketStreamParser] not all subsequences received 0 [Info] [Freenect2DeviceImpl] started device serial: 501441643042 device firmware: 4.0.3911.0 [Debug] [DepthPacketStreamParser] not all subsequences received 768 [Debug] [DepthPacketStreamParser] skipping depth packet [Debug] [DepthPacketStreamParser] skipping depth packet [Debug] [DepthPacketStreamParser] skipping depth packet [Debug] [DepthPacketStreamParser] skipping depth packet [Debug] [DepthPacketStreamParser] skipping depth packet [Debug] [DepthPacketStreamParser] skipping depth packet [Info] [DepthPacketStreamParser] 6 packets were lost [Info] [OpenGLDepthPacketProcessor] avg. time: 16.9263ms -> ~59.0797Hz [Info] [TurboJpegRgbPacketProcessor] avg. time: 15.0939ms -> ~66.2519Hz [Info] [OpenGLDepthPacketProcessor] avg. time: 14.96ms -> ~66.8449Hz [Info] [TurboJpegRgbPacketProcessor] avg. time: 15.5262ms -> ~64.4071Hz [Info] [OpenGLDepthPacketProcessor] avg. time: 14.8158ms -> ~67.4954Hz [Info] [TurboJpegRgbPacketProcessor] avg. time: 15.8073ms -> ~63.2617Hz [Info] [OpenGLDepthPacketProcessor] avg. time: 14.3364ms -> ~69.7524Hz [Info] [TurboJpegRgbPacketProcessor] avg. time: 16.633ms -> ~60.1215Hz |
잘나온다. 저번에 10세대에서는 카메라 영상(좌하단)과 3d로 재구성된 영상(우상단)이 찌그러지던데, 무슨 차이이려나?
| libfreenect2 실행 성공.. (0) | 2024.07.15 |
|---|---|
| libfreenect2 실행 실패 (0) | 2024.07.14 |
| libfreenect2 CUDA 끄고 빌드 성공 (0) | 2024.07.13 |
| kinect v2 / freenect 실패 (0) | 2024.07.09 |
| xbox one S / 기본형? (0) | 2024.06.25 |
|
