Re: [BUGS] BUG #6256: loading small file eats all memory and crashes system

2011-10-15 Thread Alex Hunsaker
On Sat, Oct 15, 2011 at 14:16, Rachael Nelson wrote: > Attached is a tiny bit of top output (top.txt), the file being imported > (postgres.sql.gz - about 32MB), and the perl module script that generates Thanks. So the problem here seems to be postgres does not handle a multi-hundred megabyte sing

Re: [BUGS] BUG #6256: loading small file eats all memory and crashes system

2011-10-15 Thread Alex Hunsaker
On Sat, Oct 15, 2011 at 13:40, Rachael Nelson wrote: > When I run this it does the same: > > psql test dev < postgres.sql > > the db is named test, connecting with the dev user. I assume you meant to hit reply all :-) If you can provide a self contained test case ideally in the form of an .sql f

Re: [BUGS] BUG #6256: loading small file eats all memory and crashes system

2011-10-15 Thread Alex Hunsaker
On Fri, Oct 14, 2011 at 21:43, Rachael wrote: > > The following bug has been logged online: > > Bug reference:      6256 > Logged by:          Rachael > Email address:      rulonr...@gmail.com > PostgreSQL version: 9.11 > Operating system:   Arch  Linux > Description:        loading small file eat

[BUGS] BUG #6256: loading small file eats all memory and crashes system

2011-10-15 Thread Rachael
The following bug has been logged online: Bug reference: 6256 Logged by: Rachael Email address: rulonr...@gmail.com PostgreSQL version: 9.11 Operating system: Arch Linux Description:loading small file eats all memory and crashes system Details: While attempting to

[BUGS] BUG #6255: Unable to Install (Binary, One Click Installer

2011-10-15 Thread stephen
The following bug has been logged online: Bug reference: 6255 Logged by: stephen Email address: snpmons...@gmail.com PostgreSQL version: 9.1.1 Operating system: Windows 7 Description:Unable to Install (Binary, One Click Installer Details: Hi, I tried installing/run