5 ms·
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 que
by troyk 9y ago
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-client.html https://www.postgresql.org/docs/current/static/reference-cli...
- X86BSD 9y agoZfs snapshots and send/recv are even easier for making backups or copying databases.
- majewsky 9y agoA 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.
- jeltz 9y agoFile 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.