Re: pg_dumpall and tablespaces

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 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/....'
>  

Do you want to maintain tablespaces on the dev machine?

If not from here:

https://www.postgresql.org/docs/12/app-pg-dumpall.html

--no-tablespaces

     Do not output commands to create tablespaces nor select tablespaces
for objects. With this option, all objects will be created in whichever
tablespace is the default during restore.


This would have to be done when the pg_dumpall is run.