Toggen Blog
Tech tips
Articles
Latest
Postgres restore COPY Error
Error while running a restore ERROR: invalid input syntax for type timestamp with time zone: "202" COPY 4 Restore Command (I use docker but that isn't the problem) zcat ${RECOVERY_FILE} | docker run --env PGPASSWORD -i --rm \ postgres:14.5 psql -d ${DB_NAME} \ -h...
VS Code Killed by OOM ON UBUNTU VM
Problem: VS Code on Ubuntu 22.04 VM exits with "killed code 9" journalctl | grep -i oom May 17 12:58:03 tgn-vm-ln-02 kernel: Out of memory: Killed process 43215 (code) total-vm:1186602700kB, anon-rss:189300kB, file-rss:0kB, shmem-rss:36296kB, UID:1000 pgtables:1412kB...
Failed to execute ‘pushState’ on ‘History’
Uncaught (in promise) DOMException: Failed to execute 'pushState' on 'History': A history state object with URL 'http://example.com.au/dev/despatch' cannot be created in a document with origin 'https://example.com.au' and URL 'https://example.com.au/dev/despatch'. I...
Mysql wont Start
Ubuntu 22.04 with mysql-server 8.0.32-0ubuntu0.22.04.2 mysql wouldn't start with error sudo systemctl status mysql.service # output Error: 99 (Cannot assign requested address) Cause I was using Docker on this host and had added the the Docker network host IP Address...
Connect to postrgres with psql password Authentication
Connect to postgres DB and show the server version (full string and psql -U myuser-d mydb -h localhost Password for user myuser: mydb=# SELECT VERSION(); # output PostgreSQL 15.2 (Debian 15.2-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6)...
Business Name re-registration Opportunistic Businesses
Two Three examples of Australian businesses one Melbourne based, the other two in Sydney who scan the ASIC registry data and then send a notification letter via snail mail to renew a business name at a much inflated price. I tried to confirm the Registry company's...