Обсуждение: Disk space

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?

Thanks in advance.

Joachim Smit

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

Hi,

As the error suggests, you've got a full disk.

Here's your problem. Your /usr/local/pgsql/data folder is on the / partition:

>Filesystem           1k-blocks      Used Available Use% Mounted on
>/dev/hda1               995864    942788      1672 100% /


You might have 8G free but none of it's available for this folder.

Chris.

I've solved the problem. Thank you very much.

Joachim



Hi,

As the error suggests, you've got a full disk.

Here's your problem. Your /usr/local/pgsql/data folder is on the /
partition:

>Filesystem           1k-blocks      Used Available Use% Mounted on
>/dev/hda1               995864    942788      1672 100% /


You might have 8G free but none of it's available for this folder.

Chris.


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
------- End of forwarded message -------

Hi There,

> I have 8Gb free disk space. What should I do?

1) Work out where Postgres is storing the database
 - on my RH 7.1 + Postgres 7.2.2 it's in /var/lib/pgsql

2) Work out what partition that is in
 - in /var for me

3) Do a `df' to see how much space is left on that partition

You can have terabytes of space on a disk left over, but still run out
of space in a user defined partition.

DSL
--
Qualcuno no mi basta.
  Vivere cercando il grande amore.
  Vivere come se mai dovessimo morire.
(Anastasio, Valli e Travato)