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