From: David Lloyd-Jones <david.lloyd-jones@attcanada.ca>
To: Red Pineseed <yue207@home.com>
To: Mike Mascari <mascarm@mascari.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: PSQL Working, but PGAccess Not Connecting.
Date: Mon, 31 Jul 2000 00:17:23 -0400
Message-ID: <004801bffaa6$3ff63b40$34627bd8@WORKGROUP> (raw)
References: <200007301621.SAA02908@beertje.william.bogus>
<000601bffa64$a38bb960$46647bd8@WORKGROUP>
<1655.964993215@sss.pgh.pa.us>
<000701bffa74$88159790$406c7bd8@WORKGROUP>
<7628.964996485@sss.pgh.pa.us>
<3984DC50.BF5B2D2D@home.com>
"Red Pineseed" <yue207@home.com>. wrote:
> It looks like you don't have the user permission set up
> properly. Here is a jpg much like what you have descrbibed
> in the message. What the postmaster is not running in the
> background or the user permission is not set properly, you
> get a message like that.
>
> use the createuser command to create user and set proper
> permision and connect the db like.
Philip,
Thanks for your note. PostgreSQL starts with a default user named Postgres,
as far as I know. (Does anybody know its password? I've been assuming it's
either 'postgres' or null.)
Mike Mascari wrote:
Except that there's a difference between "Connection refused",
which is typical of the postmaster not being started with the -i
option, and "Network unreachable", which is typical of a TCP/IP
application where the kernel cannot resolve the route to the
destination host. The user never did specify the success/failure
of testing loop-back via telnet on 127.0.0.1. My bet is it didn't
work. My money's on Tom Lane.
Mike,
I did try the loopback, as I mentioned in a note to Tom (perhaps off-line,
sorry.)
Agreed, his explanation makes sense, and I'm looking for the right place to
put the -i.
Anybody know the innards of that /etc/rc.d/init.d/postgresql start
batchfile?
-dl
j.
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 using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: david.lloyd-jones@attcanada.ca, yue207@home.com, mascarm@mascari.com
Subject: Re: PSQL Working, but PGAccess Not Connecting.
In-Reply-To: <004801bffaa6$3ff63b40$34627bd8@WORKGROUP>
* 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