> While converting data to PostgreSQL (using PostgreSQL ODBC) I got the
> 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?
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: rejecting new messages: min free: 100
Sep 24 06:36:28 server sshd: Accepted password for ROOT from 10.0.0.3
Sep 24 06:36:28 server sshd: Could not reverse map address 10.0.0.3.
Sep 24 06:39:23 server sendmail: accepting new messages (again)
Sep 24 06:40:07 server dhcpd: DHCPREQUEST for 10.0.0.3 from 00:06:29:33:d3:17
Sep 24 06:40:07 server dhcpd: DHCPACK on 10.0.0.3 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.
Rotselaar - Belgium
pgsql-novice by date
|Next:||From: Chris||Date: 2002-09-24 05:33:20|
|Subject: Re: Disk space|
|Previous:||From: Joachim Smit||Date: 2002-09-24 02:52:02|
|Subject: Disk space|