Góp nhặt của một kẻ mù công nghệ :p
PostgreSQL – Terminate Client Connect View To fix FATAL: sorry, too many clients already connection to server https://dothanhlong.org/postgresql-fatal-sorry-too-many-clients-already-connection-to-server/ — View: public.terminate_client_connect — DROP VIEW public.terminate_client_connect; CREATE OR REPLACE VIEW public.terminate_client_connect AS SELECT pg_terminate_backend(pg_stat_activity.pid) AS pg_terminate_backend FROM pg_stat_activity WHERE pg_stat_activity.pid <> […]
[PostgreSQL] FATAL: sorry, too many clients already connection to server Unable to connect to PostgreSQL server: connection to server at "DB hostname" (DB IP), port DB port failed: FATAL: sorry, too many clients already connection to server at "DB hostname" […]
Can’t start Android emulator device Err info Fix Remove or Rename this folder, then start Android emulator device When Android emulator device started, it will re-create this folder
IONIC – Build IOS 2023 https://ionicframework.com/docs/developing/ios Install Nodejs16 Phải Nodejs16 mới được, bản nodejs17 đang lỗi ERR_OSSL_EVP_UNSUPPORTED chưa có cách sửa https://stackoverflow.com/questions/11177954/how-do-i-completely-uninstall-node-js-and-reinstall-from-beginning-mac-os-x sudo rm -rf /usr/local/{lib/node{,/.npm,_modules},bin,share/man}/{npm,node,man1/node*} nvm uninstall v17.4.0 // check version node -v || node –version // list installed […]
Kinh tuyến trục hệ tọa độ Quốc gia VN2000 của các tỉnh Kinh tuyến trục hệ tọa độ Quốc gia VN2000 là gì? Kinh tuyến trục hệ tọa độ Quốc gia VN2000 là một đường kinh tuyến trên bề mặt […]
nvm use does not switch node versions I had to delete the folder located at C:\Program Files\nodejs: And then run nvm use {version} again to repopulate this folder with the correct node version. I suspect that nvm is having trouble deleting this folder […]
[MySQL] Fix Column count of mysql.proc is wrong Err Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100108, now running 100424. Please use mysql_upgrade to fix this error Fix Column count of mysql.proc is wrong […]
[Moodle Edash] Fix Deprecated: preg_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated Err info Deprecated: preg_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated… theme/edash/renderers/course-renderer.php on line 53 Fix Deprecated: preg_replace(): Passing null […]
Make and Update SEQUENCE in PostgreSQL – GeoServer WMST with Image mosaicking plugin Create Table, Index, SEQUENCE, COMMENT DROP TABLE IF EXISTS "img_lst"; DROP SEQUENCE IF EXISTS raster.img_lst_fid_seq; CREATE SEQUENCE raster.img_lst_fid_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE […]
How do I retrieve a single image from an ImageMosaic in GeoServer? http://host/geoserver16/thuyvanphuyen/wms?SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&FORMAT=image/jpeg&TRANSPARENT=true&STYLES&LAYERS=thuyvanphuyen:tansuat&exceptions=application/vnd.ogc.se_inimage&CQL_FILTER=location ILIKE '%tanSuat_2.tif%'&SRS=EPSG:32648&WIDTH=719&HEIGHT=768&BBOX=960076.6733640843,1461071.1000853349,966938.760914211,1468400.8403335926 https://gis.stackexchange.com/questions/363483/how-do-i-retrieve-a-single-image-from-an-imagemosaic-in-geoserver
IONIC Build IOS 2023 – Stuck on White Screen after splash screen Fix IONIC IOS Stuck on White Screen after splash screen ionic cordova platform add ios ionic cordova platform remove ios ionic cordova platform add ios@latest ionic cordova prepare […]
Docker truncate logs truncate -s 0 /var/lib/docker/containers/**/*-json.log sudo sh -c "truncate -s 0 /var/lib/docker/containers/*/*-json.log" sudo truncate -s 0 `docker inspect –format='{{.LogPath}}' f7ea99211cf3c10fa86cfb78824485f20933b8cdfa35ca542c88c4b15310427e` sudo sh -c 'truncate -s 0 /var/lib/docker/containers/*/*-json.log'
PostgreSQL – Column to Json/Jsonb I have a table coso_nhayen like this row_to_json select row_to_json(row) from (select * from coso_nhayen) row LIMIT 5; to_jsonb SELECT id, to_jsonb(t.*) – 'id' AS data FROM coso_nhayen t LIMIT 5; json_agg SELECT json_agg(t) FROM coso_nhayen t; […]
Fix docker application stop when window goes to sleep A dockerized DOC application is running on Windows 10. After some time during which the computer has switched to sleep-mode, the application stopped working. The problem is that security tokens are […]
Fix The repository no longer has a Release file on Ubuntu Xử lý lỗi The repository no longer has a Release file trên Ubuntu https://azdigi.com/blog/linux-server/the-repository-no-longer-has-a-release-file/ I. Giới thiệu và nguyên nhân Trong quá trình sử dụng hệ điều hành Ubuntu […]