Re: Newbie needs help with ERROR: could not write to file

From: Shane Ambler <pgsql(at)007Marketing(dot)com>
To: aplata(at)gmail(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Newbie needs help with ERROR: could not write to file
Date: 2006-10-19 06:32:38
Message-ID: 45371C06.2000805@007Marketing.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ron Johnson wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On 10/18/06 20:41, andrew plata wrote:
>> I am trying to following the instructions at URL below to try to create a
>> database called web_database required for phpPgAdmin. When I try to do this
>> I get the following error:
>>
>> template1=# create database web_database owner web_user;
>> ERROR: could not write to file "base/16390/2682": No space left on device
>> template1=# exit
>> template1-# \q
>>
>> Any ideas what may be causing this to happen?
>
> "No space left on device"
>
> Maybe your disk is full?
>

I bet that you are running FreeBSD and your dataDir is in /var/db which
is a small slice.

Setup your dataDir on a slice with more space.

--

Shane Ambler
Postgres(at)007Marketing(dot)com

Get Sheeky @ http://Sheeky.Biz

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Georgi Petrov 2006-10-19 08:42:48 problems installing pg on solaris
Previous Message Rick Gigger 2006-10-19 06:13:24 Re: hardware failure - data recovery