Geek Answers Handbook

Moving a postgresql data cluster

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

  • stop the 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 the server: connection refused"

I tried to connect to port 5432 and nothing.

Here is a link to what I tried: http://www-01.ibm.com/support/docview.wss?uid=swg21324272

+7
source share
1 answer

Thank you all for your help. The problem seemed to be resolving.

Instead of doing

cp -R fromfolder tofolder

I did

 cp -a fromfolder tofolder

And that decided. Thanks to everyone.

+4
source

More articles:


All Articles