Magnus, You mean changing the symlinks inside pg_tblspc?
On Fri, Jul 6, 2018 at 5:49 PM Magnus Hagander <mag...@hagander.net> wrote: > On Fri, Jul 6, 2018 at 6:42 PM, Duarte Carreira <dncarre...@gmail.com> > wrote: > >> Hello. >> >> Yes I'm one of those guys who only recently realized the mess of having >> tablespaces inside the data directory... now I want to use pg_upgrade and >> it will make things even worse... >> >> Does anyone have a best approach to this problem? Fastest/safest? >> >> pg 9.3.x on win >> >> > If you can afford to shut the server down, the easiest is to shut it down, > move the tablespaces (with mv, and as long as you stay within the partition > it should be almost instant), update the symlinks to point to the new > location, and start it up again. > > -- > Magnus Hagander > Me: https://www.hagander.net/ <http://www.hagander.net/> > Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/> >
