From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Amauri Pimenta <amauripimenta@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Not connect to server!
Date: Thu, 30 Dec 2004 08:20:06 -0600
Message-ID: <1104416406.5893.57.camel@state.g2switchworks.com> (raw)
In-Reply-To: <8718db24041230054625d4021e@mail.gmail.com>
References: <8718db24041230054625d4021e@mail.gmail.com>
On Thu, 2004-12-30 at 07:46, Amauri Pimenta wrote:
> Hello!
>
> Well, i just try to connect to server, but without successfull!
>
> the error is "Is the server running on host "172.22.0.23" and
> accepting TCP/IP Connections on port 5432?"
>
> Just look documentation and follow the steps and the error continue!
>
> Please, help me! its urgent!
Are you starting your database with pg_ctl or by typing postmaster by
hand? If you're using pg_ctl, edit your $PGDATA/postgresql.conf file to
have tcpip_socket = true, and edit $PGDATA/pg_hba.conf to allow your
machine to connect. Look for a line that looks like this:
host all all 127.0.0.1 255.255.255.0 trust
and edit accordingly, then restart your server.
If you're starting postmaster by hand, I'd recommend switching to using
pg_ctl. Generally running postmaster by hand is done by people more
expert at running postgresql than folks not sure why they can't get
TCP/IP connections to work. :)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: smarlowe@g2switchworks.com, amauripimenta@gmail.com
Subject: Re: Not connect to server!
In-Reply-To: <1104416406.5893.57.camel@state.g2switchworks.com>
References: <8718db24041230054625d4021e@mail.gmail.com> <1104416406.5893.57.camel@state.g2switchworks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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