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

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.