Re: [ADMIN] Postgres at startup

2006-11-17 Thread Kis János Tamás
2006. November 16. 08.05 dátummal Kis János Tamás ezt írta: > 2006. November 8. 02.34 dátummal Michael McCloskey ezt írta: > > see postmaster.exe and 4 postgres processes. Ooops! I don't see the ".exe"... I'm sorry! bye, kjt McAfee SCM 4.1 által ellenőrizve! ---(end of

[ADMIN] Client SSL validation using root.crt

2006-11-17 Thread [EMAIL PROTECTED] (IMAP)
Dear list members, I see a strange behaviour using root.crt. PostgreSQL always waits a client certificate to check agains root.crt. But I set up a 'hostnossl' auth line un pg_hba.conf, PostgreSQL still wants a client certificate. Also fails if line is a 'host'. Better with an example: ---pg_hba.

Re: [ADMIN] Client SSL validation using root.crt

2006-11-17 Thread Tom Lane
"[EMAIL PROTECTED] (IMAP)" <[EMAIL PROTECTED]> writes: > I see a strange behaviour using root.crt. PostgreSQL always waits a > client certificate to check agains root.crt. But I set up a > 'hostnossl' auth line un pg_hba.conf, PostgreSQL still wants a client > certificate. If your client first tri

[ADMIN] remote connections to Windows based server

2006-11-17 Thread Paul Forgey
I am running the pre-built Windows version of postgresql 8.1. I have a local LAN with a 10.6/16 network. Apparently there's something more than what's in the FAQ or my interpretation of the manual to get remote connections working. pg_hba.conf: host all all 10.6/16 md5 host all all 127.0.0

Re: [ADMIN] remote connections to Windows based server

2006-11-17 Thread Jeff Frost
On Fri, 17 Nov 2006, Paul Forgey wrote: I am running the pre-built Windows version of postgresql 8.1. I have a local LAN with a 10.6/16 network. Apparently there's something more than what's in the FAQ or my interpretation of the manual to get remote connections working. pg_hba.conf: host al

Re: [ADMIN] remote connections to Windows based server

2006-11-17 Thread Tom Lane
Paul Forgey <[EMAIL PROTECTED]> writes: > I am running the pre-built Windows version of postgresql 8.1. I have > a local LAN with a 10.6/16 network. Apparently there's something more > than what's in the FAQ or my interpretation of the manual to get > remote connections working. > pg_hba.co

Re: [ADMIN] remote connections to Windows based server

2006-11-17 Thread Tom Lane
Jeff Frost <[EMAIL PROTECTED]> writes: > I believe you must list all 4 octets of the subnet. Oh, duh. The comments in inet_aton() show that it is interpreting "10.6" in what most people nowadays would find a surprising way: case 1: /* a -- 32 bits */

Re: [ADMIN] remote connections to Windows based server

2006-11-17 Thread Jeff Frost
On Fri, 17 Nov 2006, Tom Lane wrote: Jeff Frost <[EMAIL PROTECTED]> writes: I believe you must list all 4 octets of the subnet. Oh, duh. The comments in inet_aton() show that it is interpreting "10.6" in what most people nowadays would find a surprising way: case 1:

Re: [ADMIN] remote connections to Windows based server

2006-11-17 Thread Tom Lane
Jeff Frost <[EMAIL PROTECTED]> writes: > Paul, just add the 0s and you'll be golden. I've tweaked the SGML docs to make it clearer that omitting trailing zeroes here isn't a good idea. regards, tom lane ---(end of broadcast)

Re: [ADMIN] remote connections to Windows based server

2006-11-17 Thread Paul Forgey
On Nov 17, 2006, at 2:41 PM, Jeff Frost wrote: On Fri, 17 Nov 2006, Paul Forgey wrote: I am running the pre-built Windows version of postgresql 8.1. I have a local LAN with a 10.6/16 network. Apparently there's something more than what's in the FAQ or my interpretation of the manual to g

Re: [ADMIN] 100% failover + replication solution

2006-11-17 Thread Bruce Momjian
Brad Nicholson wrote: > Excellent addition. I suggest in 24.1 - Shared Disk Failover something > about the risk of having two postmasters come up on the same data > directory, which is entirely possible if the old master doesn't release > the disk in time. I have added a mention of this. ---