Pablo pablodz

🤠

9.99x Engineer

Come to Peru! We have delicious food

68 followers · 25 following

View GitHub Profile

Recently created

Least recently created

Recently updated

Least recently updated

pablodz / pg_hba.bash

Created July 1, 2020 20:51

	# Add somewhere this line
	host all postgres 0.0.0.0/0 md5

pablodz / automatic configuration timescaledb postgresql.bash

Created July 1, 2020 21:01

sudo timescaledb-tune

pablodz / restart postgresql.bash

Created July 1, 2020 21:04

sudo service postgresql restart

pablodz / create a table and convert to hypertable.bash

Created July 1, 2020 21:16

	# First enter a postgres command line
	sudo -u postgres psql

	# In postgres command line create a standard table
	CREATE TABLE conditions (
	time TIMESTAMPTZ NOT NULL,
	location TEXT NOT NULL,
	temperature DOUBLE PRECISION NULL,
	humidity DOUBLE PRECISION NULL
	);

pablodz / simulate_data_timeseriesdb.py

Last active July 1, 2020 21:32

	import psycopg2
	import random
	import time

	host="localhost"
	database="your_database_name"
	user="your_user"
	pwd="your_password"
	p="5432" # Default port

pablodz / change password postgresql default.bash

Created July 1, 2020 21:35

	# Enter postgres command line

	sudo -u postgres psql

	ALTER ROLE postgres WITH PASSWORD 'your_password';
	\q

	# \q to exit postgres command line

pablodz / install apache 2 on debian.bash

Created July 1, 2020 21:39

	# Update apt list package
	sudo apt update
	# Install apache2
	sudo apt install apache2
	# Check status
	sudo systemctl status apache2

pablodz / Lista de descargas.csv

Created July 9, 2020 05:03

	Facultad	Enlace
	Facultad de Arquitectura y Urbanismo	Sin soporte
	Facultad de Arte y Diseño	Sin soporte
	Facultad de Ciencias Contables	Sin soporte
	Facultad de Ciencias y Artes de la Comunicación	Sin soporte
	Facultad de Educación	Sin soporte
	Facultad de Ciencias e Ingeniería Descargar	https://bit.ly/3foCIPG
	Facultad de Artes Escénicas	Sin soporte
	Facultad de Ciencias Sociales	Sin soporte
	Facultad de Letras y Ciencias Humanas	Sin soporte

pablodz / change password postgres to postgres on server.bash

Last active July 10, 2020 01:05

	# Enter postgres command line

	sudo -u postgres psql -c "ALTER ROLE postgres WITH PASSWORD 'postgres';"

	# \q to exit postgres command line

pablodz / install_choco.ps1

Created August 18, 2020 19:33

Set-ExecutionPolicy Bypass -Scope Process -Force; [System.Net.ServicePointManager]::SecurityProtocol = [System.Net.ServicePointManager]::SecurityProtocol -bor 3072; iex ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1'))

Older Newer