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 flat)
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


Responses

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-2014 The PostgreSQL Global Development Group