Skip site navigation (1) Skip section navigation (2)

Re: Disk space

From: "Joachim Smit" <jo(at)chimsmit(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Disk space
Date: 2002-09-24 05:25:38
Message-ID: 3D901372.3504.27C4776@localhost (view raw or whole thread)
Lists: pgsql-novice

> While converting data to PostgreSQL (using PostgreSQL ODBC) I got the 
> message:
> Connectivity error: ERROR: cannot extend addresses_pkey: 
> No space left on device.
> Check free disk space.
> I have 8Gb free disk space. What should I do?

Please send:

1) What Operating System are you using?

Linux Slackware 2.4.18

2) Where is the PostgreSQL data located?


3) What partitions do you have on your hard drive? (on Linux, copy the output 
of the "df" command).

Filesystem           1k-blocks      Used Available Use% Mounted on
/dev/hda1               995864    942788      1672 100% /
/dev/hda3               830136    270592    517376  35% /cdr
/dev/hda4             17749652   6057316  10790688  36% /home

4) If you check the PostgreSQL log, or the system log, do you see other errors 
related to disk access?


Sep 24 06:36:23 server sendmail[107]: rejecting new messages: min free: 100
Sep 24 06:36:28 server sshd[2164]: Accepted password for ROOT from 
port 3209
Sep 24 06:36:28 server sshd[2165]: Could not reverse map address
Sep 24 06:39:23 server sendmail[107]: accepting new messages (again)
Sep 24 06:40:07 server dhcpd: DHCPREQUEST for from 00:06:29:33:d3:17 
via eth0
Sep 24 06:40:07 server dhcpd: DHCPACK on to 00:06:29:33:d3:17 via eth0

After I've converted about 100.000 records (in different tables) I got the message:

Connectivity error: ERROR:  cannot extend plaatsingen: No space left on device.
	Check free disk space.

When my conversion-program keeps trying the message becomes:

Connectivity error: Could not send Query to backend;
Could not send Query to backend;
Socket has been closed.

This happened at 06:37. I can't see anything in the logfile (see above). How do I 
open the PostgreSQL logfile ?

Conversion program runs on Windows NT client.

Kind regards,

Rotselaar - Belgium


pgsql-novice by date

Next:From: ChrisDate: 2002-09-24 05:33:20
Subject: Re: Disk space
Previous:From: Joachim SmitDate: 2002-09-24 02:52:02
Subject: Disk space

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group