Re: Hung postmaster (8.3.9) - Mailing list pgsql-general

From Tom Lane
Subject Re: Hung postmaster (8.3.9)
Date
Msg-id 27948.1267489590@sss.pgh.pa.us
Whole thread Raw
In response to Re: Hung postmaster (8.3.9)  ("Ed L." <pgsql@bluepolka.net>)
Responses Re: Hung postmaster (8.3.9)  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
"Ed L." <pgsql@bluepolka.net> writes:
> On Monday 01 March 2010 @ 17:18, Tom Lane wrote:
>> "Ed L." <pgsql@bluepolka.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

pgsql-general by date:

Previous
From: "Ed L."
Date:
Subject: Re: Hung postmaster (8.3.9)
Next
From: "Ed L."
Date:
Subject: Re: Hung postmaster (8.3.9)