Re: [pgadmin-support] Server not listening

[andy . shellam-lists]

Hi George,

As Joris said, we need you to try what he has suggested.
The fact you can now connect via SSH proves PostgreSQL is set up and
configured correctly, which would point to a firewall or intermediate router
blocking your connections.

On the server (as root), do "iptables -L" or "/usr/local/sbin/iptables -L" if
the previous doesn't work, and post the full output so we can see if a
software firewall is blocking.

And please try and get some information about your network - who set the
server up, is there a hardware firewall or router firewall in between you and
the server, etc.

Thanks

Andy.

George Heller <[EMAIL PROTECTED]> wrote:

> Hi,
>
>   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. 
>   http://www.postgresql.org/docs/7.4/static/postmaster-start.html
>
>   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?
>
>   Thanks.
>   George.
> 
> Joris Dobbelsteen <[EMAIL PROTECTED]> wrote:
>   >-Original Message-
> >From: Andy Shellam [mailto:[EMAIL PROTECTED] 
> >Sent: woensdag 25 april 2007 21:25
> >To: Joris Dobbelsteen
> >Cc: George Heller; pgadmin-support@postgresql.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.
> 
> [snip]
> 
> - Joris Dobbelsteen
> 
> 
> 
>
> -
> Ahhh...imagining that irresistible "new car" smell?
>  Check outnew cars at Yahoo! Autos.
> 
> !DSPAM:37,4636eb7689291063614559!
> 

_
DISCLAIMER

This e-mail was sent through a Mail Network server.
The Mail Network accepts no liability for it's content.




---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match

Re: [pgadmin-support] Doubt

[andy . shellam-lists]

I presume you mean when you're creating a new connection?

If PostgreSQL is running on a Windows machine, this is the name of the service
it's running under.  Should be left blank for Unix machines.

Account name?  Do you mean username?  This is a user that's been added to the
PostgreSQL server (or the default, postgres.)



<[EMAIL PROTECTED]> wrote:

> what is mean by service name and account name, how to create it..
> 
> !DSPAM:37,4637358f89292922115346!
> 

_
DISCLAIMER

This e-mail was sent through a Mail Network server.
The Mail Network accepts no liability for it's content.




---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq

Re: [pgadmin-support] Restore dialog

[andy . shellam-lists]

Ah OK thanks for clearing that up.

Whenever I do a restore, it always warns that the plpgsql language is already
present, hence returns with code 1.

Thanks

Andy.

Dave Page <[EMAIL PROTECTED]> wrote:

> Andy Shellam wrote:
> > Hi Dave,
> > 
> > A quick suggestion for PgAdmin's "Restore database" dialog.
> > 
> > When you restore a database, you select your file and options, then
> > click "OK" and the restore does it's thing and finishes, showing you the
> > output from pg_restore. However the button stays as "OK".  So you
> > instinctively click it again to close the dialog, and it tries to do the
> > restore again - you have to click Cancel or close the window instead.
> > 
> > Can this be changed so it's like the backup, where you click OK to start
> > the backup, but once it's finished, the OK button changes to "Done" and
> > closes the window when you click it.
> 
> Hi Andy,
> 
> They actually do work the same - if the external process returns a
> non-zero value, it's assumed that you may want to try again with
> different options (or having tweaked the database) so the button doesn't
> change.
> 
> If zero is returned, the button changes to 'Done' because the task
> completed successfully.
> 
> Regards, Dave
> 
> !DSPAM:37,46486edb343942003256220!
> 
> 
> 

_
DISCLAIMER

This e-mail was sent through a Mail Network server.
The Mail Network accepts no liability for it's content.




---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match