NAS 上带有数据文件的 PostgreSQL

Question

是否有人试图在 NAS 服务器上运行 PostgreSQL 服务器并挂载数据文件？您能否分享一下您是否遇到了一些性能问题或其他问题？

Answer 1

https://www.postgresql.org/docs/current/static/creating-cluster.html#CREATING-CLUSTER-MOUNT-POINTS

Many installations create their database clusters on network file systems. Sometimes this is done via NFS, or by using a Network Attached Storage (NAS) device that uses NFS internally. PostgreSQL does nothing special for NFS file systems, meaning it assumes NFS behaves exactly like locally-connected drives. If the client or server NFS implementation does not provide standard file system semantics, this can cause reliability problems (see http://www.time-travellers.org/shane/papers/NFS_considered_harmful.html). Specifically, delayed (asynchronous) writes to the NFS server can cause data corruption problems. If possible, mount the NFS file system synchronously (without caching) to avoid this hazard. Also, soft-mounting the NFS file system is not recommended.

Storage Area Networks (SAN) typically use communication protocols other than NFS, and may or may not be subject to hazards of this sort. It's advisable to consult the vendor's documentation concerning data consistency guarantees. PostgreSQL cannot be more reliable than the file system it's using.

并查看邮件存档中的讨论: https://www.google.ie/search?ei=IUe7WtPgBuiZgAbUjY6wAQ&q=www.postgresql.org+NAS&oq=www.postgresql.org+NAS&gs_l=psy-ab.3...171931.171931.0.172294.1.1.0.0.0.0.54.54.1.1.0....0...1c.1.64.psy-ab..0.0.0....0.ZQOg3b7OmDk