Dovydas Venckus dovydasvenckus

Install pgAdmin4 v2.0 with python3 on Ubuntu 16.04 DESKTOP mode

Get Python Wheel pgAdmin4

 wget https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v2.0/pip/pgadmin4-2.0-py2.py3-none-any.whl

Install pip3
```
 sudo apt install python3-pip
```

Here is the best setup (I think so :D) for K-series Keychron keyboards on Linux.

Most of these commands have been tested on Ubuntu 20.04 and should also work on most Debian-based distributions. If a command happens not to work for you, take a look in the comment section.

Make Fn + F-keys work

Keychron Keyboards on Linux use the hid_apple driver (even in Windows/Android mode), both in Bluetooth and Wired modes. By default, this driver uses the F-keys as multimedia shortcuts and you have to press Fn + the key to get the usual F1 through F12 keys.

	# cat activemq.service
	[Unit]
	Description=Apache ActiveMQ
	After=network-online.target

	[Service]
	Type=forking
	WorkingDirectory=/opt/activemq/bin
	ExecStart=/opt/activemq/bin/activemq start
	ExecStop=/opt/activemq/bin/activemq stop

	-- 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%'

	package de.idealo.ecommerce.order.history.config;

	import java.util.Arrays;
	import java.util.stream.StreamSupport;

	import org.slf4j.Logger;
	import org.slf4j.LoggerFactory;
	import org.springframework.context.event.ContextRefreshedEvent;
	import org.springframework.context.event.EventListener;
	import org.springframework.core.env.AbstractEnvironment;

	#!/bin/sh
	at now + 25 minutes -f break-over.sh