From: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
To: Josef Springer <Josef.Springer@joops.com>
Cc: Lou Picciano <loupicciano@comcast.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: Installing PostgreSQL fails
Date: Sat, 07 Mar 2015 01:55:36 +0100
Message-ID: <54FA4C88.7050902@gmx.de> (raw)
In-Reply-To: <54F82B20.4010906@joops.com>
References: <54F05CBF.5050006@joops.com>
<1469279821.239990.1425053551214.JavaMail.zimbra@comcast.net>
<54F30147.1020207@joops.com>
<54F32306.5020609@gmx.de>
<54F82B20.4010906@joops.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hello Josef,
open services (services.msc) and check which user the service has been
registered to ( default name is postgres ).
Is this really the VERY same user used for the old instance?
If not he has a different ID and has to be given the necessary file
permissions:
http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows#What_filesystem_...
The owner of the service should be a local user and not member of a domain.
And you should really check Windows' event log for the error messages
during service startup.
Good luck!
Peter
Am 05.03.2015 um 11:08 schrieb Josef Springer:
> Hello Jan,
>
> the Server-Service worked after reinstalling PostgreSQL correctly.
> But after copying back the backup of the folder *data*, the
> Server-Service does not work anymore.
> What i did:
>
> * Term the Server-Service
> * Copying back the backup of the folder *data*
> * Starting the Server-Service (whitch did not)
>
> So, i assume copying back the folder *data* is not enought. Something is
> missing from the backup ?
>
> Do you have any tips for me, thanks,
> Josef Springer
>
> On 01.03.2015 15:32, Jan-Peter Seifert wrote:
>> Am 01.03.2015 um 13:08 schrieb Josef Springer:
>>
>>> * But starting now PostgtreSQL-Server service does not work anymore. I
>>> get an error message after a while (Error 1053)
>>>
>>> Do you have any tips how i can get my databases back ?
>>
>> Look into the Windows event log for more info.
>> I guess you also recreated the Windows user postgres so that the file
>> privileges are wrong.
>> IIRC there's a batch file for setting the correct file privileges (
>> don't recall the name) within the PostgreSQL installation folder.
>> Beware - if you specify the wrong path you might not be able to start
>> Windows again!!!!
>>
>> Good luck ...
>>
>>
>>
>>
>
>
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Jan-Peter.Seifert@gmx.de, Josef.Springer@joops.com, loupicciano@comcast.net
Subject: Re: Installing PostgreSQL fails
In-Reply-To: <54FA4C88.7050902@gmx.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox