Title: PostGIS 2.0 Cheatsheet CSS : css/cheaters.css
Permalink to PostGIS 2.0 Cheatsheet
PostgreSQL PostGIS Geometry/Geography/Box Types |
---|
-- show running queries (pre 9.2) | |
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query | |
FROM pg_stat_activity | |
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' | |
ORDER BY query_start desc; | |
-- show running queries (9.2) | |
SELECT pid, age(clock_timestamp(), query_start), usename, query | |
FROM pg_stat_activity | |
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' |
Title: PostGIS 2.0 Cheatsheet CSS : css/cheaters.css
Permalink to PostGIS 2.0 Cheatsheet
PostgreSQL PostGIS Geometry/Geography/Box Types |
---|
### | |
### | |
### UPDATE: For Win 11, I recommend using this tool in place of this script: | |
### https://christitus.com/windows-tool/ | |
### https://github.com/ChrisTitusTech/winutil | |
### https://www.youtube.com/watch?v=6UQZ5oQg8XA | |
### iwr -useb https://christitus.com/win | iex | |
### | |
### |
curl -Ls http://bit.ly/go_installer | bash
If you want to install golang, normally you are following the description on the official dowload page
A quick and dirty syntax translation / conversion reference guide to ease the transition between Python and Julia. This is not meant as a reference to the language. For that you should read the manual.
zfs create -o volblocksize=32k -V 10G tslpool/iscsi1 | |
zfs set sync=disabled tslpool/iscsi1 | |
targetcli | |
block/ create name=block_backend dev=/dev/zvol/tslpool/iscsi1 | |
cd /iscsi | |
create iqn.2017-11.com.mydomain.ad.zfstest:iscsidisk1 | |
cd /iscsi/iqn.2017-11.com.mydomain.ad.zfstest:iscsidisk1/tpg1/acls | |
# create acl with the initiator (client) name here, not the one you just created | |
create iqn.1991-05.com.microsoft:dc1.ad.mydomain.com | |
cd iqn.1991-05.com.microsoft:dc1.ad.mydomain.com |
# Update Jan 2024 | |
# Deploying Cloud Functions is much simpler than it was 6 years ago. | |
# I'm leaving the gist in it's original 2018 state for now, | |
# but skip the the recent comments below for a simpler solution. | |
variables: | |
GCP_ZONE: us-central1-a | |
stages: | |
- npm-install |
This focuses on generating the certificates for loading local virtual hosts hosted on your computer, for development only.
Do not use self-signed certificates in production ! For online certificates, use Let's Encrypt instead (tutorial).
zoomAutenticationTool
can be used to escalat