Create a user for the replication:
$ psql postgres
postgres=# CREATE USER replica REPLICATION LOGIN ENCRYPTED PASSWORD 'so-secret';
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| RELEASE=$1 | |
| mkdir /tmp/iosevka-font/$RELEASE | |
| cd /tmp/iosevka-font/$RELEASE | |
| wget https://github.com/be5invis/Iosevka/releases/download/v$RELEASE/ttf-iosevka-$RELEASE.zip | |
| wget https://github.com/be5invis/Iosevka/releases/download/v$RELEASE/ttf-iosevka-aile-$RELEASE.zip | |
| wget https://github.com/be5invis/Iosevka/releases/download/v$RELEASE/ttf-iosevka-etoile-$RELEASE.zip | |
| wget https://github.com/be5invis/Iosevka/releases/download/v$RELEASE/ttf-iosevka-fixed-$RELEASE.zip | |
| wget https://github.com/be5invis/Iosevka/releases/download/v$RELEASE/ttf-iosevka-fixed-slab-$RELEASE.zip | |
| wget https://github.com/be5invis/Iosevka/releases/download/v$RELEASE/ttf-iosevka-slab-$RELEASE.zip |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| geo $limited { | |
| default 1; | |
| xxx.xxx.xxx/xx 0; | |
| } | |
| map $limited $limit { | |
| 1 $binary_remote_addr; | |
| 0 ""; | |
| } |
felipe3dfx
/ gist:13f6c93ab1071e214258005534efb833
Last active
June 1, 2020 22:34
Crear setval en postgres
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| create sequence enrollment_enrollmentcompany_id_seq; | |
| select max(id) from enrollment_enrollmentcompany; | |
| select setval('enrollment_enrollmentcompany_id_seq', 609, true); | |
| alter table enrollment_enrollmentcompany alter column id set default nextval('enrollment_enrollmentcompany_id_seq'); | |
| -- Option 2 | |
| CREATE sequence enrollment_enrollmentcompany_id_seq owned by enrollment_enrollmentcompany.id; | |
| SELECT setval(pg_get_serial_sequence('"enrollment_enrollmentcompany"','id'), coalesce(max("id"), 1), max("id") IS NOT null) FROM "enrollment_enrollmentcompany"; | |
| ALTER TABLE "enrollment_enrollmentcompany" ALTER COLUMN "id" SET DEFAULT nextval(pg_get_serial_sequence('"enrollment_enrollmentcompany"','id')); |
felipe3dfx
/ gist:15e161176dc1d8222d3ab4200e975003
Created
April 6, 2020 12:48
Rsync backup from remote EC2 server
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| rsync -havzP -e "ssh -i /home/deploy/xxxxx.pem" [email protected]:/home/deploy/complete-path/ /home/deploy/complete-path/ |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| email_message = EmailMultiAlternatives( | |
| subject='subject', | |
| body='some text', | |
| from_email='[email protected]', | |
| to=['example@example'], | |
| ) | |
| email_message.attach_alternative(render_to_string('email.html', context), 'text/html') | |
| email_message.mixed_subtype = 'related' | |
| # Image |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "Version": "2012-10-17", | |
| "Statement": [ | |
| { | |
| "Sid": "ListAllBuckets", | |
| "Effect": "Allow", | |
| "Action": [ | |
| "s3:ListAllMyBuckets", | |
| "s3:GetBucketLocation" | |
| ], |
felipe3dfx
/ gist:ea37e038301e17ab335c742d07eff882
Last active
October 16, 2024 15:51
Reset django migrations
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 1. Remove old migrations file | |
| sudo find . -path "*/migrations/*.py" -not -name "__init__.py" -not -path "./.venv/*" -delete | |
| sudo find . -path "*/migrations/*.pyc" -not -path "./.venv/*" -delete | |
| 2. Make migrations again | |
| python manage.py makemigrations | |
| 3. Truncate django_migrations table | |
| TRUNCATE TABLE django_migrations; |
sudo nano /etc/X11/xorg.conf
Section "ServerFlags"
Option "blank time" "0"
Option "standby time" "0"
Option "suspend time" "0"
Option "off time" "0"
EndSection
NewerOlder