pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHow do I install/run PostgreSQL 9.4 64 bit on Windows 7 Professional?
8+ messages / 4 participants
[nested] [flat]
* How do I install/run PostgreSQL 9.4 64 bit on Windows 7 Professional?
@ 2015-04-27 23:00 Andre_Mikulec <Andre_Mikulec@Hotmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: Andre_Mikulec @ 2015-04-27 23:00 UTC (permalink / raw)
To: pgsql-admin
I read the FAQ.
Something else may be not known?
I have been banging my head against the wall for days.
I can not get Postgre to start.
This case is the same whether or not Postgre runs as a service or as a
stand-alone.
I am running Windows 7 Professional Edition ( that means NTFS permissions )
HERE IS MY CASE.
I HAVE
Portable - PostgreSQLPortable-9.4.1.paf
SITUATION
OFF - FIREWALL
OFF - ANTIVIRUS
OFF - MICROSOFT SECURE ESSENTIALs
INSTALL
PostgreSQLPortable-9.4.1.paf
ON HERE C:\Users\AnonymousUser\Downloads\PostgreSQLPortable-9.4
PUT PERMISSIONS
WINDOWS 'USERS' GROUP
FULL PERMISSIONS ON HERE
C:\Users\AnonymousUser\Downloads\PostgreSQLPortable-9.4
RUN
"C:\Users\AnonymousUser\Downloads\PostgreSQLPortable-9.4\App\PgSQL\bin\initdb"
-U postgres -A trust -E utf8 --locale=C 1>nul
THIS WORKS
CREATES data DIR
C:\Users\AnonymousUser\Downloads\PostgreSQLPortable-9.4\Data\data
WINDOWS 'USERS' GROUP has FULL PERIMISSIONS on this FOLDER ( I CHECKED AND
VERIFIED )
RUN
C:\Users\AnonymousUser\Downloads\PostgreSQLPortable-9.4\App\PgSQL>"C:\Users\AnonymousUser\Downloads\PostgreSQLPortable-9.4\App\PgSQL\bin\pg_ctl"
-D "C:\Users\AnonymousUser\Downloads\PostgreSQLPortable-9.4\Data\data" -l
"C:\Users\AnonymousUser\Downloads\PostgreSQLPortable-9.4\Data\log.txt" -w
start
DOTS SLOWLY INCREASE, BUT RESPONSE HANGS FOREVER
waiting for server to start.........................................
LOG (log) C:\Users\AnonymousUser\Downloads\PostgreSQLPortable-9.4\Data
SHOWS
LOG: database system was shut down at 2015-04-27 17:14:40 CDT
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
LOG: could not receive data from client: No connection could be made
because the target machine actively refused it.
LOG: incomplete startup packet
LOG: could not receive data from client: No connection could be made
because the target machine actively refused it.
LOG: incomplete startup packet
LOG: could not receive data from client: No connection could be made
because the target machine actively refused it.
LOG: incomplete startup packet
LOG: could not receive data from client: No connection could be made
because the target machine actively refused it.
LOG: incomplete startup packet
Any Ideas?
--
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: How do I install/run PostgreSQL 9.4 64 bit on Windows 7 Professional?
@ 2015-04-28 08:28 Albe Laurenz <laurenz.albe@wien.gv.at>
parent: Andre_Mikulec <Andre_Mikulec@Hotmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: Albe Laurenz @ 2015-04-28 08:28 UTC (permalink / raw)
To: 'Andre_Mikulec *EXTERN*' <Andre_Mikulec@Hotmail.com>; pgsql-admin
Andre_Mikulec wrote:
> I have been banging my head against the wall for days.
> I can not get Postgre to start.
> This case is the same whether or not Postgre runs as a service or as a
> stand-alone.
> INSTALL
> PostgreSQLPortable-9.4.1.paf
> ON HERE C:\Users\AnonymousUser\Downloads\PostgreSQLPortable-9.4
Disclaimer: I don't know "PostgreSQL Portable" - is that regular PostgreSQL?
[...]
> LOG (log) C:\Users\AnonymousUser\Downloads\PostgreSQLPortable-9.4\Data
> SHOWS
>
> LOG: database system was shut down at 2015-04-27 17:14:40 CDT
> LOG: database system is ready to accept connections
> LOG: autovacuum launcher started
> LOG: could not receive data from client: No connection could be made
> because the target machine actively refused it.
>
>
> LOG: incomplete startup packet
> LOG: could not receive data from client: No connection could be made
> because the target machine actively refused it.
[...]
It looks like your server has started and feels ok, but that there are
connectivity problems with some client.
Can you connect to the server with psql or pgAdmin III (both from the same
and from a remote machine)?
What is the value of "listen_addresses" in postgresql.conf?
The log messages look like there are network problems.
Perhaps there's a firewall somewhere that you forgot to deactivate?
Can you establish TCP connections to the database server and port
with something like "telnet" (I don't know if that exists on Windows)?
Yours,
Laurenz Albe
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: How do I install/run PostgreSQL 9.4 64 bit on Windows 7 Professional?
@ 2015-05-01 03:36 Andre_Mikulec <Andre_Mikulec@Hotmail.com>
parent: Albe Laurenz <laurenz.albe@wien.gv.at>
0 siblings, 3 replies; 8+ messages in thread
From: Andre_Mikulec @ 2015-05-01 03:36 UTC (permalink / raw)
To: pgsql-admin
No, the server never starts.
As, I said; firewall disabled, secure essentials disabled, antivirus
disabled
I also made the following changes and retried
postgresql.conf
listen_addresses = '*'
pg_hba.conf
host all all 0.0.0.0/0 trust
Same response being produced by pg_ctl
LOG: incomplete startup packet
LOG: could not receive data from client: No connection could be made
because the target machine actively refused it.
This seems to be a DEEP problem.
Does any one in the WORLD run PostgreSQL on Windows 7 Professional 64 bit?
--
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* How do I install/run PostgreSQL 9.4 64 bit on Windows 7 Professional?
@ 2015-05-01 05:07 David G. Johnston <david.g.johnston@gmail.com>
parent: Andre_Mikulec <Andre_Mikulec@Hotmail.com>
2 siblings, 0 replies; 8+ messages in thread
From: David G. Johnston @ 2015-05-01 05:07 UTC (permalink / raw)
To: Andre_Mikulec <Andre_Mikulec@hotmail.com>; +Cc: pgsql-admin
On Thursday, April 30, 2015, Andre_Mikulec <Andre_Mikulec@hotmail.com>
wrote:
> No, the server never starts.
>
> As, I said; firewall disabled, secure essentials disabled, antivirus
> disabled
>
> I also made the following changes and retried
>
> postgresql.conf
> listen_addresses = '*'
>
> pg_hba.conf
> host all all 0.0.0.0/0 trust
>
> Same response being produced by pg_ctl
>
> LOG: incomplete startup packet
> LOG: could not receive data from client: No connection could be made
> because the target machine actively refused it.
>
> This seems to be a DEEP problem.
> Does any one in the WORLD run PostgreSQL on Windows 7 Professional 64 bit?
>
>
You do understand there is more than one way to install PostgreSQL? The
core project doesn't directly support anything but source code installs.
You should be asking whomever you got your installer from for help. Or,
lacking that, consider a different distribution. Because I am sure that
not everyone in the world is subscribed to this list. And troubleshooting
Windows over email is not the easiest or most desirable thing to do - even
if there is someone on this list who recognizes what this "Portable
PostgreSQL" thing is.
David J.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Re: How do I install/run PostgreSQL 9.4 64 bit on Windows 7 Professional?
@ 2015-05-02 10:41 Albe Laurenz <laurenz.albe@wien.gv.at>
parent: Andre_Mikulec <Andre_Mikulec@Hotmail.com>
2 siblings, 0 replies; 8+ messages in thread
From: Albe Laurenz @ 2015-05-02 10:41 UTC (permalink / raw)
To: Andre_Mikulec *EXTERN* <Andre_Mikulec@Hotmail.com>; pgsql-admin
Andre_Mikulec wrote:
> No, the server never starts.
Can you prove that?
> Same response being produced by pg_ctl
>
> LOG: incomplete startup packet
> LOG: could not receive data from client: No connection could be made because the target machine actively refused it.
So if the server never starts, who wrote these log entries?
> This seems to be a DEEP problem.
Possibly, but it is hard to tell from here.
Try to figure out if the server process has really died and what message it wrote
to the log when it did.
Try to figure out if you can establish a TCP connection to the server port.
Yours,
Laurenz Albe
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Re: How do I install/run PostgreSQL 9.4 64 bit on Windows 7 Professional?
@ 2015-05-05 05:46 Harshad Adalkonda <adalkondaharshad@gmail.com>
parent: Andre_Mikulec <Andre_Mikulec@Hotmail.com>
2 siblings, 1 reply; 8+ messages in thread
From: Harshad Adalkonda @ 2015-05-05 05:46 UTC (permalink / raw)
To: Andre_Mikulec <Andre_Mikulec@hotmail.com>; +Cc: pgsql-admin
On Fri, May 1, 2015 at 9:06 AM, Andre_Mikulec <Andre_Mikulec@hotmail.com>
wrote:
> No, the server never starts.
>
> As, I said; firewall disabled, secure essentials disabled, antivirus
> disabled
>
> I also made the following changes and retried
>
> postgresql.conf
> listen_addresses = '*'
>
> pg_hba.conf
> host all all 0.0.0.0/0 trust
>
> Same response being produced by pg_ctl
>
> LOG: incomplete startup packet
> LOG: could not receive data from client: No connection could be made
> because the target machine actively refused it.
>
> This seems to be a DEEP problem.
> Does any one in the WORLD run PostgreSQL on Windows 7 Professional 64 bit?
>
>
>
>
> --
> 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
>
Hi Andre_Mikulec,
I have checked the PostgreSQLPortable-9.4.1.paf.exe which is also working
fine with me on my *windows 7 x64bit*
If you still have the problem *download* the following *postgresql 9.4.1
x64bit binaries* and extract them at some location
http://www.enterprisedb.com/products-services-training/pgbindownload
now create new cluster/data directory with it.
Ex:
inintdb -D d:\PostgreSQL\9.4\data -U postgres
Start the newly created cluster
pg_ctl start -D d:\PostgreSQL\9.4\data -l d:\PostgreSQL\9.4\data\log.txt
if any problem try to check logs available in log.txt file located in data
directory or reply here with the logs.
Hope this will resolve your problem.
--
Thanks & Regards,
Harshad Adalkonda
Database Administrator
www.shreeyansh.com
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: How do I install/run PostgreSQL 9.4 64 bit on Windows 7 Professional?
@ 2015-05-11 14:38 Andre_Mikulec <Andre_Mikulec@Hotmail.com>
parent: Harshad Adalkonda <adalkondaharshad@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: Andre_Mikulec @ 2015-05-11 14:38 UTC (permalink / raw)
To: pgsql-admin
O.K. Thank you.
Your advice is excellent.
As you requested I checked.
What I did is modified the PostgreSQL Portable startup .bat file to include
"start cmd /k"
While PostgreSQL was "starting ...." and after about 30 seconds, I used
"pgsql" to connect
to the database. I verified by querying upon the data dictionary. I also,
created a table, then
re-queried the data dictionary and re-found the table.
What is deceptive about the process is that "starting ...." is still going
on for another 4 minutes and 30 seconds before it finally finished and I
got t back a "pgsql prompt." During that 5 minutes, I spent
4 minutes and 30 seconds querying the data dictionary.
I am satisfied. Although, I see "starting...." of 5 minutes strange.
But, I am satisfied for now.
Thank you.
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: How do I install/run PostgreSQL 9.4 64 bit on Windows 7 Professional?
@ 2015-06-01 23:27 Andre_Mikulec <Andre_Mikulec@Hotmail.com>
parent: Andre_Mikulec <Andre_Mikulec@Hotmail.com>
0 siblings, 0 replies; 8+ messages in thread
From: Andre_Mikulec @ 2015-06-01 23:27 UTC (permalink / raw)
To: pgsql-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
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2015-06-01 23:27 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-04-27 23:00 How do I install/run PostgreSQL 9.4 64 bit on Windows 7 Professional? Andre_Mikulec <Andre_Mikulec@Hotmail.com>
2015-04-28 08:28 ` Albe Laurenz <laurenz.albe@wien.gv.at>
2015-05-01 03:36 ` Andre_Mikulec <Andre_Mikulec@Hotmail.com>
2015-05-01 05:07 ` David G. Johnston <david.g.johnston@gmail.com>
2015-05-02 10:41 ` Albe Laurenz <laurenz.albe@wien.gv.at>
2015-05-05 05:46 ` Harshad Adalkonda <adalkondaharshad@gmail.com>
2015-05-11 14:38 ` Andre_Mikulec <Andre_Mikulec@Hotmail.com>
2015-06-01 23:27 ` Andre_Mikulec <Andre_Mikulec@Hotmail.com>
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