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

Re: Hung postmaster (8.3.9)

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Hung postmaster (8.3.9)
Date: 2010-03-02 00:49:44
Message-ID: 201003011749.44210.pgsql@bluepolka.net (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
On Monday 01 March 2010 @ 17:36, Ed L. wrote:
> On Monday 01 March 2010 @ 17:26, Tom Lane wrote:
> > "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.
> 
> Killed the stuck postmaster with sigkill, edited the file,
> restarted postmaster, and it re-wrote the file with the bogus
> entry.  I don't have any superuser sessions open.  Is there
> another route?

I have source code and can patch and rebuild/reinstall if I had 
the right patch.

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2010-03-02 00:57:09
Subject: Re: Hung postmaster (8.3.9)
Previous:From: Greg StarkDate: 2010-03-02 00:46:22
Subject: Re: Hot Standby query cancellation and Streaming Replication integration

pgsql-general by date

Next:From: Tom LaneDate: 2010-03-02 00:57:09
Subject: Re: Hung postmaster (8.3.9)
Previous:From: Ed L.Date: 2010-03-02 00:36:40
Subject: Re: Hung postmaster (8.3.9)

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