Re: [GENERAL] Help on copy function

2004-10-06 Thread Doug McNaught
Tom Lane <[EMAIL PROTECTED]> writes: > Doug McNaught <[EMAIL PROTECTED]> writes: >> It's also possible that PG is trying to create a new table file and >> he's out of inodes... > > Good thought, although I think that this particular error message would > only come out from a seek/write failure an

Re: [GENERAL] Help on copy function

2004-10-06 Thread Tom Lane
Doug McNaught <[EMAIL PROTECTED]> writes: >>> psql:lineitem.loader.psql:1: ERROR: could not extend relation >>> 24342131/24342133 >>> /24342324: There is not enough space in the file system. >>> HINT: Check free disk space. >> >> Maybe you are running the postmaster under a disk-space-usage limi

Re: [GENERAL] Help on copy function

2004-10-06 Thread Doug McNaught
Tom Lane <[EMAIL PROTECTED]> writes: > [EMAIL PROTECTED] writes: >> And an error occurs : >> psql:lineitem.loader.psql:1: ERROR: could not extend relation >> 24342131/24342133 >> /24342324: There is not enough space in the file system. >> HINT: Check free disk space. > >> but my fileSystem has s

Re: [GENERAL] Help on copy function

2004-10-06 Thread Tom Lane
[EMAIL PROTECTED] writes: > And an error occurs : > psql:lineitem.loader.psql:1: ERROR: could not extend relation > 24342131/24342133 > /24342324: There is not enough space in the file system. > HINT: Check free disk space. > but my fileSystem has something like 2Go free when copy fails! Maybe

[GENERAL] Help on copy function

2004-10-06 Thread frederic . germaneau
I'm trying to stress PostgreSQL 8beta3 on AIX5.2 with TPCH 1 Go I have created and configurated a database on 2 tablespaces : first one for indexes and second one for tables First script for database creation: $ more scrCreateDataBase.sh psql template1<