When one get a "No space left on device" and there is a lot of space it is sometimes caused by lack of inodes.
Try run the command:
df --inodes
On Mon, Dec 10, 2018 at 4:56 PM Ron <ronljohnsonjr@xxxxxxxxx> wrote:
Hi,
v9.6.6
2018-12-07 06:21:55.504 EST 10.140.181.89(35868) CDS CDSLBXW 13748 SELECT
PostgreSQL JDBC Driver 53100 ERROR: could not write to tuplestore temporary
file: No space left on device
I see this in the pg_log file, but #1 can't figure out what "tuplestore" is
(Google doesn't help), and #2 there's lots of space on all my file systems.
data/base, where pgsql_tmp lives, has 96GB free.)
Thanks
--
Angular momentum makes the world go 'round.
