Thread: How to re-own db cluster
Hello,
I was trying to install a student information system called Centre which failed to connect to postgres for reasons I have still been unable to isolate. In order to restart the entire procedure of installation of database and Centre, I removed the 'postgres' user and group that owned the database and then readded them only to get the following error:
"Stopping PostgreSQL 8.3 database server: main
Error: The cluster is owned by user id 110which does not exist anymore
failed!"
How can I re-own the cluster? I cannot uninstall the postgresql-8.3 deb using 'dpkg --purge postgesql-8.3'? Reinstalling gives similar configuration errors. I use Debian 'Lenny'.
Thank you.
Regards,
--
Vikram Vincent
+919448810822
http://www.swatantra.org/
http://translate.swatantra.org/
I was trying to install a student information system called Centre which failed to connect to postgres for reasons I have still been unable to isolate. In order to restart the entire procedure of installation of database and Centre, I removed the 'postgres' user and group that owned the database and then readded them only to get the following error:
"Stopping PostgreSQL 8.3 database server: main
Error: The cluster is owned by user id 110which does not exist anymore
failed!"
How can I re-own the cluster? I cannot uninstall the postgresql-8.3 deb using 'dpkg --purge postgesql-8.3'? Reinstalling gives similar configuration errors. I use Debian 'Lenny'.
Thank you.
Regards,
--
Vikram Vincent
+919448810822
http://www.swatantra.org/
http://translate.swatantra.org/
On 15/02/2008, Vikram Vincent <vincentvikram@gmail.com> wrote:
Hello,
I was trying to install a student information system called Centre which failed to connect to postgres for reasons I have still been unable to isolate. In order to restart the entire procedure of installation of database and Centre, I removed the 'postgres' user and group that owned the database and then readded them only to get the following error:
"Stopping PostgreSQL 8.3 database server: main
Error: The cluster is owned by user id 110which does not exist anymore
failed!"
How can I re-own the cluster? I cannot uninstall the postgresql-8.3 deb using 'dpkg --purge postgesql-8.3'? Reinstalling gives similar configuration errors. I use Debian 'Lenny'.
Thank you.
Regards,
Re-create the postgres user with the right user id. I believe that should be "adduser -UID 110 postgres" there are more complex answers but this is probably the simplest.
Regards
PEter
Hello, Peter Childs wrote: > Re-create the postgres user with the right user id. I believe that > should be "adduser -UID 110 postgres" there are more complex answers > but this is probably the simplest. Thanks Peter. Your idea was useful in solving this problem. Regards, -- Vikram Vincent +91 9448810822 http://www.swatantra.org http://translate.swatantra.org/