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

Re: Login problem

From: "Danjel Jungersen" <danjel(at)jungersen(dot)dk>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Login problem
Date: 2005-12-20 07:33:31
Message-ID: 43A7C1DB.26831.16373D@localhost (view raw or flat)
Thread:
Lists: pgsql-novice
On 18 Dec 2005 at 9:00, John DeSoi wrote:

> 
> 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
With some testing I have found that I have the databasename correct, 
but still:
"user does not exist" :-(

Hope I can get throught this ;-)

btw, I'm running 7.4.3...

best regards
Danjel

> 
> John
> 
> 
> 
> John DeSoi, Ph.D.
> http://pgedit.com/
> Power Tools for PostgreSQL
> 



In response to

Responses

pgsql-novice by date

Next:From: OlegDate: 2005-12-20 12:52:53
Subject: problems restoring database from plain text backup
Previous:From: Michael GlaesemannDate: 2005-12-19 23:35:27
Subject: Re: procedures for adding data

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