News for hackers. Stuff that matters.
Re:PostgreSQL 10 Released by troyk on Thursday October 05, 2017 @12:32PM (#15410486)
PostreSQL has great tooling, maybe not the GUI-UX experience you are familiar with MSSQL on Windows.

psql is great for inspecting schema and running ad-hoc queuries. SQL scripts can also be piped through it for cron-sql jobs etc.

pg_dump + psql + ssh to easily copy databases between hosts

pg_bench for benchmarking.

Lots more: https://www.postgresql.org/docs/current/static/reference-cli...

Re:PostgreSQL 10 Released by X86BSD on Thursday October 05, 2017 @01:17PM (#15410803)
Zfs snapshots and send/recv are even easier for making backups or copying databases.
Re:PostgreSQL 10 Released by majewsky on Thursday October 05, 2017 @06:28PM (#15413042)
A filesystem snapshot is only reliable if you stop the database to do it, or if there is some sort of cooperation between the database and the tool that triggers the FS snapshot creation.
Re:PostgreSQL 10 Released by jeltz on Thursday October 05, 2017 @06:42PM (#15413115)
File system and LVM snapshots are atomic, so if you cannot get a working database from that your database won't survive a power failure either. You can also do a file system backup of PostgreSQL without atomic snapshots but then you will need to inform PostgreSQL of the backup and then copy files in the right order. The pg_basebackup tool and various third party tools handle this for you.