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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Chris | 2002-09-24 05:33:20 | Re: Disk space |
Previous Message | Joachim Smit | 2002-09-24 02:52:02 | Disk space |