Re: [pgadmin-support] Server not listening

2007-04-24 Thread Andy Shellam
Hi George, OK the fact you cannot telnet from your XP machine to the server's PostgreSQL port now suggests it's a problem getting to the server port. Checking for the existence of a firewall is an ambiguous question I'm afraid! There's not only the case of if there's a software firewall, but

Re: [pgadmin-support] Server not listening

2007-04-24 Thread George Heller
My XP machine is not in the same subnet as the server, but I have the IP address of my XP machine specified in the pg_hba.conf file. Is that not enough to let me access the database from my XP machine? I am able to do an SSH from my XP machine to the server, and also can access psql using

Re: [pgadmin-support] questions about cursors

2007-04-24 Thread Joris Dobbelsteen
See the postgresql documentation at: http://www.postgresql.org/docs/8.2/interactive/plpgsql-cursors.html >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of >Anton Andreev >Sent: dinsdag 24 april 2007 13:45 >To: pgadmin-support@postgresql.org >Subject: [

[pgadmin-support] questions about cursors

2007-04-24 Thread Anton Andreev
Hi, I am trying to use cursors and I am really frustrated already. Do I need to install an extension? 1. Problem number one is that what ever I use in front of the fetch command it is not being accepted, it gives a syntax error. If I use a number ,"all" or "forward" it gives an error again?

Re: [pgadmin-support] Server not listening

2007-04-24 Thread Raymond O'Donnell
On 24/04/2007 06:43, George Heller wrote: Ok, I tried a telnet from the command prompt of my XP machine, to the linux server address on port 5432, something like, C:\> telnet 132.141.101.1 5432 And this did 'not' go through. It said could not open connection to host, connect failed. Well, th