For count rows in each PostgreSQL table, we need to create a function and run it for all schemas
create function
cnt_rows(schema text, tablename text) returns integer
as
$body$
declare
result integer;
query varchar;
begin
query := 'SELECT count(1) FROM ' || schema || '.' || tablename;
execute query into result;
return result;
end;
$body$
language plpgsql;After upgrading the kernel to a newer kernel, OS won’t boot with a stacked message
pci 0000 : 00 : 07.0 : DPC : RP PIO log size 0 is invalid
xhci_hcd 0000 : 00 : 0d.0 : can't setup : -12
xhci hcd 0000 : 00 : 0d.0 : init 0000 : 00 : 0d.0 fail , -12
thunderbolt 0000 : 00 : 0d.2 : failed to determine connection manager , aborting
xhci hcd 0000 : 00 : 14.0 : can't setup : -12
xhci_hcd 0000 : 00 : 14.0 : init 0000 : 00 : 14.0 fail , -12
1801_smbus . 0000 : 00 : 1f.4 : Transaction timeout
1801_smbus 0000 : 00 : 1f.4 : Failed terminating the transaction
1801_smbus 0000 : 00 : 1f.4 : SMBus is busy , can't use it !
i915 0000 : 00 : 02.0 : [ drm ] * ERROR * Scratch setup failed
i915 0000 : 00 : 02.0 : Device initialization failed ( -12 )Just add to ansible.cfg module jinja2.ext.do
Install latest Chrome install NodeJS and NPM Install Lighthouse Run test
Source – https://gitlab.com/guoyunhe/plasma-cast/blob/master/stream.sh After you can use – https://github.com/balloob/pychromecast/
You can download rpm for version 3.4.14 from url zookeeper-3.4.14-1.x86_64.rpm It created from original binary from Apache Org Used: https://github.com/id/zookeeper-el7-rpm
rpm –import https://www.elrepo.org/RPM-GPG-KEY-elrepo.org dnf install https://www.elrepo.org/elrepo-release-8.0-2.el8.elrepo.noarch.rpm So, install the new kernel. :~# dnf –enablerepo=elrepo-kernel install kernel-ml Setup new Kernel to default grub2-set-default 0 grub2-mkconfig -o /boot/grub2/grub.cfg
Connect to Mikrotik via SSH and start writing text below Set global VARs Make server and client CRT Create pool, profile, interface, firewall Goto menu Files in Mikrotik admin panel and download ca.crt + client.crt + client.key Then make file SomeName.ovpn with content: Put your key and crt and change host:port vars and file auth.cfg … Читати далі
In the docs it says that it’s one of the listen addresses now Thanks. It works to put URI in of config.xml. URI like : relay://:22067/?id=EGIGXJZ-F7UOIQ2-KSYNJEB-XILHWP5-TKKIVLE-U……
For starting we need install add-apt-repository apt-get install software-properties-common python-software-properties Then install java8 sudo add-apt-repository ppa:webupd8team/java sudo apt-get update sudo apt-get install oracle-java8-installer To automatically set up the Java 8 environment variables: sudo apt-get install oracle-java8-set-default or echo “deb http://ppa.launchpad.net/webupd8team/java/ubuntu xenial main” | tee /etc/apt/sources.list.d/webupd8team-java.list echo “deb-src http://ppa.launchpad.net/webupd8team/java/ubuntu xenial main” | tee -a /etc/apt/sources.list.d/webupd8team-java.list apt-key … Читати далі