Tag Info

New answers tagged

2

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 ...


0

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.


3

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