Re: Installing PostgreSQL fails

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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_permissions_does_PostgreSQL_require.3F

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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux