Komzpa

{# ============================
   SENSOR INPUTS (edit entity_ids if needed)
   ============================ #}

{% set s_occ_air      = 'sensor.living_room_occupied_temperature_10_min' %}
{% set s_work_air     = 'sensor.workplace_temperature' %}
{% set s_floor_min    = 'sensor.living_room_floor_min_temperature' %}

{% set s_floor_surface = 'sensor.living_room_floor_temperature' %}
{% set s_floor_max     = 'sensor.living_room_floor_max_temperature' %}

Komzpa

diff --git a/drivers/net/wireless/realtek/rtlwifi/rtl8192se/hw.c b/drivers/net/wireless/realtek/rtlwifi/rtl8192se/hw.c
index e5775b94f04eeb286f6856691f1f6f297dd7c37e..795436ae4da0e5d279bc6023426a97d34635b6b4 100644
--- a/drivers/net/wireless/realtek/rtlwifi/rtl8192se/hw.c
+++ b/drivers/net/wireless/realtek/rtlwifi/rtl8192se/hw.c
@@ -1019,51 +1019,62 @@ int rtl92se_hw_init(struct ieee80211_hw *hw)
 	}
 
 	/* After read predefined TXT, we must set BB/MAC/RF
 	 * register as our requirement */
 

Komzpa

rest:
  resource: https://rpc-ger.aqara.com/app/v1.0/lumi/res/query
  method: POST
  scan_interval: 3
  headers:
      Sys-Type: 1
      Appid: FIXME
      Userid: FIXME
      Token: FIXME
      Content-Type: application/json; charset=utf-8

Komzpa

create or replace procedure trim_osm_users_h3()
    language plpgsql
as
$$
declare
    cur_rec      record;
    counter      integer;
    total_rec    integer;
    last_seen    timestamptz;
    last_cluster timestamptz;

Komzpa

-----------------------------------------------------------------
  pg_upgrade run on Sat Jun 22 22:08:45 2019
-----------------------------------------------------------------

command: "/usr/lib/postgresql/11/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/etc/postgresql/11/main" -o "-p 5432 -b  -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directories='/var/log/postgresql/pg_upgradecluster-11-12-main.LvO0'" start >> "pg_upgrade_server.log" 2>&1
waiting for server to start....2019-06-22 22:08:45.798 +03 [28771] LOG:  listening on Unix socket "/var/log/postgresql/pg_upgradecluster-11-12-main.LvO0/.s.PGSQL.5432"
2019-06-22 22:08:45.952 +03 [28772] LOG:  database system was shut down at 2019-06-22 22:08:44 +03
2019-06-22 22:08:45.959 +03 [28771] LOG:  database system is ready to accept connections
 done
server started

Komzpa

create or replace function is_done(g int[])
    returns boolean
as
$$
select exists(
               select
               from (
                        select array [g[1], g[3], g[5], g[7], g[9]]::int[] as moves
                        union all
                        select array [g[2], g[4], g[6], g[8]]::int[] as moves

Komzpa

create or replace function http_get(url text)
    returns text
as $$
import urllib.request
return urllib.request.urlopen(url).read().decode('utf-8')
$$
language plpython3u
parallel safe
cost 10000;

Komzpa

SELECT ST_Area(the_geom) As sqft, ST_Area(ST_Transform(the_geom,26986)) As sqm
		FROM (SELECT
		ST_GeomFromText('POLYGON((743238 2967416,743238 2967450,
			743265 2967450,743265.625 2967416,743238 2967416))',2249) ) As foo(the_geom);
  sqft   |       sqm
---------+------------------
 928.625 | 86.2724304199219      
      
      19:03:21 [kom] > SELECT ST_Area(the_geom) As sqft, ST_Area(ST_Transform(the_geom,26986)) As sqm
[more] - >   FROM (SELECT

Komzpa

kom@nucat:~/proj/postgis/regress/00-regress-install/lib$ ldd *.so
postgis-3.so:
        linux-vdso.so.1 (0x00007ffc989cc000)
        libgeos_c.so.1 => /usr/lib/x86_64-linux-gnu/libgeos_c.so.1 (0x00007fb47e95e000)
        libproj.so.13 => /usr/lib/x86_64-linux-gnu/libproj.so.13 (0x00007fb47e8e7000)
        libjson-c.so.3 => /lib/x86_64-linux-gnu/libjson-c.so.3 (0x00007fb47e6dc000)
        libxml2.so.2 => /usr/lib/x86_64-linux-gnu/libxml2.so.2 (0x00007fb47e534000)
        libSFCGAL.so.1 => /usr/lib/x86_64-linux-gnu/libSFCGAL.so.1 (0x00007fb47dd00000)
        libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007fb47db16000)
        libgeos-3.7.0.so => /usr/lib/x86_64-linux-gnu/libgeos-3.7.0.so (0x00007fb47d957000)

Komzpa

chmod a+x ~
apt update
apt install build-essential autoconf automake libtool postgresql-server-dev-all libxml2-dev libgeos-dev libproj-dev libxml2-utils xsltproc bison postgresql-10
service postgresql start
su postgres -c 'createuser root'
su postgres -c 'psql -d postgres -c "alter user root superuser;"'
git clone git@github.com:postgis/postgis.git
cd postgis
./autogen.sh
./configure --without-raster