Re: Using named pipes !!

Well, first I would like to clarify something:

If I use the postgre's unix_socket connection,  postgres still listening and answering requests for the network?
	
My question is because I read the following error when I put the connection string suggested by Kris Nielander (that is the same of the documentation):

named -f -g
27-Apr-2009 16:31:51.037 starting BIND 9.4.2-P2 -f -g
27-Apr-2009 16:31:51.037 found 2 CPUs, using 2 worker threads
27-Apr-2009 16:31:51.044 loading configuration from '/etc/bind/named.conf'
27-Apr-2009 16:31:51.045 no IPv6 interfaces found
27-Apr-2009 16:31:51.045 listening on IPv4 interface lo, 127.0.0.1#53
27-Apr-2009 16:31:51.047 binding TCP socket: address in use
27-Apr-2009 16:31:51.047 listening on IPv4 interface eth0, 10.7.20.2#53
27-Apr-2009 16:31:51.049 binding TCP socket: address in use
27-Apr-2009 16:31:51.052 Loading 'postgres zone' using driver postgres
27-Apr-2009 16:31:51.054 Postgres driver failed to create database connection number 1 after 4 attempts
27-Apr-2009 16:31:51.054 SDLZ driver failed to load.
27-Apr-2009 16:31:51.054 DLZ driver failed to load.
27-Apr-2009 16:31:51.054 loading configuration: failure
27-Apr-2009 16:31:51.054 exiting (due to fatal error)

So, could someone (maybe you Kris ;) ) having dlz running by using just /tmp for the host, (like so {host=/tmp dbname=DATABASE user=USER}) show me the output while dlz is working for: 
1.- ls -l -a /tmp 
I hope to find some output to help me to at least identify the name of the socket.
2.- I need to see the value passed to the connection settings of postgres, some values that I have are:
listen_addresses = '*'
port = 5901
unix_socket_directory = '/var/run/postgresql' ->I tried change host=/var/run/postgresql in my connection string, and still give me the same error.
unix_socket_permissions = 0777
#unix_socket_group = 'postgres' -> Is commented.

ls -l -a /var/run/postgresql show me the following output:
-rw-------  1 postgres postgres   6 2009-04-27 16:19 8.3-main.pid
srwxrwxrwx  1 postgres postgres   0 2009-04-27 17:17 .s.PGSQL.5901
-rw-------  1 postgres postgres  35 2009-04-27 17:17 .s.PGSQL.5901.lock

Well, that’s all for now. Thank you very much at all willing to help.

PD: Excuse my little language, but English is not my native language.


-----Mensaje original-----
De: Kris Nielander [mailto:[email protected]] 
Enviado el: lunes, 27 de abril de 2009 9:18
Para: [email protected]
Asunto: Re: [Bind-dlz-testers] Using named pipes !!

Just use /tmp for the host, like so

{host=/tmp dbname=DATABASE user=USER}

Cheers,

On Mon, 2009-04-27 at 05:19 +0200, Reyner Herrpinark Lugo wrote:
> Can anyone tell me how to create a named pipe for use with Postgres ?
> I would use it to optimize the connection method but I really don’t
> know how make a named pipe.
> 
>  
> 
> Regards
> 
>  
> 
>  Rey.
> 
> 
-- 
Kris Nielander
Network Engineer
t: +31.10.750.7007
f: +31.10.750.7005
w: http://www.we-dare.net/


------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensign option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Bind-dlz-testers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers
------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations 
Conference from O'Reilly Media. Velocity features a full day of 
expert-led, hands-on workshops and two days of sessions from industry 
leaders in dedicated Performance & Operations tracks. Use code vel09scf 
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Bind-dlz-testers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers