Postgre problem

[sthief09]

I am really sorry to be bothering with a problem unrelated to your hard work on PT4 but I am at a loss for what to do. I've tried my hardest to find a solution on google and on these forums.

I recently upgraded to the newest alpha. I tried to create a new database. I got an error message that it was not connecting to the specific ##### db folder (which it didn't even create). I tried it on HEM1 and it took an oddly long time but eventually worked fwiw. I googled, searched on here, etc. and determined I probably should try uninstalling/reinstalling. everything else was working okay with existing db's prior to uninstalling.

so today I uninstalled (including deleting the service in cmd prompt)/reinstalled. now I can't even connect. been googling for over an hour and cannot figure this out. I do not have postmaster.pid (and am showing hidden files). I saw deleting that could have been a fix. I've refreshed, start, checked all allow boxes for postgres, tried connect a bunch of times, rebooted over and over, and nothing. I figure someone must have had this problem before so I keep googling but am finding nothing.

this is my error:
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?

I use postgreSQL 9.0 and have Windows 7. had no problems to this point.

[kraada]

That error specifically implies the server is not currently running. Click Start, type services and click on it when it appears. Find PostgreSQL in the list - is it started? If not, can you start it successfully?

[sthief09]

wow you're very good you! so simple.

not a pressing matter (was just going to make a new, smaller db rather than updating again) but I get the same message I got before reinstalling postgre. when I try to create a new DB:

Unable to create PostgreSQL database: PT4_2012ALL
Reason: Unable to login to database (PT4_2012ALL). Reason: FATAL: database "PT4_2012ALL" does not exist DETAIL: The database subdirectory "base/39701" is missing.

no such folder 39701 was created. and as I said, I still have original HEM on my comp and that has no issues creating a folder. seems like this is on PT4's end.

[sthief09]

wow you're very good you! so simple.

not a pressing matter (was just going to make a new, smaller db rather than updating again) but I get the same message I got before reinstalling postgre. when I try to create a new DB:

Unable to create PostgreSQL database: PT4_2012ALL
Reason: Unable to login to database (PT4_2012ALL). Reason: FATAL: database "PT4_2012ALL" does not exist DETAIL: The database subdirectory "base/39701" is missing.

no such folder 39701 was created. and as I said, I still have original HEM on my comp and that has no issues creating a folder. seems like this is on PT4's end.

sorry to bump but I just rolled back to previous beta and got the same error. figured I'd preemptively post this in case this would be one of your suggestions.

[kraada]

Thats the error you get when trying to create a new database? It would make more sense as an error when trying to connect to an existing database that you had previously deleted one or more files from. When one of the base subfolders is missing that means that raw database data has been removed from the PostgreSQL data folder. There is no way to recover from this kind of data loss unless you can locate and restore the file (if for example it was quarantined by your anti-virus or some such you could restore it).

[sthief09]

Thats the error you get when trying to create a new database? It would make more sense as an error when trying to connect to an existing database that you had previously deleted one or more files from. When one of the base subfolders is missing that means that raw database data has been removed from the PostgreSQL data folder. There is no way to recover from this kind of data loss unless you can locate and restore the file (if for example it was quarantined by your anti-virus or some such you could restore it).

yeah I'm attempting to create a brand new database. I've tried maybe 10 times over the past several days after various reboots, and uninstalled/reinstalled postgre. different folders each time, but otherwise same error message.

[kraada]

Please create a support ticket using our support system requesting remote assistance and link this thread and we'll set up a time to take care of this personally for you.