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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-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

Browse pgsql-general by date

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

Browse pgsql-hackers by date

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