Moving postgresql data cluster

 

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...

  • stop service
  • copy data cluster
  • update postgresql-9.1 file (PGDATA=)
  • restart service

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

    I tried telnet-ing to port 5432 and nothing.

    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.

    Instead of doing 

    cp -R fromfolder tofolder

    I did 

    cp -a fromfolder tofolder

    And that solved it. Thanks all.

    链接地址: http://www.djcxy.com/p/61012.html

    上一篇: 是否有只读的REST API密钥到MongoLab数据库，还是总是ReadWrite

    下一篇: 移动postgresql数据集群