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.
psql -U postgres template1
psql -U postgres postgres
John DeSoi, Ph.D.
Power Tools for PostgreSQL
In response to
pgsql-novice by date
|Next:||From: webbj2||Date: 2005-12-18 21:02:07|
|Subject: Find list of table names for particular DB|
|Previous:||From: Srinivas Iyyer||Date: 2005-12-18 13:59:42|
|Subject: COPY command, linking foreign keys |