Macrosilicon MS2100 HDMI To USB 3.0 Video Capture Card
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 number 102 using xhci_hcd Oct 2 11:31:13 daftitanium kernel: [738079.778290] usb 3-3: New USB device found, idVendor=534d, idProduct=2109, bcdDevice=21.00 Oct 2 11:31:13 daftitanium kernel: [738079.778298] usb 3-3: New 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 opinion in writing. What is entity-attribute-value design? 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…
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 doing it in the safest and least risky way? For example, suppose it’s the production database behind your successful startup’s main commercial website. If anything even causes queries to block/pause…
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 tables”. In this arrangement, the primary key lookup process leads directly to the row data without a secondary fetch to get the full row and the requisite additional CPU and…
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 Zabbix to monitor a PostgreSQL server. Zabbix Playlist: On this page, we offer quick access to a list of videos related to Zabbix installation. Playlist Don’t forget to subscribe to our youtube…
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 to set up a database. I used PostgreSQL and Docker in my latest project. As a result, I have achieved efficiency and convenience. I will give you my experience with…
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 manually my DNS servers. Now I want to configure a different DNS server, so I went to the network icon on the bar and clicked Wired -> Wired Settings ->…
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 (id) ); export PATH=”$PATH:/usr/pgsql-12/bin” pg_recvlogical pg_recvlogical: error: no slot specified pg_recvlogical -d daftest –slot test_slot –create-slot -P wal2json pg_recvlogical -d daftest –slot test_slot –start -o pretty-print=1 -f – ## Va…
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 output de los siquientes comandos \set QUIET ON — Prompts — Prompt1 / Prompt2 / Prompt3 — %M : server — %m : host name — %> : port –…
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 Sherlock Holmes y su ayudante, el doctor Watson. Lá celebre pareja había nacido en la novela anterior de Doyle, Estudio en escarlata (de la que se conserva tan solo una…
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 user to the desired database you will be giving permissions for: mydb=# psql -h 10.10.10.10 -U postgres mydb Now lets create the user: mydb=# create user readonly with encrypted password…
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 – gmapprom1.img = Mapear Nautico V2 gmapsupp.img (always the default name from mapsource) gmapsup1.img (additional on SD card) gmapprom.img (Garmin main memory) 1 x gmapsupp.img – memoria interna del dispositivo 1…
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 BY ??? */ /* optional */ LIMIT 500 FOR UPDATE /* SKIP LOCKED */ ) DELETE FROM batch tbl USING cte WHERE tbl.my_rowid = cte.my_rowid; Fuente: stackoverflow.com/questions/52950430/batch-delete-in-postgres-using-a-cursor
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 environment variable. If this variable is not set your session will not be auto-logged out due to inactivity. If the environment variable is set, your session will be automatically closed/logged…
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 current state of the system screen, change or set the resolution, disable disconnected outputs and enable connected ones. And the good thing is Xrandr comes pre-installed with most Linux distributions,…
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 debajo de esta peluca! Mire, esta noche en lugar de hacer un monologo con lo que paso esta semana, con la actualidad, esta semana vamos a hacer un monologo recordando…