Re: pg_dumpall and tablespaces

2021-02-02 Thread Joao Miguel Ferreira
On Tue, Feb 2, 2021 at 5:08 PM Tom Lane wrote: > Adrian Klaver writes: > > On 2/2/21 8:43 AM, Joao Miguel Ferreira wrote: > >> I have a dump file obtained from pg_dumpall on a MAC computer. I need > to > >> load in onto my Linux laptop running postgres. > >> I got 2 problems concerning tablespac

Re: pg_dumpall and tablespaces

2021-02-02 Thread Tom Lane
Adrian Klaver writes: > On 2/2/21 8:43 AM, Joao Miguel Ferreira wrote: >> I have a dump file obtained from pg_dumpall on a MAC computer. I need to >> load in onto my Linux laptop running postgres. >> I got 2 problems concerning tablespaces: >> a) during the restore step I get lots of errors about

Re: pg_dumpall and tablespaces

2021-02-02 Thread Joao Miguel Ferreira
On Tue, Feb 2, 2021 at 4:52 PM Adrian Klaver wrote: > On 2/2/21 8:43 AM, Joao Miguel Ferreira wrote: > > > I got 2 problems concerning tablespaces: > > a) during the restore step I get lots of errors about the necessity to > > have root permissions to re-create the tablespaces and > > b) the ta

Re: pg_dumpall and tablespaces

2021-02-02 Thread Adrian Klaver
On 2/2/21 8:43 AM, Joao Miguel Ferreira wrote: Hello all, I have a dump file obtained from pg_dumpall on a MAC computer. I need to load in onto my Linux laptop running postgres. My scenario is software development. I'm trying to load the dump onto my Pg installation running on Linux (and lat

pg_dumpall and tablespaces

2021-02-02 Thread Joao Miguel Ferreira
Hello all, I have a dump file obtained from pg_dumpall on a MAC computer. I need to load in onto my Linux laptop running postgres. My scenario is software development. I'm trying to load the dump onto my Pg installation running on Linux (and later possibly on Linux over Docker) in order to perfor