create user foouser;
create tablespace temptblspc location '/tmp/tmptblspc';
alter user foouser set temp_tablespaces='temptblspc';
Run pg_dumpall. It will produce a dump like:
...
CREATE ROLE foouser;
ALTER ROLE foouser WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB
LOGIN NOREPLICATION;
Heikki Linnakangas heikki.linnakan...@enterprisedb.com writes:
Barring objections, I'll write a patch to relax the checking on
default_text_search_config and temp_tablespaces to match search_path.
This seems like something that's going to come back again and again.
What do you think of