Just my blog
Blog about everything, mostly about tech stuff I made. Here is the list of stuff I'm using at my blog. Feel free to ask me about implementations.
- Mobaxterm SSH RDP FTP...
- Thunderbird Email client
- Filezilla FTP client/server
- Nirsoft Win utils
- Sysinternals Win utils
- Pi-Hole AD block by DNS
- NUT UPS manager
- Rpi MON Raspberry monitoring
- Free CAD 3D modelling
- Free Commander Far-like filemanager
- Bitwarden Password manager
- Django web framework
- celery multi-tasking
- celery-beat Celery + Django
- celery-results Celery + Django
- Pillow Python image lib
- wsgi mod Apache + Python
- requests best in WEB requests
- openpyxl make Excell docs
- p4python Perforce + Python
- paramiko SSH + Python
- pyvmomi ESXi Vcenter + Python
I'm using these libraries so you can ask me about them.
PostgreSQL first run
This is the most common issue for PostgreSQL first run in Linux env: configure the server to allow TCP/IP connections postgresql server it can produce PostgeSQL cannot connect to database host Here I'll show how to fix it before you struggle with firewall and ports: I've found ot here: 17.3. Starting the Database Server and How Do I Enable remote access to PostgreSQL database server? My situation:
vi /var/lib/pgsql/data/pg_hba.conf
add the string:
host all all 10.10.29.0/24 trust
with my range and next config:
vi /var/lib/pgsql/data/postgresql.conf
add the string:
listen_addresses='*'
After that restart the service:
systemctl restart postgresql.service
also you can use an old 'service postgresql restart'
[root@centst010 ~]# service postgresql restart Redirecting to /bin/systemctl restart postgresql.service
And here it is:
[root@centst010 ~]# netstat -anp | grep 5432 tcp 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN tcp 0 0 192.168.1.40:5432 192.168.1.22:65369 ESTABLISHED tcp6 0 0 :::5432 :::* LISTEN