移动Postgresql数据集群 [英] Moving postgresql data cluster

问题描述

我们的postgres数据文件夹安装在空间非常有限的驱动器上。我现在正尝试将其移至新安装的驱动器（更多空间）。我关注了几篇博客文章，他们都说...

Our postgres data folder was installed on a drive with very limited space. I'm now trying to move it over to a newly mounted drive (more space). I've followed several blog posts and they all say...

1. 停止服务


2. 复制数据集群


3. 更新postgresql-9.1文件（PGDATA =）


4. 重启服务

1. stop service
2. copy data cluster
3. update postgresql-9.1 file (PGDATA=)
4. restart service

服务启动，但是当我连接时，它提示我无法连接到服务器：连接被拒绝

The service starts but when I go to connect, it gives me "could not connect to server: Connection refused"

我尝试了telnet-进入端口5432，什么也没有。

I tried telnet-ing to port 5432 and nothing.

以下是我一直在尝试的链接：
http://www-01.ibm.com/support/docview.wss?uid=swg21324272

Here is the link to what I've been trying: http://www-01.ibm.com/support/docview.wss?uid=swg21324272

推荐答案

感谢大家的帮助。看起来问题出在许可方面。

Thanks everyone for your help. Looks like the problem was with permissioning.

不是这样做

cp -R fromfolder tofolder

我做到了

cp -a fromfolder tofolder

这解决了它。谢谢大家。

And that solved it. Thanks all.

这篇关于移动Postgresql数据集群的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！