Re: [pgadmin-support] Server not listening

2007-04-18 Thread Raymond O'Donnell
On 18/04/2007 21:29, GeorgeHeller wrote: I have changed the postgresql.conf file to have listen_addresses='*' and port=5432, and have restarted the server. if you have psql on another computer, try using it to connect to the server and see what happens. psql -h (serveraddress) -U (username

Re: [pgadmin-support] Server not listening

2007-04-18 Thread GeorgeHeller
I have checked that the server is listening, I am able to ping it from my computer, and the ps ax|grep postgres command gives me, 20058 ?S 0:00 /usr/local/pgsql/bin/postgres 20060 ?Ss 0:00 postgres: writer process 20061 ?Ss 0:00 postgres: stats collector proce

Re: [pgadmin-support] Server not listening

2007-04-18 Thread Joris Dobbelsteen
>-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of >Raymond O'Donnell >Sent: woensdag 18 april 2007 10:41 >To: GeorgeHeller >Cc: pgadmin-support@postgresql.org >Subject: Re: [pgadmin-support] Server not listening > >On 18/04/2007 03:32, GeorgeHeller wrote

Re: [pgadmin-support] Server not listening

2007-04-18 Thread Raymond O'Donnell
On 18/04/2007 03:32, GeorgeHeller wrote: The server doesn't accept connections: the connection library reports could not connect to server: Connection refused (0x274D/10061) Is the server running on host "192.212.105.111" and accepting TCP/IP connections on port 5432? Are you sure the se

Re: [pgadmin-support] Win32 pg_dump fails for single table backup

2007-04-18 Thread Dave Page
Arnaud Lesauvage wrote: Dave Page a écrit : Are you sure you're running 1.6.3? I get (not the non default schema, and that both the schema and table names need quoting): C:\Program Files\PostgreSQL\8.2\bin\pg_dump.exe -i -h localhost -p 5432 -U postgres -F c -v -f "c:\foo.bak" -t "\"FOO\".\"R

[pgadmin-support] Server not listening

2007-04-18 Thread GeorgeHeller
Hi all, I am trying to add my postgres database server through PgAdmin III and am getting an error as below: The server doesn't accept connections: the connection library reports could not connect to server: Connection refused (0x274D/10061) Is the server running on host "192.212.105.111" a

Re: [pgadmin-support] Win32 pg_dump fails for single table backup

2007-04-18 Thread Arnaud Lesauvage
Dave Page a écrit : Are you sure you're running 1.6.3? I get (not the non default schema, and that both the schema and table names need quoting): C:\Program Files\PostgreSQL\8.2\bin\pg_dump.exe -i -h localhost -p 5432 -U postgres -F c -v -f "c:\foo.bak" -t "\"FOO\".\"Role\"" postgres That's