[Users] How to scratch previous versions reports and dwh installation?
Hello,
I have some problems, I think they are also due to PosgreSQL access
rules changes from f18 to f19.
In particular if one has passed from fedora 18 to Fedora 19 and form
3.2 to 3.3 as I did; see
https://bugzilla.redhat.com/show_bug.cgi?id=1009335
Right now I have a problem with my AIO installation where trying to
upgrade from 3.3.2 to 3.3.3 I got many problems related to RDBMS.
Is there a way to completely get rid of prevous installtion and
reinstall cleanly in 3.3.3 as I did on another system without getting
problems.
I tried removing packages:
yum remove ovirt-engine-dwh ovirt-engine-reports
and deleting related databases:
drop database ovirt_engine_history;
drop database ovirtenginereports;
But then trying to install again packages and runnign setup I get this in log:
2014-01-30 00:37:30::DEBUG::common_utils::446::root:: running sql
query on host: localhost, port: 5432, db: ovirt_engine_history, user:
engine, query: 'select 1 from history_configuration;'.
2014-01-30 00:37:30::DEBUG::common_utils::907::root:: Executing
command --> '/usr/bin/psql --pset=tuples_only=on --set ON_ERROR_STOP=1
--dbname ovirt_engine_history --host localhost --port 5432 --username
engine -w -c select 1 from history_configuration;' in working
directory '/root'
2014-01-30 00:37:30::DEBUG::common_utils::962::root:: output =
2014-01-30 00:37:30::DEBUG::common_utils::963::root:: stderr = ERROR:
relation "history_configuration" does not exist
LINE 1: select 1 from history_configuration;
Can anyone tell if I have to run any other purge operation, suche as
any users or table on engine db itself?
And also what would be the expected configuration of
/var/lib/pgsql/data/pg_hba.conf
and eventually
/var/lib/pgsql/data/postgresql.conf
for a fedora 19 system so that a setup for reports and dwh could complete?
Gianluca