Re: [Users] About owner of postgres

> From: Juan Hernandez <jhernand(a)redhat.com&gt; > To: Stephen Liu <satimis(a)yahoo.com&gt; > Cc: &quot;users(a)ovirt.org&quot; <users(a)ovirt.org&gt; > Sent: Sunday, November 11, 2012 3:01 AM > Subject: Re: [Users] About owner of postgres - snip - > Assuming that you don't have the data of any other application in that > PostgreSQL instance I would remove it completely and then create it > again running the following commands as root: > > systemctl stop postgresql.service > rm -rf /var/lib/pgsql > postgresql-setup initdb > systemctl start postgresql.service > > That will give you a clean instance of PosrgreSQL that you can use for > the ovirt-engine installation. > > Let us know if this helps. Your advice worked for me. Thanks. Steps performed as follows:- # systemctl stop postgresql.service # rm -rf /var/lib/pgsql # postgresql-setup initdb Initializing database ... OK # systemctl start postgresql.service # chkconfig postgresql on Note: Forwarding request to 'systemctl enable postgresql.service'. ln -s '/usr/lib/systemd/system/postgresql.service' '/etc/systemd/system/multi-user.target.wants/postgresql.service' A further question; I can change the owner of postgresql in following ways; 1) # chown satimis satimis /var/lib/pgsql/ OR 2) sudo su - postgres initdb -E UTF8 $ createuser -s -U postgres $ Enter name of role to add: {{ satimis }} Would there is any difference? If there is. After having finished the current test I can start a new test on another hard drive. Besides: on http://wiki.ovirt.org/wiki/Installing_PostgreSQL_DB Connecting to the database Run /etc/init.d/postgresql restart (it didn't work) to be replaced with: service postgresql restart _______________________________________________ Users mailing list Users(a)ovirt.org http://lists.ovirt.org/mailman/listinfo/users