Re: [GENERAL] postgres wish list

2009-02-21 Thread Martijn van Oosterhout
On Fri, Feb 20, 2009 at 09:50:25AM +, Jasen Betts wrote: > by the default authentication for unix domain sockets is "ident" which > (AIUI) requires the caller have the a unix username that matches their > postgres username, but you can change that to "md5" (password based) > or "trust" (no aut

Re: [GENERAL] postgres wish list

2009-02-20 Thread Jasen Betts
On 2009-02-19, Sameer Mahajan wrote: > Thanks Craig. > > Comments inline. > >> > [Sameer Mahajan] I will investigate how the unix domain sockets help in > my case. Why isn't it the default for postgres installations? Or it > isn't believed to be generic enough / straight forward enough to > confi

Re: [GENERAL] postgres wish list

2009-02-19 Thread John R Pierce
Chander Ganesan wrote: Basically, if you try to use PostgreSQL as a local data store for a desktop app, you'll likely want to use socket connections. Unfortunately, if its a windows app, I'm not sure if there is much benefit to using a socket over tcp/ip . I thought at one point there was an

Re: [GENERAL] postgres wish list

2009-02-19 Thread Craig Ringer
Sameer Mahajan wrote: > [Sameer Mahajan] I will investigate how the unix domain sockets help in > my case. Why isn't it the default for postgres installations? Or it > isn't believed to be generic enough / straight forward enough to > configure? It is the default. Just connect without a host para

Re: [GENERAL] postgres wish list

2009-02-19 Thread Chander Ganesan
Thomas Kellerer wrote: Sameer Mahajan, 19.02.2009 07:38: * Shared memory based connectivity: As such postgres has client - server model. The TCP-IP nature of its connectivity further adds to the latency of this communication. It will be nice to have a shared memory based connectivity bet

Re: [GENERAL] postgres wish list

2009-02-19 Thread Thomas Kellerer
Sameer Mahajan, 19.02.2009 07:38: * Shared memory based connectivity: As such postgres has client - server model. The TCP-IP nature of its connectivity further adds to the latency of this communication. It will be nice to have a shared memory based connectivity between libpq front end and

Re: [GENERAL] postgres wish list

2009-02-19 Thread John R Pierce
Sameer Mahajan wrote: [Sameer Mahajan] I will investigate how the unix domain sockets help in my case. Why isn't it the default for postgres installations? Or it isn't believed to be generic enough / straight forward enough to configure? hmm? Domain sockets -are- the default. just don't s

Re: [GENERAL] postgres wish list

2009-02-19 Thread Grzegorz Jaśkiewicz
and I wish you didn't send emails with images attached to public lists... -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] postgres wish list

2009-02-19 Thread Sameer Mahajan
Thanks Craig. Comments inline. > -Original Message- > From: Craig Ringer [mailto:cr...@postnewspapers.com.au] > Sent: Thursday, February 19, 2009 12:56 PM > To: Sameer Mahajan > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] postgres wish list > > Sam

Re: [GENERAL] postgres wish list

2009-02-18 Thread Craig Ringer
Sameer Mahajan wrote: I recently worked on rewriting a fairly complex Berkeley DB based system using Postgres DB. Following is a wish list and a brief explanation for each of those items for postgres. It is not necessarily a comparison of postgres functionality with that of Berkeley DB but some