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)
# 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.
$ 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로 재구성된 영상(우상단)이 찌그러지던데, 무슨 차이이려나?