Re: How do I install/run PostgreSQL 9.4 64 bit on Windows 7 Professional?

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

 



All,

For anyone who cares the "slowness solution" ended up being an"IPv6" vs
"IP4" situation.

After I changed

con <- dbConnect(drv, host = "localhost",  . . . 

to

con <- dbConnect(drv, host = "127.0.0.1" ....

the 'connect time went down from 15 seconds to less than 1 second.

Then I noticed ...

C:\Users\ComputerUser>ping localhost

Pinging COMPUTER [::1] with 32 bytes of data:
Reply from ::1: time=2ms
Reply from ::1: time=2ms
Reply from ::1: time=2ms
Reply from ::1: time=2ms

So i modified the 'hosts' file from

C:\Windows\System32\drivers\etc\host

from

# localhost name resolution is handled within DNS itself. 
 	127.0.0.1       localhost
#	::1                localhost

to

# localhost name resolution is handled within DNS itself. 
 	127.0.0.1       localhost   # ( *** UN-COMMENTED ***** )
#	::1                localhost

( In order to make this  change ( as Administrator ) I had to temporarily
take off the 'read only flag' on the directory
C:\Windows\System32\drivers\etc.)

Then I noticed.

C:\Users\ComputerUser>ping localhost

Pinging COMPUTER [127.0.0.1] with 32 bytes of data:
Reply from 127.0.0.1: bytes=32 time=1ms TTL=128
Reply from 127.0.0.1: bytes=32 time=1ms TTL=128
Reply from 127.0.0.1: bytes=32 time=1ms TTL=128
Reply from 127.0.0.1: bytes=32 time=1ms TTL=128

Then I tried to startup PostgreSQL again.
The startup time went down from 5 minutes to just 7 seconds!

THATS COOL!

Thanks,
Andre Mikulec







--
View this message in context: http://postgresql.nabble.com/How-do-I-install-run-PostgreSQL-9-4-64-bit-on-Windows-7-Professional-tp5847018p5852109.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.


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




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux