Обсуждение: Newbie needs help with ERROR: could not write to file "base/16390/2682": No space left on device

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?

Your help would be greatly appreciated.

- Andrew



http://resources.angelosystems.com/postgresql.html

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

You've run out of space on the partition that postgres data is on, clear
some space.

--
Postgresql & php tutorials
http://www.designmagick.com/

-----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?

- --
Ron Johnson, Jr.
Jefferson LA  USA

Is "common sense" really valid?
For example, it is "common sense" to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that "common sense" is obviously wrong.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)

iD8DBQFFNtq6S9HxQb37XmcRAukpAJ98XGBYLxCFjwAyK/e4Ua4qNHD3/ACfWj6q
f9Oy3iQtrWhlI+ydmyhC3UQ=
=HCfs
-----END PGP SIGNATURE-----

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@007Marketing.com

Get Sheeky @ http://Sheeky.Biz