Postgresql

[slurpyx]

Hi! Guys i just installed postgresql7 on freebsd 4.9 thru ports.....

im a newbie so pls bare..

here's what i did.

1)initdb -D /usr/local/pgsql/data
2)postmaster -D /usr/local/pgsql/data -i

but when i used a gui client on a diffrent computer (pgadmin III) it gives me the error

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

did i miss something?

 

[ikester]

Hey,

I am only guessing, but I do believe that you are not getting a socket on the port. Are you using a firewall?
Are you sure the process is running? 'ps aux' it into grep.
I have done this install and changed the listening port for security reasons (web server). The error on the client makes me believe that you are either not getting a connection because the port is blocked or the process is not running or pSQL is not listening to requests. Good luck!

Ikester

 

[Wishdiak]

slurpyx,

Another shot in the dark here. Try logging into your server using telnet or ssh and see if you can connect that way. Do you get the same error message?

It sounds like it could be an auth issue.



Wishdiak

http://www.wishdiak.com

 

[slurpyx]

i can connect thru ssh.

 

[Wishdiak]

slurrpyx,

Assuming that you mean "i can connect to postgresql thru ssh" it seems that the server is running and it's not an auth issue. ikester is probably right.

I'm not that familiar with postgresql specifically, but it sounds like a firewall issue. Is this the text of the error message, or is the part in red your question?

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

Do you have a firewall set up on your FreeBSD box? Do you have a router? Do you have postgresql set up on a different port?



Wishdiak

http://www.wishdiak.com

 

[slurpyx]

guys.. i think i found my problem...

i think its good that i check out all the possible problems.. i end up learning.. in a way.

the problem was simple pgsql is run thru rc.d without the -i option.

i just turn it off.

am just gonna edit .profile and add the -i option

forgive me guys... just a newbie

tnx a lot guys..

 

[Wishdiak]

slurpyx,

Glad to hear you fixed it.



Wishdiak

http://www.wishdiak.com