Thread: Re: Can't connect using PgAdminII

Re: Can't connect using PgAdminII

From
"YC Nyon"
Date:
I tried to access to Postgresql via Pgadmin, it says "user postgres does not
exist".
I use localhost to connect. the pg_hba file has a "local all trust" line.The
postgres and pgadmin is installed on
the same server.
also i tried from the command line
        createdb -h localhost test
        psql -h localhost test
and it works.

The puzzling thing is I have the same configuration running on a test server
and it works fine.

Any clues?

Thanks
Nyon


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003


Re: Can't connect using PgAdminII

From
Andrew Biagioni
Date:
I think you need to give us some more details, such as:

- What operating system are you running PostgreSQL on?
- What operating system are you running PGadmin on?
- What versions of PostgreSQL and PGadmin are you using?
- Are they on the same machine?
- When you tried from the command line, what user were you (root,
postgres, ...)?
- On what machine did you try the command line operations?

    Andrew

YC Nyon wrote:

>I tried to access to Postgresql via Pgadmin, it says "user postgres does not
>exist".
>I use localhost to connect. the pg_hba file has a "local all trust" line.The
>postgres and pgadmin is installed on
>the same server.
>also i tried from the command line
>        createdb -h localhost test
>        psql -h localhost test
>and it works.
>
>The puzzling thing is I have the same configuration running on a test server
>and it works fine.
>
>Any clues?
>
>Thanks
>Nyon
>
>
>---
>Outgoing mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
>
>