Re: postgres sometimes returns no data

thx both for responding.

Because the checkpoint settings probably haven't changed in a long long time
and we see as many of those warnings on good nights as bad I'm going to make
those priority 2. Unless there is a cause and effect u can explain between
checkpointing and what we are experiencing. I'll have to find the config
setting too.

Yes, client and server are on the same machine.

Windows 7 professional, sp1, 32 gb, 64 bit.

Before unexpected eof, lots of checkpoint warnings back to and prior to what
I am presuming is the start up time for this component. After are a bunch
more unexpected eofs followed by more checkpoint warnings.

I haven't looked at the os logs but will post back here what I find.

The job is loading a bunch of postgres tables but in this component which
follows all of that, a postgres extract query is supposed to run, feed 3
switches in parallel which in turn direct or divert certain text file writes
to occur. The component that follows this one does a remote call that
causes an app to import one of the files this problem component creates.

--
View this message in context: http://postgresql.nabble.com/postgres-sometimes-returns-no-data-tp5873720p5873730.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.