Обсуждение: *really* daft novice questions...

(Note that I am a general sql/postgresql/pgadmin novice - I'm diving
in with both feet first.)

I'm using PostgreSQL 7.0.2 jon RH Linux 6.2, and everything there
seems pretty much ok. I'm having problems with getting PgAdmin
7 on my Win98 machine to connect to the Linux machine via
ODBC.

Is PgAdmin 7 compatible with PostgreSQL 7.0.2?

I keep getting errors that indicate that either the password is wrong
or the database doesn't exist. I know the database I'm trying to
access exists. I've created a user with that password on the Linux
machine. In pg_hba.conf I've even set all connections from my
Win98 machine to "trust". Is there something I've missed in the
docs which explains this problem?

Where are the PgAdmin docs, anyway?

Should I be directing some of these questions to the Interface list?

Thanks for your attention...

--------------------------------------
Christopher Wood
chriswood@wvda.com
Community Access Technical Coordinator

http://www.wvda.com/index.html
http://www.wvcn.ns.ca/index.html
http://www.wvcn.ns.ca/~bcap/index.html
--------------------------------------

Warning: blind leading blind.

Does Postgres care at all about users on the Linux box?  Or does it maintain
its own table of user accounts (which one could presumably somehow seed from
Unix-land, but that's a different newbie question)?

If it handles its own users then that's where you need to add account info.

-m

On Fri, Jul 14, 2000 at 01:01:46PM -0300, chriswood@wvda.com wrote:
> (Note that I am a general sql/postgresql/pgadmin novice - I'm diving
> in with both feet first.)
>
> I'm using PostgreSQL 7.0.2 jon RH Linux 6.2, and everything there
> seems pretty much ok. I'm having problems with getting PgAdmin
> 7 on my Win98 machine to connect to the Linux machine via
> ODBC.
>
> Is PgAdmin 7 compatible with PostgreSQL 7.0.2?
>
> I keep getting errors that indicate that either the password is wrong
> or the database doesn't exist. I know the database I'm trying to
> access exists. I've created a user with that password on the Linux
> machine. In pg_hba.conf I've even set all connections from my
> Win98 machine to "trust". Is there something I've missed in the
> docs which explains this problem?
>
> Where are the PgAdmin docs, anyway?
>
> Should I be directing some of these questions to the Interface list?
>
> Thanks for your attention...
>
> --------------------------------------
> Christopher Wood
> chriswood@wvda.com
> Community Access Technical Coordinator
>
> http://www.wvda.com/index.html
> http://www.wvcn.ns.ca/index.html
> http://www.wvcn.ns.ca/~bcap/index.html
> --------------------------------------

--
Michael Jinks, IB
Systems Administrator, CCCP
finger mjinks@embley.spc.uchicago.edu for public key
A guiding voice for all humanity: http://www.yellow5.com/pokey/

Okay, here we go:

http://www.postgresql.org/docs/admin/client-authentication.htm

HTH,
-m

--
Michael Jinks, IB
Systems Administrator, CCCP
finger mjinks@embley.spc.uchicago.edu for public key
A guiding voice for all humanity: http://www.yellow5.com/pokey/

I'm not familiar with PgAdmin.  But I do use PsqlODBC (see
ftp://ftp.postgresql.org/pub/odbc/index.html )

You need to enable connections to the database backend over the network with
the -i option when starting the postmaster process.

Pat



        -----Original Message-----
        From:    chriswood@wvda.com [mailto:chriswood@wvda.com]
        Sent:    Friday, July 14, 2000 10:02 AM
        To:    pgsql-novice@postgresql.org
        Subject:    [NOVICE] *really* daft novice questions...

        (Note that I am a general sql/postgresql/pgadmin novice -
I'm diving
        in with both feet first.)

        I'm using PostgreSQL 7.0.2 jon RH Linux 6.2, and everything
there
        seems pretty much ok. I'm having problems with getting
PgAdmin
        7 on my Win98 machine to connect to the Linux machine via
        ODBC.

        Is PgAdmin 7 compatible with PostgreSQL 7.0.2?

        I keep getting errors that indicate that either the password
is wrong
        or the database doesn't exist. I know the database I'm
trying to
        access exists. I've created a user with that password on the
Linux
        machine. In pg_hba.conf I've even set all connections from
my
        Win98 machine to "trust". Is there something I've missed in
the
        docs which explains this problem?

        Where are the PgAdmin docs, anyway?

        Should I be directing some of these questions to the
Interface list?

        Thanks for your attention...

        --------------------------------------
        Christopher Wood
        chriswood@wvda.com
        Community Access Technical Coordinator

        http://www.wvda.com/index.html
        http://www.wvcn.ns.ca/index.html
        http://www.wvcn.ns.ca/~bcap/index.html
        --------------------------------------