I do see some files now (0.0, 1.0 and 2.0) in that directory.
Not able to restart postgres at the moment because it's also running some other stuff...
-----Original Message-----
From: Peter Geoghegan <pg@bowt.ie>
Sent: maandag 29 oktober 2018 15:23
To: Paul van der Linden <paul.vanderlinden@mapcreator.eu>
Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>; Heikki Linnakangas <hlinnaka@iki.fi>
Subject: Re: BUG #15460: Error while creating index or constraint
On Mon, Oct 29, 2018 at 2:19 PM Paul van der Linden <paul.vanderlinden@mapcreator.eu> wrote:
> Directory is empty (when I check after the error occurred, no idea yet (will test) if there's something there during
indexcreation.
There'll definitely be something during index creation, though the exact directory name will vary per operation.
Do you use temp_tablespaces (easy way to find out is to "show temp_tablespaces")? There's one directory per temp
tablespace,so maybe you looked in the wrong one?
> And for some reason I'm not able to set the log_line_prefix in my
> pgAdmin session... ERROR: parameter "log_line_prefix" cannot be
> changed now
That needs to be set in postgresql.conf.
--
Peter Geoghegan