Re: correcting tablespaces inside data folder

2018-07-10 Thread Duarte Carreira
Hi. On Fri, Jul 6, 2018 at 6:30 PM Duarte Carreira wrote: > > > On Fri, Jul 6, 2018 at 6:15 PM Magnus Hagander > wrote: > >> (please don't top-post. It makes it hard to follow discussions) >> >> On Fri, Jul 6, 2018 at 7:05 PM, Duarte Carreira >> wrote: >> >>> Magnus, >>> You mean changing the s

Re: correcting tablespaces inside data folder

2018-07-06 Thread Duarte Carreira
On Fri, Jul 6, 2018 at 6:15 PM Magnus Hagander wrote: > (please don't top-post. It makes it hard to follow discussions) > > On Fri, Jul 6, 2018 at 7:05 PM, Duarte Carreira > wrote: > >> Magnus, >> You mean changing the symlinks inside pg_tblspc? >> >> > Yes. As long as the server is shut down, y

Re: correcting tablespaces inside data folder

2018-07-06 Thread Magnus Hagander
(please don't top-post. It makes it hard to follow discussions) On Fri, Jul 6, 2018 at 7:05 PM, Duarte Carreira wrote: > Magnus, > You mean changing the symlinks inside pg_tblspc? > > Yes. As long as the server is shut down, you can modify those symlinks. > > On Fri, Jul 6, 2018 at 5:49 PM Ma

Re: correcting tablespaces inside data folder

2018-07-06 Thread Duarte Carreira
Magnus, You mean changing the symlinks inside pg_tblspc? On Fri, Jul 6, 2018 at 5:49 PM Magnus Hagander wrote: > On Fri, Jul 6, 2018 at 6:42 PM, Duarte Carreira > wrote: > >> Hello. >> >> Yes I'm one of those guys who only recently realized the mess of having >> tablespaces inside the data dir

Re: correcting tablespaces inside data folder

2018-07-06 Thread Magnus Hagander
On Fri, Jul 6, 2018 at 6:42 PM, Duarte Carreira 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

correcting tablespaces inside data folder

2018-07-06 Thread Duarte Carreira
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 Thanks, Duarte