rgreenjr

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

oakes

Contents

• Why care about Rust?
• The Toolchain
• Creating a New Project
• Modules
• Crates
• Types
• References
• Mutability

mcritchlow

References

• Zoom Download: https://zoom.us/client/latest/zoom_x86_64.tar.xz
• Zoom Instructions: https://support.zoom.us/hc/en-us/articles/204206269-Linux-Installation

Download zoom and extract

curl -LO https://zoom.us/client/latest/zoom_x86_64.tar.xz
tar -xvf zoom*.tar.xz

OdinsPlasmaRifle

Arch Linux Installation

LVM on LUKS Arch installation with systemd-boot

Sources:

• https://wiki.archlinux.org/index.php/Installation_guide
• https://wiki.archlinux.org/index.php/Dm-crypt/Encrypting_an_entire_system

Note: If you want a simpler encryption setup (with LUKS only), you can instead use the archinstall "guided" installer included with Arch since April 2021.

styblope

Enable TCP port 2375 for external connection to Docker

See this issue.
Docker best practise to Control and configure Docker with systemd.

1. Create daemon.json file in /etc/docker:

    {"hosts": ["tcp://0.0.0.0:2375", "unix:///var/run/docker.sock"]}
   

LinuxBozo

#!/bin/bash

set -e

BOSH_DEPLOYMENT_PATH="../../bosh-deployment"

# clean up
(cd "$BOSH_DEPLOYMENT_PATH" && git pull)
rm -rf state.json
for uuid in $(VBoxManage list vms|grep -E ^\"sc- | awk '{print $2}' | sed 's/{//' | sed 's/}//'); do

ibihim

# Installation on Lenovo X1 5th Generation

# Installation guide: https://wiki.archlinux.org/index.php/Installation_Guide
# Encryption: https://wiki.archlinux.org/index.php/Dm-crypt/Device_encryption#Cryptsetup_usage
# LVM: https://wiki.archlinux.org/index.php/LVM

# Set large font, if necessary
setfont latarcyrheb-sun32

# Connect to Internet

kynrai

Arch (i3-gaps) on Rzer Blade 13 2019 MX 150

Prerequisites

• Disbale secure boot (F12/Del on boot, BIOS)
• Create UEFI boot disk

Boot from USB

1. Set UK layout loadkeys uk

fjpalacios

Arch + i3-gaps Install Guide

First set up your keyboard layout. For example, in Spanish:

   # loadkeys es

For a list of all acceptable keymaps:

   # localectl list-keymaps

amir-saniyan

Ubuntu 22.04 for Deep Learning

In the name of God

This gist contains steps to setup Ubuntu 22.04 for deep learning.

---

Install Ubuntu 22.04