Ok, I have reached to the point where the SSH tunelling works, and I am able to connect using it to PgAdmin. But I still want to know what exactly is wrong with the other setup.
I just came across this in the postgres documentation, about starting the postmaster with an -i option, if you want your server to accept TCP/IP connections.
I just used the -D option as specified, to start the server. Is it necessary to use the -i option so that my server can listen, or is the documentation just too old? If yes, what is the syntax for the same?
Joris Dobbelsteen <Joris(at)familiedobbelsteen(dot)nl> wrote:
>From: Andy Shellam [mailto:andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk]
>Sent: woensdag 25 april 2007 21:25
>To: Joris Dobbelsteen
>Cc: George Heller; pgadmin-support(at)postgresql(dot)org
>Subject: Re: [pgadmin-support] Server not listening
>I concur, but just so you know I suggested SSH so George can
>get up and running quickly while diagnosing the problems later
>as it requires a lot of information he doesn't seem to have.
>We've already established he has SSH access so it seemed an
>obvious way to connect so he could actually begin to use PostgreSQL.
Hopefully you took no offence while I took this a sharp turn.
I agree that this would be probably a good idea to get it working.
Alternatively it might seem easier to have a temporary set up on the
local computer, if feasable.
- Joris Dobbelsteen
Ahhh...imagining that irresistible "new car" smell?
Check outnew cars at Yahoo! Autos.
In response to
pgadmin-support by date
|Next:||From: Atif CEYLAN||Date: 2007-05-01 06:41:58|
|Subject: default view limit|
|Previous:||From: Liviu Rau||Date: 2007-04-27 09:37:28|
|Subject: Pgadmin does not execute backup on table on tablespace|