New Mac Trial - Can't Connect to DB

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: New Mac Trial - Can't Connect to DB

Postby squeeg » Mon Jan 25, 2010 7:35 pm

User1, if you get it to work I would like to know what you did exactly. My friend is having the same problems too w/ pt3 mac trial but I dont think he understands all this comp jargon.
squeeg
 
Posts: 2
Joined: Sun Feb 10, 2008 11:21 am

Re: New Mac Trial - Can't Connect to DB

Postby DanHartGWS » Wed Feb 03, 2010 1:54 am

Hi all, I'm currently having the same problems with my newly installed Pokertracker.

I've gotten to typing 'sudo su postgres' into a terminal, but when it prompts me for my password it will not let me type anything. I'm getting pretty frustrated. Thanks for any help in advance.
DanHartGWS
 
Posts: 1
Joined: Wed Feb 03, 2010 1:43 am

Re: New Mac Trial - Can't Connect to DB

Postby tarix » Wed Feb 03, 2010 5:12 am

DanHartGWS wrote:I've gotten to typing 'sudo su postgres' into a terminal, but when it prompts me for my password it will not let me type anything. I'm getting pretty frustrated. Thanks for any help in advance.


Just type in your password and press enter. For security reasons it will not display anything at all while you are typing.
tarix
Developer
 
Posts: 3760
Joined: Tue May 20, 2008 2:49 pm

Re: New Mac Trial - Can't Connect to DB

Postby pagp » Sat Feb 06, 2010 12:35 pm

kraada wrote:Yes, change that then stop and restart PostgreSQL (via the links in Applications/PostgreSQL 8.4) and then change it in PT3 and see if you can connect.

If you can't, please create a support ticket and link to this thread and we'll investigate further for you.


Hi, I ve already opened the postgresql.conf archive. Through all the other steps showed before on this post. How and where exactly do i change this port configuration inside the postgresql.conf archive, i am stuck here!

Thx for ur attention.
pagp
 
Posts: 3
Joined: Fri Feb 05, 2010 12:52 pm

Re: New Mac Trial - Can't Connect to DB

Postby WhiteRider » Sat Feb 06, 2010 12:58 pm

If you search for "port" you should find the config you need to change.
If not, you need to add a line like:
port = 5432 # (change requires restart)
..for the port number you want to use.
Then restart postgres.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: New Mac Trial - Can't Connect to DB

Postby pagp » Sat Feb 06, 2010 2:49 pm

WhiteRider wrote:If you search for "port" you should find the config you need to change.
If not, you need to add a line like:
port = 5432 # (change requires restart)
..for the port number you want to use.
Then restart postgres.


i did as u said but i am still getting a division by zero when i try to restart the server.

The lines were

#listen_addresses = 'localhost' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost', '*' = all
port = 5433 # (change requires restart)
#port = 5432 # (change requires restart)
max_connections = 100 # (change requires restart)
# Note: Increasing max_connections costs ~400 bytes of shared memory per


in black is the line i added.

tyvm for ur help.
pagp
 
Posts: 3
Joined: Fri Feb 05, 2010 12:52 pm

Re: New Mac Trial - Can't Connect to DB

Postby tarix » Sat Feb 06, 2010 9:21 pm

pagp wrote:i did as u said but i am still getting a division by zero when i try to restart the server.


Could you post the exact error message you are getting ?
tarix
Developer
 
Posts: 3760
Joined: Tue May 20, 2008 2:49 pm

Re: New Mac Trial - Can't Connect to DB

Postby pagp » Sat Feb 06, 2010 11:43 pm

tarix wrote:
pagp wrote:i did as u said but i am still getting a division by zero when i try to restart the server.


Could you post the exact error message you are getting ?



http://img710.imageshack.us/i/imagem1bv.png/

http://img200.imageshack.us/i/imagem3ed.png/

those are the error messages i am getting.
and the file i am editing is on the last post. tyvm
pagp
 
Posts: 3
Joined: Fri Feb 05, 2010 12:52 pm

Re: New Mac Trial - Can't Connect to DB

Postby tarix » Sun Feb 07, 2010 1:36 am

Please create a support ticket and reference this thread and tell me how experienced you are using Terminal. Also PM me the ticket number as our support is already gone for the day.
tarix
Developer
 
Posts: 3760
Joined: Tue May 20, 2008 2:49 pm

Previous

Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests