"PostgreSQL Bugs List" <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to