很多运维新手从 MySQL 转向 PG 时，会习惯性沿用 mysqldump 的思路使用 pg_dump，却忽略了两者的核心差异，最终导致备份失败、数据无法恢复、权限报错等问题。其实 PG 在一致性备份方面（MVCC）具有天然优势，但安全性仍取决于权限配置与备份策略，细节上的坑 ...

Earlier, we discussed SQL Databases. In this post, I will list some popular open-source, free database software. Before starting any service online, it is necessary to choose a database that can ...

PostgreSQL (Postgres) is an open source object-relational database known for reliability and data integrity. ACID-compliant, it supports foreign keys, joins, views, triggers and stored procedures.

One of the most interesting trends in the computer world during the past few years has been the rapid growth of NoSQL databases. The term may be accurate, in that NoSQL databases don't use SQL in ...

Prompt you for the name of your PostgreSQL database; Prompt you for the path of the folder where your backups will go; Prompt you for how often you want to back the database up, in seconds; and Prompt ...