On Tue, Jun 9, 2015 at 12:58 PM, ben.play <benjamin.cohen@xxxxxxxxxxxx> wrote: > Hi, > > Thank you a lot for your answer. > I've done that (create a tablespace in another HD with POSTGRES role + put > it as the main temp_tablespace in the conf). > > But ... my command ~# df show me that all queries use the default tablespace > ... > > > This was my commands (the directory is owned by postgres) : > CREATE TABLESPACE hddtablespace LOCATION '/media/hdd/pgsql'; > ALTER TABLESPACE hddtablespace OWNER TO postgres; > > SHOW temp_tablespaces; >> hddtablespace > > In /media/hdd/pgsql I have only one empty directory (PG_9.3_201306121). > > Do you have any tips ? You have to grant public CREATE permissions on the tablespace, otherwise noone will have permission to use it. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
