Skip to content

Instantly share code, notes, and snippets.

View learntheropes's full-sized avatar
🏠
Working from home

Giovanni learntheropes

🏠
Working from home
32 followers · 38 following
View GitHub Profile
@learntheropes
learntheropes / change_password.sh
Created January 31, 2024 11:38
postgres change default user password
$ sudo -u postgres psql
psql (14.1 (Ubuntu 14.1-2.pgdg20.04+1))
Type "help" for help.
postgres=# \password postgres
Enter new password:
Enter it again:
@learntheropes
learntheropes / create_postgres_email_extension.sh
Created January 31, 2024 15:28
CREATE EXTENSION citext;
CREATE DOMAIN email AS citext
CHECK ( value ~ '^[a-zA-Z0-9.!#$%&''*+/=?^_`{|}~-]+@[a-zA-Z0-9](?:[a-zA-Z0-9-]{0,61}[a-zA-Z0-9])?(?:\.[a-zA-Z0-9](?:[a-zA-Z0-9-]{0,61}[a-zA-Z0-9])?)*$' );
@learntheropes
learntheropes / update_time
Created February 29, 2024 17:25
update time
sudo ntpdate -b time.nist.gov
@learntheropes
learntheropes / gist:e9d91e6b4d3d7b83a7e5e35e38f8cc98
Created January 10, 2025 17:36
2025-01-10 17:00:06.147 [INF] GRPH: Processed channels=0 updates=67 nodes=33 in last 59.999201246s
2025-01-10 17:01:06.148 [INF] GRPH: Processed channels=0 updates=109 nodes=0 in last 59.999698732s
2025-01-10 17:02:06.148 [INF] GRPH: Processed channels=0 updates=90 nodes=38 in last 1m0.000524585s
2025-01-10 17:03:06.148 [INF] GRPH: Processed channels=0 updates=99 nodes=4 in last 59.999054626s
2025-01-10 17:04:06.148 [INF] GRPH: Processed channels=0 updates=78 nodes=21 in last 59.999283795s
2025-01-10 17:05:06.148 [INF] GRPH: Processed channels=0 updates=75 nodes=58 in last 1m0.000323368s
2025-01-10 17:06:06.148 [INF] GRPH: Processed channels=0 updates=70 nodes=17 in last 59.999370151s
2025-01-10 17:07:06.148 [INF] GRPH: Processed channels=0 updates=137 nodes=16 in last 59.999786356s
2025-01-10 17:08:06.148 [INF] GRPH: Processed channels=0 updates=90 nodes=50 in last 59.999011296s
2025-01-10 17:09:06.148 [INF] GRPH: Processed channels=0 updates=92 nodes=0 in last 59.998882544s