On 11/11/2012 10:07 AM, Stephen Liu wrote:
From: Juan Hernandez <jhernand@redhat.com> To: Stephen Liu <satimis@yahoo.com> Cc: "users@ovirt.org" <users@ovirt.org> 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@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
i may have missed this, but why are you trying to change the owner of postgres?