Connection refused (0x0000274D/10061) always after restart

[CHINA888]

could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" and accepting TCP/IP connections on port 5432? could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" and accepting TCP/IP connections on port 5432?

This is the message I get every time I restart the computer after installing and importing some hands on PT3...

I've actually tried it all, and its quite frustrating seeing that you have imported 20 million hands for days and days, then housekeeping and finally ends with that message after restarting the computer...

1. There is not any PID file.
2. Firewall is OFF. Router port 5432 is open. Using other port also doesnt work.
2. Reinstalling PostgreSQL (using old database) doesnt solve the problem.
3. Reinstalling PostgreSQL and creating new database works... ultil I restart my computer, then I get the same message again.
4. I have also tried with different versions of PostgreSQL (8.3; 8,4; 9,0)

My computer specs are the following:
- Windows 7 64bits
- SSD 512gb
- 16gb DDR3 ram 2400 mhz
- i7 4770k 3,5ghz 8 cores

I've been searching for all over the forums in last two days and can't solve the problem, please help.

[kraada]

Click Start type services.msc and click on it when it appears. You should find PostgreSQL in the list. Right click on it and click Properties. I suspect you just need to change it from Manual to Automatic and click OK and that will fix things.

[CHINA888]

Click Start type services.msc and click on it when it appears. You should find PostgreSQL in the list. Right click on it and click Properties. I suspect you just need to change it from Manual to Automatic and click OK and that will fix things.

I've tried that too and it doesnt work either.

However I have found the problem, its because of the postgresql.conf

I have modified that file following the advanced method of this tutorial: https://www.pokertracker.com/forums/vie ... 45&t=10393

These are the modifications i have made in the file as explained here:
"shared_buffers = xMB" and set this number equal to about 1/4 of your total memory. That is, if you have 2GB of RAM, set this to 512MB.
"work_mem = xMB" and set this value equal to about 1/64 of your total memory. That is, if you have 2GB of RAM, set this to 32MB.
"maintenance_work_mem = xMB" and set this value equal to about 1/16 of your total memory. That is, if you have 2GB of RAM, set this to 128MB.

After reloading the configuration and restarting the PC, then that error happens.

However if I use again the original postgresql.conf file, then reloading the configuration and restarting the PC... it works again.


Right now I'm testing one by one small increases of value in each of those parameters, Maintenance_work_mem doesnt seem to work at 1024mb, but it does work at 512mb for me

[kraada]

Are you running 64 bit PostgreSQL? If not that could explain why using such high numbers was causing you trouble - only PostgreSQL 9.0-x64 can handle really using the kind of RAM you've got in a system when you're up to 16G installed RAM.

[CHINA888]

Are you running 64 bit PostgreSQL? If not that could explain why using such high numbers was causing you trouble - only PostgreSQL 9.0-x64 can handle really using the kind of RAM you've got in a system when you're up to 16G installed RAM.

Yes, I'm using postgresql 9.0 64bits version, it still bugs for maintenance_work_mem over 1536mb.

However I'm importing some hands now and the RAM used when I check task manager is now 6gb, before was using barelly 2gb (with default settings). Also the CPU has an increase in use at 20% now.

I also have recorded the time needed for housekeeping process, after finishing import, I will see how long it takes this time.

The most important thing will be the speed running personalized reports.


A strange thing is that my laptop spec (4gb DDR3 RAM 1600mhz, i5 dual core 2.53ghz, 128gb SSD) is far weaker than my main computer and it supports maintenance_work_mem for 2048mb...

Anyway now it reminds me that I'm using port 65432 on main computer while in laptop I'm using default port 5432, I have no idea if the port used could have any effect in perfomance or not

I just think its quite weird how PT3 works lol

[kraada]

Port used won't affect performance. You might want to contact the PostgreSQL people about that RAM used issue - unfortunately I don't know why the setting would work in one place but not another but they might be able to help you there.