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

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

From
Andre_Mikulec
Date:

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.


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

From
Albe Laurenz
Date:
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

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

From
Andre_Mikulec
Date:
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.


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

From
"David G. Johnston"
Date:
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.
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

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

From
Harshad Adalkonda
Date:

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-tp5847018p5847572.html
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


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

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

From
Andre_Mikulec
Date:
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.


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

From
Andre_Mikulec
Date:
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.