Attn: Vista Users Installing PostgreSQL 8.3

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Re: Attn: Vista Users Installing PostgreSQL 8.3

Postby Brandal » Mon Mar 16, 2009 1:15 pm

When trying to connect to psql to 'postgres' it gave me the (0x0000274D/10061)...

Now have I followed this guide: http://www.pokertracker.com/products/PT3/docs/PokerTracker3_Manual_Uninstall_Reinstall_PostgreSQL.pdf step by step, Except that I tried one second time to call my user something else than postgres.
During installation, during Activating Procedural Languages I got the error :
"Failed to connect to the database. Procedural languages files are installed, but are not activated in any databased. Could not connect to server: (0x0000274D/10061) Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432?"

And during Activating contrib modules, error:
"Failed to connect to the 'template1' database.Contrib files are installed, but are not activated in any databased.Could not connect to server: (0x0000274D/10061) Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432?"

Then PostgreSQL got "successfully" installed on my system.
Brandal
 
Posts: 11
Joined: Sat Dec 06, 2008 10:43 pm

Re: Attn: Vista Users Installing PostgreSQL 8.3

Postby kraada » Mon Mar 16, 2009 1:22 pm

Brandal,

You originally installed PostgreSQL using the "one click installer" and the database was created in the one click installer.

If you reinstall that way it should connect up to your current database, otherwise you'll need to delete it and start over (by uninstalling, deleting the C:\Program Files\PostgreSQL\ folder, then reinstalling), but then it will work as it's starting from scratch essentially.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Attn: Vista Users Installing PostgreSQL 8.3

Postby Brandal » Mon Mar 16, 2009 4:23 pm

I did completely uninstall and delete every folder with any kind of PostgreSQL in it. And tried to install several versions of postgreSQL, and everyone gave me the error during installation.

Since it wouldn't install properly it's probably a problem with my computer, I have sent a mail to PostgreSQL support and will post it here if they have a clever solution.
Brandal
 
Posts: 11
Joined: Sat Dec 06, 2008 10:43 pm

Re: Attn: Vista Users Installing PostgreSQL 8.3

Postby Brandal » Tue Mar 17, 2009 11:55 am

http://www.nabble.com/(0x0000274D-10061)-on-Install-td22546792.html
Still not working, and yes I've tried deactived my firewall.

I Belive it has something to do with the setup on my computer, what Windows Services is required to run PostgreSQL?
Brandal
 
Posts: 11
Joined: Sat Dec 06, 2008 10:43 pm

Re: Attn: Vista Users Installing PostgreSQL 8.3

Postby kraada » Tue Mar 17, 2009 12:22 pm

This is very odd.

Please create a ticket using this link and we'll schedule a remote session where one of us can log into your machine and see the problem first hand and get it resolved.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Attn: Vista Users Installing PostgreSQL 8.3

Postby Brandal » Tue Mar 17, 2009 5:22 pm

Thanks for good support kraada.

I somehow made it work myself, I uninstalled and deleted PostgreSQL, Pokertracker 3 and 2. And fixed the registry.
Then I installed the PT3 w/pgsql, then I created a db through PT3, then reinstalled to the newest version of PostgreSQL and installed ODBC, and finally installed PT2.
Now I have both a PT2 and a PT3 postgreSQL database and is as happy as can be.

edit: the reason why it worked is probably that this procedure created two users, one postgres, and one postgres."Brandal-PC"
Brandal
 
Posts: 11
Joined: Sat Dec 06, 2008 10:43 pm

Re: Attn: Vista Users Installing PostgreSQL 8.3

Postby Brandal » Tue Mar 17, 2009 7:25 pm

The pokertrackers is working just fine and that is all I really need. But the error is still present, if I for instanse try PokerEV software with PT2, it will not connect to 127.0.0.1:5432.
Brandal
 
Posts: 11
Joined: Sat Dec 06, 2008 10:43 pm

Re: Attn: Vista Users Installing PostgreSQL 8.3

Postby kraada » Wed Mar 18, 2009 9:21 am

Click Start --> Programs --> PostgreSQL --> Edit pg_hba.conf -- look at the bottom for a line that says 127.0.0.1 at the front. Does it have a pound sign in front of it? If so, remove the pound sign, save the file, and restart the PostgreSQL server and it should work for you.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Attn: Vista Users Installing PostgreSQL 8.3

Postby Brandal » Wed Mar 18, 2009 12:23 pm

There is no £ symbol in any of the configuration files.
Brandal
 
Posts: 11
Joined: Sat Dec 06, 2008 10:43 pm

Re: Attn: Vista Users Installing PostgreSQL 8.3

Postby kraada » Wed Mar 18, 2009 12:34 pm

Apologies for being unclear I meant the "#" symbol.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

PreviousNext

Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 15 guests

cron