pg_dumpall and tablespaces

From: Joao Miguel Ferreira <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: pg_dumpall and tablespaces
Date: 2021-02-02 16:43:47
Message-ID: CALyyT7R8NcVvazqF_-Xg4EkUM9KYAkmGBUv_NXA2TFZox9rGnw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 perform my sw development against a fresh copy of the data.

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 tablespaces paths on the dump file are bound to the MAC filesystem
(/Users/..../pg/....). I would need to re-write that path to my home folder
or '/var/lib/....'

Obviously I'm a bit confused on how to do this.

pg_dumpall is very powerfull and simple, specially when using the
"--create" option that does all the work for me.

I would appreciate any directions on how to restore that dump

thank you
Joao

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2021-02-02 16:52:43 Re: pg_dumpall and tablespaces
Previous Message Adrian Klaver 2021-02-02 16:32:22 Re: permission denied for large object 200936761