On 11/11/2012 10:07 AM, Stephen Liu wrote:
From: Juan Hernandez <[email protected]>
To: Stephen Liu <[email protected]>
Cc: "[email protected]" <[email protected]>
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
[email protected]
http://lists.ovirt.org/mailman/listinfo/users
i may have missed this, but why are you trying to change the owner of
postgres?
_______________________________________________
Users mailing list
[email protected]
http://lists.ovirt.org/mailman/listinfo/users
