pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedClient Connection - PGAdmin
5+ messages / 4 participants
[nested] [flat]
* Client Connection - PGAdmin
@ 2006-03-30 02:23 German Raul Hoyos Parravicino <rhoyos@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: German Raul Hoyos Parravicino @ 2006-03-30 02:23 UTC (permalink / raw)
To: pgsql-admin
Hello Everydoy.. I need help....
I have installed PostgreSQL in my LinuX -SUSE "postgresql-8.1.3.tar.gz"
I start Postgre using "pg_ctl start -D/usr/local/database " After that I can
connect PostgreSQL using psql DataBase.
>psql DataBase
==>
The problem occur when I tried to connect to the DataBase using Pg-Admin III
. I have proved using "telnet IP 5432" and I get Connectio refused... I
don't know what is wrong ?? I also modified the file pg_hba.conf , I write
the IP of my PC, but nothing happend..
Is it possible that there is another process in PostgreSQL that I have to
start
Thanks for your help !!!
--
Raul Hoyos Parravicino
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Client Connection - PGAdmin
@ 2006-03-30 03:13 Jason Minion <jason.minion@sigler.com>
0 siblings, 0 replies; 5+ messages in thread
From: Jason Minion @ 2006-03-30 03:13 UTC (permalink / raw)
To: German Raul Hoyos Parravicino <rhoyos@gmail.com>; pgsql-admin
You'll want to make sure that after you modified the pg_hba.conf you
reloaded PostgreSQL (either through pg_ctl reload, SIGHUP or by
restarting the service entirely), plus there is a setting in the
postgresql.conf file named 'listen_addresses' that must be uncommented
and set appropriately for tcp/ip access to work.
Read the header on the postgresql.conf file, it will explain a little
bit about what to do when changing contents of that file, and note that
modifying the 'listen_addresses' configuration option will require a
full restart of the service. You'll also want to make sure to read and
understand the relevant sections in the manual:
http://www.postgresql.org/docs/8.1/interactive/client-authentication.htm
l
Good luck!
Jason Minion
________________________________
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of German Raul Hoyos
Parravicino
Sent: Wednesday, March 29, 2006 8:24 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Client Connection - PGAdmin
Hello Everydoy.. I need help....
I have installed PostgreSQL in my LinuX -SUSE "postgresql-8.1.3.tar.gz"
I start Postgre using "pg_ctl start -D/usr/local/database " After that I
can connect PostgreSQL using psql DataBase.
>psql DataBase
==>
The problem occur when I tried to connect to the DataBase using Pg-Admin
III . I have proved using "telnet IP 5432" and I get Connectio
refused... I don't know what is wrong ?? I also modified the file
pg_hba.conf , I write the IP of my PC, but nothing happend..
Is it possible that there is another process in PostgreSQL that I have
to start
Thanks for your help !!!
--
Raul Hoyos Parravicino
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Client Connection - PGAdmin
@ 2006-03-30 03:19 Tom Arthurs <tarthurs@jobflash.com>
parent: German Raul Hoyos Parravicino <rhoyos@gmail.com>
0 siblings, 2 replies; 5+ messages in thread
From: Tom Arthurs @ 2006-03-30 03:19 UTC (permalink / raw)
To: German Raul Hoyos Parravicino <rhoyos@gmail.com>; +Cc: pgsql-admin
Did you change this in your postgresql.conf:
listen_addresses = '*'
it defaults only to localhost
German Raul Hoyos Parravicino wrote:
> Hello Everydoy.. I need help....
>
> I have installed PostgreSQL in my LinuX -SUSE "postgresql-8.1.3.tar.gz"
>
> I start Postgre using "pg_ctl start -D/usr/local/database " After that
> I can connect PostgreSQL using psql DataBase.
>
> >psql DataBase
>
> ==>
>
> The problem occur when I tried to connect to the DataBase using
> Pg-Admin III . I have proved using "telnet IP 5432" and I get
> Connectio refused... I don't know what is wrong ?? I also modified the
> file pg_hba.conf , I write the IP of my PC, but nothing happend..
>
> Is it possible that there is another process in PostgreSQL that I have
> to start
>
> Thanks for your help !!!
>
> --
> Raul Hoyos Parravicino
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Client Connection - PGAdmin
@ 2006-03-30 03:29 Tom Lane <tgl@sss.pgh.pa.us>
parent: Tom Arthurs <tarthurs@jobflash.com>
1 sibling, 0 replies; 5+ messages in thread
From: Tom Lane @ 2006-03-30 03:29 UTC (permalink / raw)
To: Tom Arthurs <tarthurs@jobflash.com>; +Cc: German Raul Hoyos Parravicino <rhoyos@gmail.com>; pgsql-admin
Tom Arthurs <tarthurs@jobflash.com> writes:
> Did you change this in your postgresql.conf:
> listen_addresses = '*'
> it defaults only to localhost
Also, you might need to change kernel packet filtering rules to allow
traffic to port 5432 to get through the firewall. "Connection refused"
indicates either that the postmaster is not listening on port 5432
(see above) or the kernel is bouncing the packet before it gets there.
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Client Connection - PGAdmin
@ 2006-03-30 03:50 German Raul Hoyos Parravicino <rhoyos@gmail.com>
parent: Tom Arthurs <tarthurs@jobflash.com>
1 sibling, 0 replies; 5+ messages in thread
From: German Raul Hoyos Parravicino @ 2006-03-30 03:50 UTC (permalink / raw)
To: Tom Arthurs <tarthurs@jobflash.com>; +Cc: pgsql-admin
Thanks you very much Tom...That was the key...
On 3/29/06, Tom Arthurs <tarthurs@jobflash.com> wrote:
>
> Did you change this in your postgresql.conf:
>
> listen_addresses = '*'
>
> it defaults only to localhost
>
> German Raul Hoyos Parravicino wrote:
> > Hello Everydoy.. I need help....
> >
> > I have installed PostgreSQL in my LinuX -SUSE "postgresql-8.1.3.tar.gz"
> >
> > I start Postgre using "pg_ctl start -D/usr/local/database " After that
> > I can connect PostgreSQL using psql DataBase.
> >
> > >psql DataBase
> >
> > ==>
> >
> > The problem occur when I tried to connect to the DataBase using
> > Pg-Admin III . I have proved using "telnet IP 5432" and I get
> > Connectio refused... I don't know what is wrong ?? I also modified the
> > file pg_hba.conf , I write the IP of my PC, but nothing happend..
> >
> > Is it possible that there is another process in PostgreSQL that I have
> > to start
> >
> > Thanks for your help !!!
> >
> > --
> > Raul Hoyos Parravicino
> >
>
--
Saludos,
Raul Hoyos Parravicino
Telf. 97936626
E-mail alternativo: rhoyosp@yahoo.es
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2006-03-30 03:50 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-03-30 02:23 Client Connection - PGAdmin German Raul Hoyos Parravicino <rhoyos@gmail.com>
2006-03-30 03:19 ` Tom Arthurs <tarthurs@jobflash.com>
2006-03-30 03:29 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-03-30 03:50 ` German Raul Hoyos Parravicino <rhoyos@gmail.com>
2006-03-30 03:13 Re: Client Connection - PGAdmin Jason Minion <jason.minion@sigler.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox