"Karen Ellrick" <k-ellrick@sctech.co.jp> writes:
> ... Then I tried creating /var/pgdata fresh and doing initdb -D
> /var/pgdata, and that was okay until I tried to create the database again,
> when it said a database of that name already existed. Yes, I have changed
> my startup script to reflect the new path.
But ... um ... did you restart the postmaster with the new path argument?
Or only change the script?
BTW, it should work fine to move a data-directory tree from one place to
another (with cp -p -r or tar/untar according to preference). But you
have to shut down the old postmaster *first*.
regards, tom lane