Re: BUG #1051: Cannot remove groups

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jari(dot)aalto(at)poboxes(dot)com
Cc: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #1051: Cannot remove groups
Date: 2004-01-16 21:19:46
Message-ID: 11771.1074287986@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-patches

"PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org> writes:
> I tried to install all from fresh with:
> ...
> But that dind't affect the groups or users. This was verified by running
> select from pg_group and pg_users immedately after total recreation.

Your trace shows no sign of having stopped the postmaster before
re-initdb'ing or starting it again afterwards. I think you've got some
unholy combination of old and new tables inside the postmaster. It'd be
a good idea to try again with those steps included. (I'm not sure just
how Windows handles deletion of directories that are still in use, but
on Unix a pg_ctl stop would no longer suffice to get rid of the old
postmaster, because after the rm -rf you can no longer get to the
directory in which the old postmaster is running. You might be best
advised to reboot.)

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Craig Ruff 2004-01-16 23:05:00 Re: 7.3.5 initdb failure on Irix 6.5.18
Previous Message PostgreSQL Bugs List 2004-01-16 18:26:03 BUG #1051: Cannot remove groups

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2004-01-16 21:34:30 Re: psql prompts with invisible characters
Previous Message Reece Hart 2004-01-16 18:58:24 psql prompts with invisible characters