October 2021 – .pQd's log

manual and service manual for LG F4J6TG0W washing and drying machine

2021-10-242022-11-20 by .pQd

maybe it’ll be useful for someone. instrukcja oraz instrukcja seriwsowa do pralko-suszarki LG F4J6TG0W service manual – LG-F4J6TG0W-LG_directdrive_8-145881-2.pdf, user instruction mfl69739861rev4pdf-en.pdf MFL70561437-EN

intellij freezing on startup + putty routinely failing to bind to ports used for ssh tunneling

2021-10-202021-10-20 by .pQd

for the past few weeks i was plagued by putty randomly failing to bind to ports used for ssh tunneling giving me in its log “forwarding failed: Network error: Permission denied” today my intellij failed to launch – it was freezing on the splash screen, C:\Users\xxxxxxxxxxxx\AppData\Local\JetBrains\IdeaIC2021.2\log\log.log had: that brought me to https://youtrack.jetbrains.com/issue/IDEA-238995 and workaroudn described ... Read More

crude way to restore postgresql database dump to table with a different name

2021-10-092021-10-09 by .pQd

i needed to restore specific table, backed up via pg_dump, to the same database / schema but under different name. that’s what i’ve done pv dump.zstd|pzstd -dc - |sed 's/name_of_original_table/name_of_renamed_table/g'|su - postgres -c 'psql dbname' this only works if all constrains / indices have in their name name of the original table.