Re: [Users] About owner of postgres
From: Juan Hernandez <jhernand(a)redhat.com>
To: Stephen Liu <satimis(a)yahoo.com>
Cc: "users(a)ovirt.org" <users(a)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