From: Shane Ambler <pgsql@Sheeky.Biz>
To: Julius Tuskenis <julius@nsoft.lt>
Cc: pgsql-admin@postgresql.org
Subject: Re: store different tables in different locations
Date: Sat, 05 Apr 2008 03:47:40 +1030
Message-ID: <47F662B4.7080903@Sheeky.Biz> (raw)
In-Reply-To: <47F5E12B.70701@nsoft.lt>
References: <011101c89609$eaa96060$131c480a@nsl.ad.nec.co.jp>
<47F5C8D7.9070904@nsoft.lt>
<014601c89626$065d4a80$131c480a@nsl.ad.nec.co.jp>
<47F5E12B.70701@nsoft.lt>
Julius Tuskenis wrote:
>> For some reason the size of database is asked to restrict to 900MB.
>> So I have to make efforts to make sure that its size is less than 900MB.
Two things I can think of that may get you a message like this.
1. Available disk space (or quotas for the postgres user) - which
partition is the db on and how much free space does it have?
2. You are storing all data in the same row and column (as in adding to
data there not inserting data into a new row) which is restricted to 1GB
What is the exact message you get in regards to this limit?
And where does this appear to come from?
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: pgsql@Sheeky.Biz, julius@nsoft.lt
Subject: Re: store different tables in different locations
In-Reply-To: <47F662B4.7080903@Sheeky.Biz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox