Please upgrade to 6.5. We have problems in earlier releases on this.
> Hi,
>
> I have a table exceeding the size of 2GB in version 6.4 on Linux x86.
> When I try to do a select I just receive:
> ERROR: cannot open segment 1 of relation entry
>
> According to the 6th point in the postgresql-howto postgresql supports
> larger, much larger databases than this size on even 32 bit architectures
> with some performance penalty.
>
> What have I missed?
> (a fear that certain tables must be smaller than 2G...)
> If this is true, is the only solution to buy a 64 bit architecture (sparc
> or alfa?)
>
> Attila
>
>
>
--
Bruce Momjian | http://www.op.net/~candle
maillist@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
