Re: Installing PostgreSQL fails - Mailing list pgsql-admin
From | Josef Springer |
---|---|
Subject | Re: Installing PostgreSQL fails |
Date | |
Msg-id | 54FAD14D.5010606@joops.com Whole thread Raw |
In response to | Re: Installing PostgreSQL fails (Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>) |
Responses |
Re: Installing PostgreSQL fails
|
List | pgsql-admin |
Hello Jan,<br /><br /> yes, i used the same win-user for installation and the same user (default postgres) an password forthe server-service.<br /><ul><li>Server works after reinstallation.<li>I terminate server-service<li>I restore backupof folder data <li>I start server-service<li>Starting of server-service is abandomed with errormessage "Fehler 1053Der Dienst antwortet nicht auf die Start oder Steueranweisung"</ul> Any ideas ?<br /><br /> best thanks for your assistance,<br/> Josef Springer<br /><br /><br /> On 07.03.2015 01:55, Jan-Peter Seifert wrote: <blockquote cite="mid:54FA4C88.7050902@gmx.de"type="cite">Hello Josef, <br /><br /> open services (services.msc) and check which userthe service has been registered to ( default name is postgres ). <br /> Is this really the VERY same user used for theold instance? <br /> If not he has a different ID and has to be given the necessary file permissions: <br /><a class="moz-txt-link-freetext" href="http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows#What_filesystem_permissions_does_PostgreSQL_require.3F">http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows#What_filesystem_permissions_does_PostgreSQL_require.3F</a><br /><br/> The owner of the service should be a local user and not member of a domain. <br /><br /> And you should really checkWindows' event log for the error messages during service startup. <br /><br /> Good luck! <br /><br /> Peter <br /><br/> Am 05.03.2015 um 11:08 schrieb Josef Springer: <br /><blockquote type="cite">Hello Jan, <br /><br /> the Server-Service worked after reinstalling PostgreSQL correctly. <br /> But after copying back the backup of the folder *data*,the <br /> Server-Service does not work anymore. <br /> What i did: <br /><br /> * Term the Server-Service <br /> * Copying back the backup of the folder *data* <br /> * Starting the Server-Service (whitch did not) <br /><br /> So,i assume copying back the folder *data* is not enought. Something is <br /> missing from the backup ? <br /><br /> Doyou have any tips for me, thanks, <br /> Josef Springer <br /><br /> On 01.03.2015 15:32, Jan-Peter Seifert wrote: <br/><blockquote type="cite">Am 01.03.2015 um 13:08 schrieb Josef Springer: <br /><br /><blockquote type="cite"> * But startingnow PostgtreSQL-Server service does not work anymore. I <br /> get an error message after a while (Error 1053)<br /><br /> Do you have any tips how i can get my databases back ? <br /></blockquote><br /> Look into the Windowsevent log for more info. <br /> I guess you also recreated the Windows user postgres so that the file <br /> privilegesare wrong. <br /> IIRC there's a batch file for setting the correct file privileges ( <br /> don't recall the name)within the PostgreSQL installation folder. <br /> Beware - if you specify the wrong path you might not be able to start<br /> Windows again!!!! <br /><br /> Good luck ... <br /><br /><br /><br /><br /></blockquote><br /><br /></blockquote><br/><br /></blockquote><br /><div class="moz-signature"><br /></div>
pgsql-admin by date: