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