pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Problem with PostgreSQL 8.2 on Linux Redhat
4+ messages / 4 participants
[nested] [flat]

* Problem with PostgreSQL 8.2 on Linux Redhat
@ 2007-06-20 07:09 Ira Berdichevsky <Ira.Berdichevsky@protegrity.com>
  2007-06-20 12:27 ` Re: Problem with PostgreSQL 8.2 on Linux Redhat Ray Stell <stellr@cns.vt.edu>
  2007-06-20 13:04 ` Re: Problem with PostgreSQL 8.2 on Linux Redhat Sibte Abbas <sibtay@gmail.com>
  2007-06-20 15:40 ` Re: Problem with PostgreSQL 8.2 on Linux Redhat Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 3 replies; 4+ messages in thread

From: Ira Berdichevsky @ 2007-06-20 07:09 UTC (permalink / raw)
  To: pgsql-admin

Hi,
I have some problem to configure PostgreSQL .
My OS is RedHat Enterprise 4 Linux9 32 bits) , I installed PostgreSQL
version 8.2.4.
I configured database : initdb -D /var/lib/pgsql/data -U postgres .
I changed pg_hba.conf and postgresql.config files :
pg_hba.conf:
local    all    all                            trust
host    all    all   127.0.0.1/32        md5 
host    all    all    0.0.0./0              md5
host    all    all    10.0.0.40/128     md5
 
postgresql.config:
listen_addresses = '*'
port = 5433
 
I started POstgreSQL and checked that it is run.
I checked with "psql -h 10.0.0.40 -p 5433" command and saw that
PostgreSQL respond it.
The problem is I still couldn't connect to PostgreSQL from Windows
pgAdmin agent.
I have this error connection: "Server doesn't listen".
I don't have problem with firewall.
Do you have any idea what is the problem?
Thanks.
Ira
 

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Problem with PostgreSQL 8.2 on Linux Redhat
  2007-06-20 07:09 Problem with PostgreSQL 8.2 on Linux Redhat Ira Berdichevsky <Ira.Berdichevsky@protegrity.com>
@ 2007-06-20 12:27 ` Ray Stell <stellr@cns.vt.edu>
  2 siblings, 0 replies; 4+ messages in thread

From: Ray Stell @ 2007-06-20 12:27 UTC (permalink / raw)
  To: Ira Berdichevsky <Ira.Berdichevsky@protegrity.com>; +Cc: pgsql-admin

firewall?

On Wed, Jun 20, 2007 at 12:09:32AM -0700, Ira Berdichevsky wrote:
> Hi,
> I have some problem to configure PostgreSQL .
> My OS is RedHat Enterprise 4 Linux9 32 bits) , I installed PostgreSQL
> version 8.2.4.
> I configured database : initdb -D /var/lib/pgsql/data -U postgres .
> I changed pg_hba.conf and postgresql.config files :
> pg_hba.conf:
> local    all    all                            trust
> host    all    all   127.0.0.1/32        md5 
> host    all    all    0.0.0./0              md5
> host    all    all    10.0.0.40/128     md5
>  
> postgresql.config:
> listen_addresses = '*'
> port = 5433
>  
> I started POstgreSQL and checked that it is run.
> I checked with "psql -h 10.0.0.40 -p 5433" command and saw that
> PostgreSQL respond it.
> The problem is I still couldn't connect to PostgreSQL from Windows
> pgAdmin agent.
> I have this error connection: "Server doesn't listen".
> I don't have problem with firewall.
> Do you have any idea what is the problem?
> Thanks.
> Ira



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Problem with PostgreSQL 8.2 on Linux Redhat
  2007-06-20 07:09 Problem with PostgreSQL 8.2 on Linux Redhat Ira Berdichevsky <Ira.Berdichevsky@protegrity.com>
@ 2007-06-20 13:04 ` Sibte Abbas <sibtay@gmail.com>
  2 siblings, 0 replies; 4+ messages in thread

From: Sibte Abbas @ 2007-06-20 13:04 UTC (permalink / raw)
  To: Ira Berdichevsky <Ira.Berdichevsky@protegrity.com>; +Cc: pgsql-admin

On 6/20/07, Ira Berdichevsky <Ira.Berdichevsky@protegrity.com> wrote:
>
>
> Hi,
> I have some problem to configure PostgreSQL .
> My OS is RedHat Enterprise 4 Linux9 32 bits) , I installed PostgreSQL
> version 8.2.4.
> I configured database : initdb -D /var/lib/pgsql/data -U postgres .
> I changed pg_hba.conf and postgresql.config files :
> pg_hba.conf:
> local    all    all                            trust
> host    all    all   127.0.0.1/32        md5
> host    all    all    0.0.0./0              md5
> host    all    all    10.0.0.40/128     md5
>
> postgresql.config:
> listen_addresses = '*'
> port = 5433
>
> I started POstgreSQL and checked that it is run.
> I checked with "psql -h 10.0.0.40 -p 5433" command and saw that PostgreSQL
> respond it.
> The problem is I still couldn't connect to PostgreSQL from Windows pgAdmin
> agent.
> I have this error connection: "Server doesn't listen".
> I don't have problem with firewall.
> Do you have any idea what is the problem?
> Thanks.
> Ira
>

Since you are not using the default port, have you configured
pgAdmin's port to 5433?

-- 
Sibte Abbas
EnterpriseDB http://www.enterprisedb.com



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Problem with PostgreSQL 8.2 on Linux Redhat
  2007-06-20 07:09 Problem with PostgreSQL 8.2 on Linux Redhat Ira Berdichevsky <Ira.Berdichevsky@protegrity.com>
@ 2007-06-20 15:40 ` Tom Lane <tgl@sss.pgh.pa.us>
  2 siblings, 0 replies; 4+ messages in thread

From: Tom Lane @ 2007-06-20 15:40 UTC (permalink / raw)
  To: Ira Berdichevsky <Ira.Berdichevsky@protegrity.com>; +Cc: pgsql-admin

"Ira Berdichevsky" <Ira.Berdichevsky@protegrity.com> writes:
> I checked with "psql -h 10.0.0.40 -p 5433" command and saw that
> PostgreSQL respond it.
> The problem is I still couldn't connect to PostgreSQL from Windows
> pgAdmin agent.
> I have this error connection: "Server doesn't listen".
> I don't have problem with firewall.

Yes you do.  It might be the server's internal firewall (see iptables)
rather than an external box, but something's filtering the packets.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2007-06-20 15:40 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-06-20 07:09 Problem with PostgreSQL 8.2 on Linux Redhat Ira Berdichevsky <Ira.Berdichevsky@protegrity.com>
2007-06-20 12:27 ` Ray Stell <stellr@cns.vt.edu>
2007-06-20 13:04 ` Sibte Abbas <sibtay@gmail.com>
2007-06-20 15:40 ` Tom Lane <tgl@sss.pgh.pa.us>

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