Re: Disk space

Joachim,

> While converting data to PostgreSQL (using PostgreSQL ODBC) I got the
following
> 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?

/usr/local/pgsql/data/

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?

/var/log/messages:

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 10.0.0.3
port 3209
Sep 24 06:36:28 server sshd[2165]: Could not reverse map address 10.0.0.3.
Sep 24 06:39:23 server sendmail[107]: accepting new messages (again)
Sep 24 06:40:07 server dhcpd: DHCPREQUEST for 10.0.0.3 from 00:06:29:33:d3:17
via eth0
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.

Kind regards,

Joachim,
Rotselaar - Belgium