daf@daftitanium:~$ lsusb Bus 003 Device 101: ID 534d:2109 MacroSilicon USB Video cat /var/log/syslog Oct 2 11:31:13 daftitanium kernel: [738079.626765] usb 3-3: new high-speed USB device […]
La tecnología nos hace tener menos necesidad de merito para alcanzar los mismos resultados.
entity-attribute-value design in PostgreSQL – don’t do it! – CYBERTEC
Customers have often asked me what I think of “Entity-attribute-value” (EAV) design. So I thought it would be a good idea to lay down my […]
Paranoid SQL Execution on Postgres
Suppose that you want to be completely over-the-top paranoid about making sure that when you execute some particular SQL statement on your Postgres database, you’re […]
Primary Key Index is a Space Hog
Tables in PostgreSQL have an index for the primary key and separate row storage called the heap. Other databases integrate these together or support “index-organized […]
Monitor PostgreSQL using Zabbix
Would you like to learn how to monitor a PostgreSQL server using Zabbix? In this tutorial, we are going to show you how to use […]
How To Install PostgreSQL With Docker Quickly
Many developers still install a database on their computer and work on it. It may be a preferable method, but using Docker takes only seconds […]
Make DNS follow configuration from Network Manager in 19.04
I’ve installed 19.04 and removed dsnmasq, disabled systemd-resolve using sudo systemctl disable systemd-resolved.service sudo systemctl stop systemd-resolved and want to use Network Manager to set […]
wal2json for PostgreSQL
Aca mis pruebas, abajo la original: yum install wal2json create database daftest; daftest=# CREATE TABLE test_table ( id char(10) NOT NULL, code char(10), PRIMARY KEY […]
Copiar usaurio de un postgres a otro:
/usr/pgsql-11/bin/pg_dumpall -p 5432 -U postgres -r | /usr/pgsql-11/bin/psql -p 5433
Mi .psqlrc
Coleccion de cositas para el .psqlrc ————————————————– — 20200115 DAF agrego funcionalidades — 20200108 DAF .psqlrc Version inicial ————————————————– — Para que no muestre el […]
Subastaron el mas antiguo manuscrito sobre Sherlock Holmes
A principios de mes se subastó el manuscrito de la novela The Sign of Four, de Arthur Conan Doyle, en la que reáparecen el detective […]
PostgreSQL Readonly User
Rational When you create a user in postgresql, even with only select only permission, your user has a lot more privileges. Solution Connect with root […]
Archivos del Garmin
– gmapbmap.img = Mapa base, que viene con el equipo. – gmapprom.img = Mapa precargado de fabrica (EEUU, Canada) – gmapsupp.img = Mapear V12.4 – […]
DELETE con LIMIT en Postgres
Sucio y desprolijo: WITH cte AS ( SELECT my_rowid /* your PK */ FROM batch WHERE bat_close_time_stamp <= 1507381943.93144 /* your condition */ /* ORDER […]
Changing the Auto-Logout Timeout in SSH
The ssh “timed out waiting for input: auto-logout” messages is generated by ssh upon reaching a auto-logout after an inactivity time specified by the TMOUT […]
How To Adjust Monitor Brightness From Command Line In Linux
The xrandr program is used to set the size, orientation and/or reflection of the outputs for a screen. Using Xrandr, we can also display the […]
EN BUSCA DE LA VEREDA DEL SOL
MONOLOGO N° 2000 de TATO BORES DOMINGO 9 DE SETIEMBRE DE 1990 – 21 HORAS 30 MINUTOS. “Bueno, señores, Monologo 2000! 30 años metiendo libreto […]