windows could not start the pervasive psql workgroup engine

[Gadgetro956]

I Have successfully started most of the services i need in Safe Mode - Networking, however, i need now to start "Postgresql Server- 9.6 and its "Pervasive PSQL Workgroup Engine" as i am a user of Sage 50 Peachtree Accounting. Any feedback will be appreciated.

 

[samuria]

Welcome to the forum. It's saying it can't start in safe mode have you tried it in normal mode?

 

[Gadgetro956]

Yes i have tried in in normal mode however, the software does not work properly with database

 

[Barman58]

Sounds like an issue with the actual database - Sage 50 is usually a Leased product here in the UK, you should be able to get your local Sage agent to solve your issues quickly, and at negligible or no cost.

also upen the services manager (easiest is via Task Manager), go to the faulting service and check the properties for Dependencies, and make sure these are present on the system, started, and running

 

[Gadgetro956]

The dependencies are running, I just need to start the PSQL service

 

[Barman58]

The name of the service (it includes SQL in the title), would strongly suggest that this is the actual service that provides user access to the database, if all the dependencies are in place this would suggest that there is either a corruption in the database or that there is a mix up with the access permissions on windows that allows users access to the data. I do not know enough specific about Sage to go further than that, so an email to Sage support is probably the best solution

 

[Gadgetro956]

Yes, i have since contacted the Sage 50 team, hoping for a reply.

 

[mrjimphelps]

Run Windows in Normal mode, and then run MSCONFIG. On the General tab, choose Diagnostic startup, then click OK. Reboot.

Another MSCONFIG option would be to go to the Boot tab, check Safe boot, and choose Minimal. Click OK. Reboot.

A third thing to try in MSCONFIG would be to go to the Services tab, check the box for Hide all Microsoft services, and then disable one or more of the non-Microsoft services. Click OK. Reboot. For this option, you'll need to experiment whether or not disabling certain non-Microsoft services will get the job done. Keep in mind that if you disable something, it won't be running, so if you can live with that, fine. For example, if you disable your antivirus service, you won't have antivirus protection.

By doing one or more of the above, you won't be in Safe mode, but you'll get much of the benefit of Safe Mode, because you'll stop a lot of normal stuff from running. Perhaps that will permit you to run everything you need for this program.

Don't forget to re-enable needed items when you aren't running Sage.

 

[Gadgetro956]

I have since uninstalled the program, now tying to reinstall it however i think the Pervasive database have left file in the Windows assembly which i cannot delete and i have admin privileges. I need to know how to manually uninstall file from the C:/Windows/assembly

 

[Barman58]

You may be able to access that folder (as long as Sage has not used a "Deny" access permission by the use of the full hidden administrator account ...

Built-in Administrator Account - Enable or Disable - Windows 7 Help Forums

This is a very powerful feature and could accidently cause serious issues if used without thought, I would always advise that you hide the Hidden Administrator after you complete your task

 

[Gadgetro956]

Access is being denied, i am using administrator account and right and still cannot uninstall it. How can i do this?

 

[Barman58]

Are you using the hidden admin account? or a regular admin account? Windows 7 has more layers than earlier versions of windows - there is a user (part of System) called Trusted Installer and this sits above the normal Admin (it's there as a prevention of some advanced type of malware attacks)

The only other way I know is to access the disk from a non windows system that does not respect NTFS permissions - Luckily :sarc: we have a number of Linux Distributions that allow use of a DVD or USB Stick to run in a live form without full installation ( trial setup ). It is possible to use this to delete files and folders that are locked in windows. You will need a basic Linux knowledge to use this technique bur If needed I should be able to point you in the right direction

 

[Gadgetro956]

I think i am using the regular admin account, i would love if you could point me in the right direction as i would love to gain access to remove these files.

 

[Barman58]

If you follow the link I posted in Post #10 above it should solve your issue - If you try it and still cannot get it removed then we will have to look at the linux route

windows could not start the pervasive psql workgroup engine - Windows 7 Help Forums

 

[Gadgetro956]

I have tried all the different options, i still havent been able to gain access to uninstall the files

 

[Anak]

Do you use malwarebytes? If so it has a program under its tools called Fileassassin if you can't find it the D/L page is here: https://www.malwarebytes.com/fileassassin/

 

[Anak]

If you hit the 'Windows could not start the Pervasive PSQL Workgroup Engine on Local Computer' again, see if this guide helps: https://support.na.sage.com/selfservice/viewContent.do?externalId=12276&sliceId=1

Then I searched for it an got 84 results on the sage support site

 

[Gadgetro956]

Anak FileAssassin did not work, it was unable to select a file from "C:/Windows/Assembly/xxxxxxxxxxx", when i manually typed in and pointed to "C:/Windows/Assembly/" the computer crashed. I also tried that Knowledge base forum and i did all the steps to no avail. I currently am downloading Ubuntu so i can try Barman58 technique

 

[Anak]

Okay, if the Ubuntu doesn't work I saw this on the first sage link I offered.

At Solution V:

Solution V: Uninstall and reinstall Pervasive

1. Download the Sage 50 Database Repair Utility. Follow Article ID 10529 Using the Sage 50 Database Repair Utility, in Related Resources.

The link for the utility is here: Using the Sage 50 Database Repair Utility After you get it installed read it so you understand what it can do.

After step 4. Options under Resolution you'll see:

[FONT=Arial, Helvetica]Remove Pervasive[/FONT]

[FONT=Arial, Helvetica]The Remove Pervasive utility will uninstall Pervasive from the local computer. This utility is usually used in conjunction with the Install Pervasive utility. It is important to ensure that all users have logged out and closed Sage 50 before using this utility - upon starting this utility; a message will provide a reminder:[/FONT]

[FONT=Arial, Helvetica]Note: The initial attempt to uninstall Pervasive will usually fail. This is normal and is caused by Pervasive being started during the uninstall process. Just run the process again to successfully uninstall Pervasive.[/FONT]

That last note is important it may look like the removal failed but run it again and then check to see if that file has been removed.

 

[lehnerus2000]

Backup Images

@Anak FileAssassin did not work, it was unable to select a file from "C:/Windows/Assembly/xxxxxxxxxxx", when i manually typed in and pointed to "C:/Windows/Assembly/" the computer crashed. I also tried that Knowledge base forum and i did all the steps to no avail. I currently am downloading Ubuntu so i can try @Barman58 technique

Before you try to delete the folder using a Live Ubuntu CD/DVD/USB, you should create a Backup Image of the drive (just in case something weird happens).

Tutorial
Imaging with free Macrium