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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
