Re: [GENERAL] migrating/spliting Postgres data directory on OpenIndiana

2012-10-25 Thread John R Pierce
On 10/25/12 11:46 AM, Boris Epstein wrote: At this point I tried to just move the directory and use a soft link to repoint to it - but so far I have not even been able to do that properly, using pg_ctl. Apparently the process would not die. What should I look into to debug this one? try the

Re: [GENERAL] migrating/spliting Postgres data directory on OpenIndiana

2012-10-25 Thread Thomas Munro
On 25 October 2012 19:46, Boris Epstein wrote: > And if I want to split the storage - i.e., put databases into different > directories - can I do that? Take a look at the tablespace feature: http://www.postgresql.org/docs/current/static/sql-createtablespace.html You can move existing tables wit

[GENERAL] migrating/spliting Postgres data directory on OpenIndiana

2012-10-25 Thread Boris Epstein
Hello listmates, I am trying to move the data directory for this PG installation. So one question would be, how do I do that? What's the accepted practice? And if I want to split the storage - i.e., put databases into different directories - can I do that? At this point I tried to just move the