Skip site navigation (1) Skip section navigation (2)

Re: Login problem

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 (view raw or flat)
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


In response to

Responses

pgsql-novice by date

Next:From: webbj2Date: 2005-12-18 21:02:07
Subject: Find list of table names for particular DB
Previous:From: Srinivas IyyerDate: 2005-12-18 13:59:42
Subject: COPY command, linking foreign keys

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group