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)
>
>
>
>