From: Andre_Mikulec <Andre_Mikulec@Hotmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: How do I install/run PostgreSQL 9.4 64 bit on Windows 7 Professional?
Date: Mon, 1 Jun 2015 16:27:08 -0700 (MST)
Message-ID: <1433201228069-5852109.post@n5.nabble.com> (raw)
In-Reply-To: <1431355130363-5848703.post@n5.nabble.com>
References: <1430175632167-5847018.post@n5.nabble.com>
<A737B7A37273E048B164557ADEF4A58B365EDE0B@ntex2010i.host.magwien.gv.at>
<1430451396697-5847572.post@n5.nabble.com>
<CANnQH_hmpqKN5UVQYPg7ZZdbMp3Lov_MOkP+QaThT_J++8BK6A@mail.gmail.com>
<1431355130363-5848703.post@n5.nabble.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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-tp...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Andre_Mikulec@Hotmail.com
Subject: Re: How do I install/run PostgreSQL 9.4 64 bit on Windows 7 Professional?
In-Reply-To: <1433201228069-5852109.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox