On Fri, Oct 31, 2003 at 10:07:54AM +0100, Karsten Hilbert wrote:
With the bootstrap-public_db.conf I get the error after the password.
use bootstrap-monolithic_core.conf
Ok, I tried that after fixing what was wrong in my pg_hba.conf (gathered
it from the logs after I saw where they were).
The bootstrap program ran, but I noticed several PostgreSQL ERROR messages
flying by, so I wanted to check them. To do that I started redirecting
stderr to a pg-out file like this:
$ ./bootstrap-gm_db_system.py --conf-file=bootstrap-monolithic_core.conf
--log-file=./foo 2> pg-out.txt
This tells me that the bootstrap script has a bug because an interactive
question is going into stderr which is now being redirected:
---
...
Do you really want to install this database setup ?
yes <-- The "Type yes or no:" question has been redirected to the pg-out file
...
---
Now the bootstrap doesn't work anymore. Understandable, I think to myself,
since now things have been created, although it should check and ask me if
I want to drop them or not.
So I start trying to DROP the database and users it created. the
"dropuser" PostgreSQL only takes one user at a time, so I write some bash
magic:
for USER in gm-dbowner test-doc _test_doc test-nurse _test-nurse test-secretary
_test-secretary; do dropuser $USER; done;
Run the bootstrap script again, no go. I get the following in the log:
2003-10-31 11:55:53 [WARN] (./bootstrap-gm_db_system.py::__create_db:651):
exception type : libpq.Warning
2003-10-31 11:55:53 [WARN] (./bootstrap-gm_db_system.py::__create_db:651):
exception value: WARNING: ROLLBACK: no transaction in progress
2003-10-31 11:55:53 [DATA] (./bootstrap-gm_db_system.py::__create_db:651): Traceback
(most recent call last):<#10-0x0A-lf>
2003-10-31 11:55:53 [DATA] (./bootstrap-gm_db_system.py::__create_db:651): File
"./bootstrap-gm_db_system.py", line 649, in __create_db<#10-0x0A-lf>
cursor.execute(cmd)<#10-0x0A-lf>
2003-10-31 11:55:53 [DATA] (./bootstrap-gm_db_system.py::__create_db:651): File
"/usr/lib/python2.3/site-packages/pyPgSQL/PgSQL.py", line 3069, in
execute<#10-0x0A-lf> raise Warning, self.conn.notices.pop()<#10-0x0A-lf>
2003-10-31 11:55:53 [DATA] (./bootstrap-gm_db_system.py::__create_db:651): Warning:
WARNING: ROLLBACK: no transaction in progress<#10-0x0A-lf><#10-0x0A-lf>
2003-10-31 11:55:53 [PANIC] (./bootstrap-gm_db_system.py::bootstrap:772):
Cannot bootstrap service [config].
2003-10-31 11:55:53 [PANIC] (./bootstrap-gm_db_system.py::bootstrap:772):
exception type : libpq.Warning
2003-10-31 11:55:53 [PANIC] (./bootstrap-gm_db_system.py::bootstrap:772):
exception value: WARNING: COMMIT: no transaction in progress
So the question is, what do I need to do in order to
"start from scratch" the bootstrap process? It looks like I need to drop
some groups.
Should I just go through the SQL file and reverse them manually? Is there
a better way besides reinstalling PostgreSQL?