Re: [GENERAL] Re: COPY error: pqReadData() -- backend closed thechannel unexpectedly

2001-01-10 Thread Lee Joramo
>> general opinion on the Cobalt mailing lists is that upgrading Postgre is >> a very delicate task. [SNIP] > >Check, at least not without practicing on a spare machine first ;-). > >One thing to think about is that there's no fundamental reason why you'd >have to update the version of Postgres u

Re: [GENERAL] Re: COPY error: pqReadData() -- backend closed thechannel unexpectedly

2001-01-09 Thread Tod McQuillin
On Tue, 9 Jan 2001, Tom Lane wrote: > Postmaster and backend switches are two different animals. To specify > a backend switch to the postmaster, you need -o. Thus: > > postmaster -S -o "-S 1000" > > selects silent postmaster mode and 1000K sortsize for the backend. > > In short: postmast

Re: [GENERAL] Re: COPY error: pqReadData() -- backend closed thechannel unexpectedly

2001-01-09 Thread Tod McQuillin
On Tue, 9 Jan 2001, Tom Lane wrote: > -S suppresses all log output, so first you need to get rid of that. The postgres.1 man page from postgresql-7.0.3/doc/man.tar.gz says: -S SortSize Specifies the amount of memory to be used by inter- nal sorts and hashes b