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:

Previous
From: John Scalia
Date:
Subject: authenticating using Active Directory?
Next
From: Josef Springer
Date:
Subject: Re: Installing PostgreSQL fails