Re: [GENERAL] Re: Error on Windows server could not open relation base/xxx/xxx Permission denied

2010-06-12 Thread Craig Ringer
On 13/06/10 02:34, Adrian Klaver wrote: >> Question: Is it possible that there's corruption in the database which is >> being incorrectly reported as "Permission denied"? It's certainly not impossible. It'd really help if Pg would print more details from Windows' error reporting - GetLastError()

Re: [GENERAL] Re: Error on Windows server could not open relation base/xxx/xxx Permission denied

2010-06-12 Thread John T. Dow
I will provide some answers tomorrow, but I don't have access now. It's a law enforcement agency in another state and the officer I work with will be in Sunday. The original computer's postgres server is stopped, and port forwarding wasn't changed yet so I don't have access to the new computer w

Re: [GENERAL] Re: Error on Windows server could not open relation base/xxx/xxx Permission denied

2010-06-12 Thread Adrian Klaver
On Saturday 12 June 2010 12:59:18 pm John T. Dow wrote: I am CC'ing the list so more eyes can follow this. > > > >Some more questions. > >What is the relation that is having the permissions issue? > >Are the permissions on that file different from the others in the base > > directory tree? > >Wha

Re: [GENERAL] Best way to store case-insensitive data?

2010-06-12 Thread Scott Marlowe
n Sat, Jun 12, 2010 at 3:21 PM, Scott Marlowe wrote: > Performance test the index: > > create test_index on table (lower(fieldname)); > > versus storing the emails in lower case. Some quick testing on that tells me that storing in lower case will be about twice as fast at retrieval. But we're ta

Re: [GENERAL] Best way to store case-insensitive data?

2010-06-12 Thread Scott Marlowe
2010/6/11 Mike Christensen : > Yea this is a valid point.  It's very possible my design won't work > for the long term, and at some point I'll have to store the email name > exactly as it was entered, and allow the lookup logic to be case > insensitive with a lowercase index.  However, I think the

Re: [GENERAL] Best way to store case-insensitive data?

2010-06-12 Thread Adrian von Bidder
On Friday 11 June 2010 09.27:15 Michal Politowski wrote: [email address local part is case sensitive] > In practice I've yet to see a system having both smith and Smith > and them being different, but still it is theoretically posible. I routinely modify email addresses I store to my addressbook

Re: [GENERAL] Re: Error on Windows server could not open relation base/xxx/xxx Permission denied

2010-06-12 Thread Adrian Klaver
On Saturday 12 June 2010 11:07:32 am John T. Dow wrote: > I posted this two days ago and nobody has commented. I'm reposting the > message because I really need advice. Background info: My client got the > "permission denied" error on his original server and we removed the AV > software without sol

Re: [GENERAL] Re: Error on Windows server could not open relation base/xxx/xxx Permission denied

2010-06-12 Thread John T. Dow
I posted this two days ago and nobody has commented. I'm reposting the message because I really need advice. Background info: My client got the "permission denied" error on his original server and we removed the AV software without solving the problem. Since the computer is running Windows 2000

Re: [GENERAL] Cognitive dissonance

2010-06-12 Thread Bruce Momjian
Tim Landscheidt wrote: > Bruce Momjian wrote: > > > [...] > > + # single-page text > > + postgres.txt: postgres.html > > + $(LYNX) -force_html -dump -nolist -stdin $< > $@ > ^^ > > + > > [...] > > Isn't that unnecessary/wrong as the filename is sup

Re: [GENERAL] Cognitive dissonance

2010-06-12 Thread Tim Landscheidt
Bruce Momjian wrote: > [...] > + # single-page text > + postgres.txt: postgres.html > + $(LYNX) -force_html -dump -nolist -stdin $< > $@ ^^ > + > [...] Isn't that unnecessary/wrong as the filename is supplied on the command line? Tim -- Sent

Re: [GENERAL] Cognitive dissonance

2010-06-12 Thread Bruce Momjian
John Gage wrote: > UFB! This was definitely worth the visit from the Nebula. > > Thanks very, very much. > > Sensational. > > Thanks again, > > John Gage We still have to decide how to make these accessible from our web site. -- Bruce Momjian http://momjian.us EnterpriseDB

Re: [GENERAL] Cognitive dissonance

2010-06-12 Thread John Gage
UFB! This was definitely worth the visit from the Nebula. Thanks very, very much. Sensational. Thanks again, John Gage On Jun 12, 2010, at 6:01 PM, Bruce Momjian wrote: http://momjian.us/expire/ The new rule name is postgres.txt. The file size are: 7,789,730 postgres.h

[GENERAL] 2010 eclipse community survey

2010-06-12 Thread Merlin Moncure
Primary Database: Postgres 11% Mysql 31.8% Oracle 21.6% I found the 2009 results: Postgres 9.9% Mysql 27.7% Oracle 27.3% Postgres beat out sql server. Of course, eclipse is heavily skewed towards java which is going to be very lightweight on the ms stack for obvious reasons. I think the main ta

Re: [GENERAL] Cognitive dissonance

2010-06-12 Thread Bruce Momjian
Peter Eisentraut wrote: > On l?r, 2010-06-12 at 09:10 -0400, Tom Lane wrote: > > Peter Eisentraut writes: > > > On l?r, 2010-06-12 at 11:18 +0200, John Gage wrote: > > >> A one file html version would be a godsend. > > > > > I've committed a build target for that now. Use 'make postgres.html' in

Re: [GENERAL] Cognitive dissonance

2010-06-12 Thread Peter Eisentraut
On lör, 2010-06-12 at 09:10 -0400, Tom Lane wrote: > Peter Eisentraut writes: > > On lör, 2010-06-12 at 11:18 +0200, John Gage wrote: > >> A one file html version would be a godsend. > > > I've committed a build target for that now. Use 'make postgres.html' in > > doc/src/sgml/. > > Huh, is tha

Re: [GENERAL] GSS Authentication

2010-06-12 Thread Bryan Montgomery
Hi Steven, Thanks for the info here. In particular, On Sat, Jun 12, 2010 at 12:58 AM, Stephen Frost wrote: > You may also need to make sure that your default realm is set correctly > and that your reverse DNS is working. Also, can you look in the PG > server-side logs and see what errors are be

Re: [GENERAL] Cognitive dissonance

2010-06-12 Thread Stephen Frost
* Tom Lane (t...@sss.pgh.pa.us) wrote: > Peter Eisentraut writes: > > I've committed a build target for that now. Use 'make postgres.html' in > > doc/src/sgml/. > > Huh, is that actually worth anything? How many browsers will open it > without crashing, or will navigate the page with decent per

Re: [GENERAL] Cognitive dissonance

2010-06-12 Thread John Gage
It was. But if the compromise is single file html, that is a vast improvement over the current system imho. What I want is the thing that is maximally amenable to being searched conveniently using all the tools at our disposal especially regular expressons. The point has been made that Go

Re: [GENERAL] Cognitive dissonance

2010-06-12 Thread Tom Lane
Peter Eisentraut writes: > On lör, 2010-06-12 at 11:18 +0200, John Gage wrote: >> A one file html version would be a godsend. > I've committed a build target for that now. Use 'make postgres.html' in > doc/src/sgml/. Huh, is that actually worth anything? How many browsers will open it without

Re: [GENERAL] GSS Authentication

2010-06-12 Thread Stephen Frost
* Bryan Montgomery (mo...@english.net) wrote: > I've been trying this as well off and on. In my case I'm not convinced the > AD configuration is correct (And someone else manages that). Yeah, that can be a challenge.. but it's *definitely* possible to get it set up and working correctly. > Can y

Re: [GENERAL] GSS Authentication

2010-06-12 Thread Stephen Frost
Bryan, * Bryan Montgomery (mo...@english.net) wrote: > On Sat, Jun 12, 2010 at 12:58 AM, Stephen Frost wrote: > Can you elaborate on the DNS requirements? How would I check the reverse > DNS? I assume just pinging both server by hostname? Kerberos depends on reverse DNS. Reverse DNS is IP Addre

Re: [GENERAL] Cognitive dissonance

2010-06-12 Thread Peter Eisentraut
On lör, 2010-06-12 at 11:18 +0200, John Gage wrote: > A one file html version would be a godsend. I've committed a build target for that now. Use 'make postgres.html' in doc/src/sgml/. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] Cognitive dissonance

2010-06-12 Thread John Gage
A one file html version would be a godsend. On Jun 12, 2010, at 3:20 AM, Bruce Momjian wrote: Robert Gravsjö wrote: I am for #1, not so much for #2, mainly on the grounds of size. But given #1 it would be possible for packagers to make their own choices about whether to include plain-te

Re: [GENERAL] GSS Authentication

2010-06-12 Thread Bryan Montgomery
I've been trying this as well off and on. In my case I'm not convinced the AD configuration is correct (And someone else manages that). Can you use kinit with the key tab options to get a good response from the server? I think I should be able to do this .. $ kinit -V -k -t poe3b.keytab HTTP/poe3b