Tag Info

New answers tagged


With GNU date (default on Linux Mint) you can do: mysqldump -uroot -p MyDatabase >/home/users/backup_MyDB/$(date +%F)_full_myDB.sql To delete files older than 1 week: find /home/users/backup_MyDB -type f -mtime +7 -exec rm {} + Although generally it is wise to see what you are deleting before you delete (at least when testing you script) for this ...


By default PostgreSQLt listen on TCP port 5432. Use the following iptables rules allows incoming client request (open port 5432). -A INPUT -p tcp --dport 5432 -s xxx.xxx.xxx.xxx -j ACCEPT Where xxx.xxx.xxx.xxx is the IP of the server you're connecting from so you're not opening postgres up to the world.


The protocol is plain TCP/IP. From posgresql documentation about "frontends" and "backends" protocol: PostgreSQL uses a message-based protocol for communication between frontends and backends (clients and servers). The protocol is supported over TCP/IP and also over Unix-domain sockets. Port number 5432 has been registered with IANA as the customary TCP ...

Top 50 recent answers are included