On Tue, Nov 12, 2013 at 6:57 AM, Jayadevan M maymala.jayade...@gmail.comwrote:
Hi,
What are the real differences between the bgwriter and checkpointer
process? Both of them write data from the buffer to the data files, right?
Is it just a matter of 'when' they write?
Regards,
Jayadevan
On Tue, Nov 12, 2013 at 6:57 AM, Jayadevan M maymala.jayade...@gmail.comwrote:
Hi,
What are the real differences between the bgwriter and checkpointer
process? Both of them write data from the buffer to the data files, right?
Is it just a matter of 'when' they write?
I believe, Checkpoint
Em 12/11/2013 03:37, Brian Crowell br...@fluggo.com escreveu:
On Mon, Nov 11, 2013 at 10:51 PM, Brian Crowell br...@fluggo.com wrote:
I think I'm getting closer though. I have psql on Windows successfully
authenticating, so I can't be too far off.
Got it.
The NpgsqlPasswordPacket class
On Tue, Nov 12, 2013 at 6:56 AM, Christian Ullrich ch...@chrullrich.netwrote:
* From: Brian Crowell
On Mon, Nov 11, 2013 at 10:51 PM, Brian Crowell br...@fluggo.com
wrote:
I think I'm getting closer though. I have psql on Windows successfully
authenticating, so I can't be too far off.
On Tue, Nov 12, 2013 at 5:45 AM, Francisco Figueiredo Jr.
franci...@npgsql.org wrote:
It would be awesome if you could write a little guide about how to configure
PostgreSQL to work with sspi authentication from Windows.
I could add it to our Npgsql user manual...
A guide will have to wait
On Tue, Nov 12, 2013 at 9:13 AM, Brian Crowell br...@fluggo.com wrote:
net ads keytab add postgres/machinen...@realm.com -U DOMAIN\Administrator
net ads keytab add postgres/machinename.domain@realm.com -U
DOMAIN\Administrator
D'oh! These should be:
net ads keytab add
Hi All,
How to remove {} from output
I am using below query
select (xpath('//Grading_Automated',(select xmlgrading from km_course_mast
where id='10'))) from km_course_mast where id='10'
The out is below
{Grading_Automated
/Grading_Automated}
Thanks,
Gajendra
On Mon, Nov 11, 2013 at 11:56 PM, Christian Ullrich
ch...@chrullrich.net wrote:
On Mon, Nov 11, 2013 at 10:51 PM, Brian Crowell br...@fluggo.com wrote:
* If I don't specify my username, Npgsql sends it in lowercase bcrowell
Hmm. That is related one problem I've been having with SSPI auth from
* From: Brian Crowell
On Mon, Nov 11, 2013 at 11:56 PM, Christian Ullrich
ch...@chrullrich.net wrote:
On Mon, Nov 11, 2013 at 10:51 PM, Brian Crowell br...@fluggo.com
wrote:
* If I don't specify my username, Npgsql sends it in lowercase
bcrowell
Hmm. That is related one problem I've
On Tue, Nov 12, 2013 at 8:46 PM, gajendra s v svgajen...@gmail.com wrote:
Hi All,
How to remove {} from output
I am using below query
select (xpath('//Grading_Automated',(select xmlgrading from km_course_mast
where id='10'))) from km_course_mast where id='10'
The out is below
On Tue, Nov 12, 2013 at 10:03 AM, Christian Ullrich
ch...@chrullrich.net wrote:
Pseudocode:
n = GetUserNameEx(NameSamCompatible)// logon screen case
NameTranslate.Set(ADS_NAME_TYPE_NT4, n)
n = NameTranslate.Get(ADS_NAME_TYPE_DOMAIN_SIMPLE) // official case
n =
Something else that causes a similar error is if the PostgreSQL daemon is
restarted in the middle of logging a query. The log line is truncated and the
next log line starts straight after the truncated line without even a newline
in between. The problematic line can be many lines before where
On Tue, Nov 12, 2013 at 5:45 AM, Francisco Figueiredo Jr.
franci...@npgsql.org wrote:
I'm looking forward your patch.
Npgsql source can be found at github.com/npgsql/Npgsql
I figured out the username issue, and so I've sent a pull request:
https://github.com/npgsql/Npgsql/pull/95
I encountered
Jayadevan M maymala.jayade...@gmail.com wrote:
What are the real differences between the bgwriter and
checkpointer process? Both of them write data from the buffer to
the data files, right? Is it just a matter of 'when' they write?
The checkpointer process is responsible for creating safe
On Tue, Nov 12, 2013 at 4:17 PM, Brian Crowell br...@fluggo.com wrote:
On Tue, Nov 12, 2013 at 5:45 AM, Francisco Figueiredo Jr.
franci...@npgsql.org wrote:
I'm looking forward your patch.
Npgsql source can be found at github.com/npgsql/Npgsql
I figured out the username issue, and so I've
Kevin Goess kgo...@bepress.com writes:
We noticed a big change after upgrading from 9.0 to 9.2. For
*yesterday's*date, the query plan is fine, like you'd expect
articles_1= explain (analyze, buffers) select 1
from hits_user_daily_count
where userid = 1590185 and date =
On 11/11/13, 1:33 AM, Jeffrey Walton wrote:
The analyzer is reporting some findings, and some of the findings look
legitimate.
We have been tracking clang scan-build results for some time, and fixed
quite a few of them. Most of the remaining ones are false positives.
Maybe there are still a
Thanks for the reply!
Your analysis matches everything I see here, so what you say is probably
the case. As to why it changed for us with the 9.0 = 9.2 upgrade, I also
don't know--the change was pretty dramatic though. Since we've compensated
for it, and since you say the current behavior is
Kevin Goess kgo...@bepress.com writes:
Now, the only way to get to a zero selectivity estimate for var = const
is if the planner believes that the pg_stats most-common-values list
for the column is complete, and the constant is nowhere in the list.
So one plausible explanation for the change
Hello,
I am running postgresql 9.3 (installed via the
apt.postgresql.orgrepository) on Ubuntu 12.10. I just upgraded from
9.2 on a dev machine, and
when looking through the logs, I noticed that there were a lot of entries
stating LOG: setsockopt(TCP_KEEPIDLE) failed: Invalid argument.
I was
Kevin Grittner-5 wrote
The checkpointer process is responsible for creating safe points
from which a recovery can begin; the background writer tries to
keep some pages available for re-use so that processes running
queries don't need to wait for page writes in order to have free
spots to use
Grant Fisher gfis...@pecanstreet.org writes:
I am running postgresql 9.3 (installed via the
apt.postgresql.orgrepository) on Ubuntu 12.10. I just upgraded from
9.2 on a dev machine, and
when looking through the logs, I noticed that there were a lot of entries
stating LOG:
22 matches
Mail list logo