pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Client 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