Re: PostgreSQL on Webmin

Kostadin Solakov wrote:
> Anyway I managed to connect to localhost, but after I made changes to
> pg_connect and I removed the host name
> FROM
>
>    1. pg_pconnect("host=localhost dbname=mydb user=myuser
> password=mypassword");
>
> TO
>
>    1. pg_pconnect("dbname=mydb user=myuser password=mypassword");
>
>
> Now it works, but VERY SLOWER than before.
> One of the scripts I'm running on the previous host took below 2 sec for
> 1000 entries and now it takes 1 sec for 100 entries.
>   

thats odd, as a domain socket should be slightly -faster- than a tcp/ip 
socket.   now, since you say 'previous host' I could wonder if other 
configuration items are impacting this, such as buffer sizes in 
postgresql.conf, relative speed of disk controllers, etc.   or perhaps 
this new database hasn't been analyzed since it was populated, or its 
indexes need rebuilding, or something similar...


> working pg_hba.conf looks like this:
>
>    1. # IPv4 local connections:
>    2.  local   all         all                               trust
>    3.  local   all         my_user                          ident sameuser
>    4.  local my_db my_user password
>   
line 2 masks lines 3,4 as it accepts any connection to any database over 
'local' (unix domain socket), so it would never bother to try the others.


>    5.  host my_db my_user 0.0.0.0/0 password
>   

that line would allow anyone anywhere (assuming listen_address = '*' in 
postgresql.conf, and no firewalls intervene) to connect as myuser to 
mydb with a password