| From: | David Steele <david(at)pgmasters(dot)net> |
|---|---|
| To: | Joseph Kregloh <jkregloh(at)sproutloud(dot)com>, Gerdan Rezende dos Santos <gerdan(at)gmail(dot)com> |
| Cc: | Martín Marqués <martin(at)2ndquadrant(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: error on online backup using pg_basebackup tool |
| Date: | 2015-09-05 12:32:10 |
| Message-ID: | 55EAE0CA.5040103@pgmasters.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-general |
On 9/3/15 5:07 PM, Joseph Kregloh wrote:
> You can always move the folder out of there. Depending on the version of
> PostgreSQL different steps need to be take. If I remember correctly for
> version 9.3 you can move the symlink to point to the new directory. Pre
> 9.3 you need to move the symlink and the pointer inside the pg tables.
You can move the directory and modify the symlink on 9.2 or later
without any additional complications.
However - and this is very important - PostgreSQL must be shut down
during this operation.
My recommendation would be to move both tablespaces out of $PGDATA.
There has been a lot of discussion about disallowing it in future
releases as it causes problems for various tools.
--
-David
david(at)pgmasters(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Munro | 2015-09-05 12:43:15 | Re: GRANT USAGE ON SEQUENCE missing from psql command completion |
| Previous Message | Teodor Sigaev | 2015-09-04 09:19:33 | Re: BUG #13440: unaccent does not remove all diacritics |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc Mamin | 2015-09-05 12:36:41 | Re: Any thoughts on a better approach to this query? |
| Previous Message | clmartin | 2015-09-04 23:07:02 | Trouble setting up replication |