<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Richard Heimann [C] wrote:
<blockquote cite="mid:002101c83d9e$1612ff50$3b81fa84@aitgis" type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="Generator" content="Microsoft Word 11 (filtered)">
<title>RE: [postgis-users] HELP adding spatial field to table</title>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Book Antiqua";
panose-1:2 4 6 2 5 3 5 3 3 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0pt;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{margin-right:0pt;
margin-left:0pt;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle18
{font-family:Arial;
color:navy;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<div class="Section1">
<p class="MsoNormal"><font color="navy" face="Book Antiqua" size="3"><span
style="font-size: 12pt; font-family: "Book Antiqua"; color: navy;">This
question is
more to do with PostgreSQL then PostGIS but I’ve always gotten good
response on this forum and so I’m going back to the well. </span></font></p>
<p class="MsoNormal"><font color="navy" face="Book Antiqua" size="3"><span
style="font-size: 12pt; font-family: "Book Antiqua"; color: navy;"> </span></font></p>
<p class="MsoNormal"><font color="navy" face="Book Antiqua" size="3"><span
style="font-size: 12pt; font-family: "Book Antiqua"; color: navy;">After
a recent load,
I received the following error, “…No space left on device SQL State
53100 Hint: Check free Disk Space.” This error is fairly
self-explanatory
but I don’t know how to approach the problem. In SQL server I would
simple stop autogrowth on a file group, create a new file group on a
larger
partition and be done or alternately attached/detach the database onto
new
partition and begin work again. My point is there are several ways but
Im new
to PostrgeSQL and Im curious - what’s the best practice. I believe all
the data is in the installation directory <data> folder. Can I
simply
move this folder and somehow reattach? Thanks in advance, Rich</span></font></p>
</div>
</blockquote>
<br>
You have two "good" options to correct this problem:<br>
- Use Paul's suggestion (what you mention above) to move your
entire database to a different drive/partition. This solution is good
until that partition runs out of space, then you have to move it again
;-) I would recommend not changing your postgresql.conf file to
reflect the new directory - rather - modify your startup scripts so
pg_ctl is called with the appropriate directory argument...<br>
- Use PostgreSQL's Tablespace mechanism to spread your data across
multiple partitions. This is generally the preferred method, since it
allows you to leverage multiple drives/partitions for the storage of
data. The URL below describes how to do this:<br>
<a class="moz-txt-link-freetext" href="http://www.postgresql.org/docs/8.2/static/manage-ag-tablespaces.html">http://www.postgresql.org/docs/8.2/static/manage-ag-tablespaces.html</a><br>
<br>
Tablespaces were introduced in PostgreSQL 8.0. If you are using an
older version of PostgreSQL then you'd have to resort to some different
techniques to achieve a similar result.<br>
<br>
<pre class="moz-signature" cols="72">--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
919-463-0999/877-258-8987
<a class="moz-txt-link-freetext" href="http://www.otg-nc.com">http://www.otg-nc.com</a>
Expert PostgreSQL Training
</pre>
</body>
</html>