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

Re: Hung postmaster (8.3.9)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Hung postmaster (8.3.9)
Date: 2010-03-02 00:26:30
Message-ID: 27948.1267489590@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
"Ed L." <pgsql(at)bluepolka(dot)net> writes:
> On Monday 01 March 2010 @ 17:18, Tom Lane wrote:
>> "Ed L." <pgsql(at)bluepolka(dot)net> writes:
>>> There is one, looks like a typo got in.  How do I fix it?
>> 
>> Hmm, a user named @, or what?

> Yes, a bogus user: 

> "@" "" ""

Mph.  We really ought to fix things so that a quoted @ doesn't get taken
as an include file reference.  Odd that it's never come up before.

Anyway, if you still have any open superuser sessions, the best thing
would be an ALTER USER RENAME.  If you don't, you'll have to resort to
manually editing the pg_auth file, and then rename the user as soon as
you can get in.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Ed L.Date: 2010-03-02 00:27:39
Subject: Re: Hung postmaster (8.3.9)
Previous:From: Ed L.Date: 2010-03-02 00:25:37
Subject: Re: Hung postmaster (8.3.9)

pgsql-general by date

Next:From: Ed L.Date: 2010-03-02 00:27:39
Subject: Re: Hung postmaster (8.3.9)
Previous:From: Ed L.Date: 2010-03-02 00:25:37
Subject: Re: Hung postmaster (8.3.9)

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