[GENERAL] postgres sometimes returns no data

Hi. We have a postgres 9.1 query in a pentaho job (table input component contains the query and is followed by various switches) that runs nightly. More and more frequently (about half the time now), the query returns no data (or appears to return no data, see last paragraph) when there is clearl

Re: [GENERAL] 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 experiencin

Re: [GENERAL] postgres sometimes returns no data

thx, the fact that the query runs under pentaho at least half of the time (used to be most of the time) makes me think it will run on the db. I'll try to get a handle on the cpu/handle info u requested. -- View this message in context: http://postgresql.nabble.com/postgres-sometimes-returns-no-

Re: [GENERAL] postgres sometimes returns no data

there is something i need to correct. Coming out of one of the 3 switches are two branches that cause updates to the same "interaction log" table in postgres. Not text files like the other 2 switches. -- View this message in context: http://postgresql.nabble.com/postgres-sometimes-returns-n

Re: [GENERAL] postgres sometimes returns no data

pls remember that since the switches didn't run, this all (or mostly) could be related to an unknown process. My bad component appears to have started around 54 seconds into nov 10. The overall job appears to have ended around 01:01:44 which makes me wonder if a lot of the EOFs are related to som

Re: [GENERAL] postgres sometimes returns no data

it looks like a lot of the log attributes ion the config are defaulting, probably to NOTICE. I see a # in front of many. If the community can advise on better choices and how bad the footprint would be for me to change these, pls let me know. I'm guessing the log excerpt I posted isn't telling u

Re: [GENERAL] postgres sometimes returns no data

currently, log line prefix is log_line_prefix = '%t '. Not sure what the blank following the t does. u probably want me to change it to log_line_prefix = '%t%a%u%d%r%h%p% ' or something like that? -- View this message in context: http://postgresql.nabble.com/postgres-sometimes-returns-no-data

Re: [GENERAL] postgres sometimes returns no data

a couple of these say cant be changed after session start. Is that the same as reload? Can I change it back if I do a reload? -- View this message in context: http://postgresql.nabble.com/postgres-sometimes-returns-no-data-tp5873720p5873832.html Sent from the PostgreSQL - general mailing list

Re: [GENERAL] postgres sometimes returns no data

run this on pg admin III to reload SELECT pg_reload_conf() ? Also, I now see the format for multiple log line prefixes...blank after each choice including last. I will try that once i'm comfortable with how I'll be reloading postgres. -- View this message in context: http://postgresq

Re: [GENERAL] postgres sometimes returns no data

I looked at event viewer in both Application and System. Neither shows anything unusual around that time, just Volume Shadow Copy service stopping. -- View this message in context: http://postgresql.nabble.com/postgres-sometimes-returns-no-data-tp5873720p5873841.html Sent from the PostgreSQL -

Re: [GENERAL] postgres sometimes returns no data

ok, I poked around and see a reload config option in pg admin iii. I guess i'm ready to go. -- View this message in context: http://postgresql.nabble.com/postgres-sometimes-returns-no-data-tp5873720p5873846.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent

[GENERAL] downloaded 9.1 pg driver but odbcad32 doesnt see it

Hi. I downloaded a driver for 9.1 from https://jdbc.postgresql.org/download.html and see a jar file that was downloaded. I went to odbcad32 to add a dsn but odbcad32 doesnt see a driver for pg. What steps am i missing? -- View this message in context: http://postgresql.nabble.com/downloaded-

[GENERAL] downloaded 32 bit pg 9.1 but driver isnt seeing some rows

Hi I downloaded pg 32 bit 9.1. I noticed the list of drivers the install referenced didnt look like 9.1 but i selected all and continued anyway. When i run a select distinct query against one of my existing tables on a pre existing 9.1 pg server some values that i know are there dont show. Speci

Re: [GENERAL] downloaded 32 bit pg 9.1 but driver isnt seeing some rows

i now see that the ip address may have been wrong. I'll post back here. -- View this message in context: http://postgresql.nabble.com/downloaded-32-bit-pg-9-1-but-driver-isnt-seeing-some-rows-tp5903332p5903336.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Se

Re: [GENERAL] downloaded 32 bit pg 9.1 but driver isnt seeing some rows

i had the wrong ip address. I'm ok. -- View this message in context: http://postgresql.nabble.com/downloaded-32-bit-pg-9-1-but-driver-isnt-seeing-some-rows-tp5903332p5903338.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (p