Re: [pgadmin-support] Server not listening

2007-05-01 Thread Joris Dobbelsteen
George, In my opinion this table looks a little odd. The server seems to be accepting everything. If not, I'm missing something here. If the first rule(s) of RH-Firewall-1-INPUT don't hit, at least the line denoting postgres should. Otherwise its the default policy. This doesn't seem to be a prob

[pgadmin-support] Deleting rows in "View Data"

2007-05-01 Thread CG
When I select rows in the View Data --> View All Rows, and delete them, first a message pops up confirming the deletion of N rows, and then after I confirm, pgadmin proceeds to delete N+1 rows... The first time it happened, I thought I had accidentally selected more than I had intended to sele

Re: [pgadmin-support] Deleting rows in "View Data"

2007-05-01 Thread Dave Page
CG wrote: When I select rows in the View Data --> View All Rows, and delete them, first a message pops up confirming the deletion of N rows, and then after I confirm, pgadmin proceeds to delete N+1 rows... The first time it happened, I thought I had accidentally selected more than I had inten

Re: [pgadmin-support] Doubt

2007-05-01 Thread 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

[pgadmin-support] Doubt

2007-05-01 Thread kaveri
what is mean by service name and account name, how to create it..

Re: [pgadmin-support] Server not listening

2007-05-01 Thread 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

Re: [pgadmin-support] Server not listening

2007-05-01 Thread Raymond O'Donnell
On 01/05/2007 00:43, George Heller wrote: 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 Hi George, As i understand it the -i option works, but the preferred way is to set the appropriate options in postgr

Re: [pgadmin-support] Server not listening

2007-05-01 Thread Joris Dobbelsteen
From: George Heller [mailto:[EMAIL PROTECTED] Sent: dinsdag 1 mei 2007 1:43 To: Joris Dobbelsteen; [EMAIL PROTECTED] Cc: pgadmin-support@postgresql.org Subject: RE: [pgadmin-support] Server not listening

[pgadmin-support] default view limit

2007-05-01 Thread Atif CEYLAN
hi, you can default data view limit 100 :) because, not complate open full data thanks... ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [pgadmin-support] Server not listening

2007-05-01 Thread George Heller
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