Automated Database Backup System
Scheduled File Upload Script client.py
#!/usr/bin/env python
import os
import time
from time import sleep
from socket import *
HOST = '10.239.44.242'
PORT = 21567
BUFSIZ = 4096
ADDR = (HOST, PORT)
tcpCliSock = socket(AF_INET, SOCK_STREAM)
tcpCliSock.connect(ADDR)
while 1:
sleep(1)
day_date = time.strftime("%Y%m%d",time.loca ...
Posted on Fri, 14 Aug 2026 16:10:24 +0000 by JoCitizen
Enhanced Data Dumping Options in PostgreSQL 12
Modifications in pg_dump
PostgreSQL 12 expands the capabilities of the pg_dump utility through additional command-line switches designed for flexible data recovery.
Revised Parameters
Parameter
Functionality
--on-conflict-do-nothing
Attaches an ON CONFLICT DO NOTHING directive to INSERT statements. Requires enabling --inserts or --column ...
Posted on Sat, 23 May 2026 18:15:01 +0000 by Simon Mayer