Install PostgreSQL data in user folder

Question

I'm trying to install PostgreSQL (version 9.4.5-2 x64) in my computer and I would like to put data in my user folder. I think that it is better to do not lose data when uninstall Postgre later or even format programs partition.

The problem is that it doesn't initiate the PostgreSQL service, even using Administrator profile. It shows a message saying: Failed to load SQL Modules into the database cluster., probably because it couldn't initiate the service.

I tried many different folders and even changing some permissions it was not possible to do this. The best alternative was to put it on program data folder. Is there anything that I could do to put it or in local user app data or my documents folder?

Regards, Leandro

Community · Accepted Answer · 2017-05-23 12:30:49Z

1

Have you tried the solution from this question?

1) Create a new user account, called postgres

2) Add the new account to the Administrators and Power Users groups

3) Restart the computer

4) Run a command prompt as the postgres user, using the command:

runas /user:postgres cmd.exe

5) Run the installer from the postgres command window

6) Delete the postgres user account, as well as the user directory

edited May 23, 2017 at 12:30

CommunityBot

11 silver badge

answered Dec 4, 2015 at 13:59

Theo Babilon

6616 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Craig Ringer Over a year ago

The postgres user should not be an Administrator.

Leandro Lima Over a year ago

This is an opition but it's not possible to use in Inno Setup (my idea) because it asks for postgres profile authentication.

Collectives™ on Stack Overflow

Install PostgreSQL data in user folder

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related