From: | John DeSoi <desoi(at)pgedit(dot)com> |
---|---|
To: | Danjel Jungersen <danjel(at)jungersen(dot)dk> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Login problem |
Date: | 2005-12-18 14:00:00 |
Message-ID: | EAE7A21E-DB07-4EB3-9BE6-37449D945804@pgedit.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Dec 18, 2005, at 5:44 AM, Danjel Jungersen wrote:
> Below are instructions on how to login without a password, and a
> point in the direction on how to change it, but I keep getting:
> psql: FATAL: User "me" does not exist.
>
> After some tries I got pass the database does not exist ;-)
>
> Is there a user that is allways there, or can I see a list somewhere
> ?
> The "postmaster" is mentioned, so I have tried that "root" and
> "Postmaster", no luck...
>
The default superuser name is "postgres". There is generally a
default database called template1. In PostgreSQL 8.1 and later, I
believe the default database name has changed to "postgres" as well.
So try
psql -U postgres template1
or
psql -U postgres postgres
John
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
From | Date | Subject | |
---|---|---|---|
Next Message | webbj2 | 2005-12-18 21:02:07 | Find list of table names for particular DB |
Previous Message | Srinivas Iyyer | 2005-12-18 13:59:42 | COPY command, linking foreign keys |