Обсуждение: How do I install/run PostgreSQL 9.4 64 bit on Windows 7 Professional?

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-tp5847018.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

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

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-tp5847018p5847572.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

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?

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

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-tp5847018p5848703.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

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.