"Emils Klotins" <emils@mail.usis.bkc.lv> writes:
> When I try to "SELECT * FROM most of the tables (except for
> ones which have 2 or less rows) , the backend dies:
> If i try to select specific field (address_id or lastname,
> firstname from the same table - it works).
That's really odd. I doubt you have a memory problem; corrupted
data or maybe an outright bug of some kind seem more likely.
What error message, if any, shows up in the postmaster log file?
Also, the crashed backend presumably leaves a core file in the database
directory. Do you know how to use gdb to get a backtrace showing what
the backend was doing? Briefly it'sgdb path/to/postgres path/to/corebtquit
regards, tom lane