Hard Drive Size Limitation

[Shawn Tayler]

On Tue, 2009-07-14 at 20:40 -0500, David A. Bandel wrote:
> Please describe postgresql's fubar.  8.2.x is seriously dated.  If
> you're referring to db problems around typecast errors, blame your db
> design or your code.  8.3.x doesn't do automatic type casting for you
> -- it might cast the wrong way.
> 
> Ciao,
> 
> David A. Bande

Hi david,

I have run into the type casting issue, why I am still on 8.2.  I'm not
a trained DB admin, it started as a need and morphed into a rather giant
data warehousing and reporting monstrocity, 112 Gbytes (just data) and
climbing 2-3 million records a day.  I had to figure it out as I went,
started on 7.4 and transitioned to 8.  I know my code is fairly crappy
and I hope to have time to fix it someday.  It's all trial and error
with no real professional help available and no budget, bash and sql
scripts.  I admin with psql and use pgadmin to edit records when needed.
I didn't setup any of the conf items for the large volume of data and I
am over 48hrs so far on building the indexes after restoring the data.
I'll redo the conf after it finishes and I can restart the service,
maybe tomorrow.

The FUBARed issue was that the installation had file location problems
and configuration files that wouldn't parse.  I spent nearly 3 hours
just trying to get the bone stock installation to even start.  Its all
kind of hazy now, 12+ hours of futz'ing will do that to a person.  I
just tried to go into my bash_history to see if I could find any tidbits
I could quote here to help explain but they've aged out I guess.  I'm
not against moving to 8.3, if I can fix the casting issues, but I will
build from source.  I'm not trusting the pre-built again, ever.

Shawn