Leonardo Barbieri Bedendo lbbedendo

lbbedendo / awscli_describe_network_interfaces.sh

Last active November 9, 2023 20:57

awcli describe network interfaces

	--list private ip addresses from the specified <subnet-id>
	aws ec2 describe-network-interfaces --filters Name=subnet-id,Values=<subnet-id> \| jq -r '.NetworkInterfaces[].PrivateIpAddress' \| sort

	--list dependencies of a security group
	aws ec2 describe-network-interfaces --filters Name=group-id,Values=<security-group-id>

lbbedendo / delete_pod_forcefully.sh

Created April 25, 2023 19:05

Forcefully delete a kubernetes pod

kubectl delete pod <PODNAME> --grace-period=0 --force --namespace <NAMESPACE>

lbbedendo / disable_psr.sh

Last active October 1, 2023 22:25

Disable Panel Self Refresh on Pop!_OS 22.04

	#This command solves a recurrent audio problem on my Dell G3 3590
	#For some reason the audio suddenly loses definition in some random situations (during video calls, after screen blank, etc)
	sudo kernelstub -a "i915.enable_psr=0"

	#Hardware info (neofetch output):
	# ///////////// lbarbieri@pop-os
	# ///////////////////// ----------------
	# ///////*767//////////////// OS: Pop!_OS 22.04 LTS x86_64
	# //////7676767676*////////////// Host: G3 3590
	# /////76767//7676767////////////// Kernel: 6.4.6-76060406-generic

lbbedendo / update_pg_sequence.sql

Created October 19, 2023 17:57

Update PostgreSQL sequence with max(id) + 1

SELECT setval(pg_get_serial_sequence('table_name', 'id'), coalesce(max(id),0) + 1, false) FROM table_name;

lbbedendo / select_last_sequence_value_pg.sql

Created October 19, 2023 17:58

Select last value of PostgreSQL sequence

SELECT last_value FROM sequence_name;