Search Postgresql Archives

Re: PostgreSQL on Webmin

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux