[patch] INSTALL doc note (was Re: BUG #1051: Cannot remove groups)

From: jari(dot)aalto(at)poboxes(dot)com (Jari Aalto)
To: PostgreSQL fixes <pgsql-patches(at)postgresql(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org, <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: [patch] INSTALL doc note (was Re: BUG #1051: Cannot remove groups)
Date: 2004-01-17 11:37:48
Message-ID: 8yk64xgz.fsf@blue.sea.net
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.

Tom Lane:
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.)

Thank you. That did it. May I suggest adding this:

--- INSTALL.old 2004-01-17 13:34:22.000000000 +0200
+++ INSTALL 2004-01-17 13:33:32.000000000 +0200
@@ -15,6 +15,7 @@
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su - postgres
+ <kill current postmaster. This clears groups and users>
LC_ALL=C /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 &
/usr/local/pgsql/bin/createdb test

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PostgreSQL Bugs List 2004-01-17 13:09:54 BUG #1053: Configuration should be in /etc/postgres
Previous Message PostgreSQL Bugs List 2004-01-17 08:13:15 BUG #1052: Problem while Installation of postgreSQL

Browse pgsql-patches by date

  From Date Subject
Next Message Bill Moran 2004-01-18 05:22:34 Patch to bring \copy syntax more in line with SQL copy
Previous Message Jari Aalto 2004-01-17 11:21:49 [patch] 7.4 initdb - drop trailing slash from $PGDATA