Archive for the ‘postgresql’ Category

The procedure below only works for Window OS  but the same method  should work for other operating systems.

Start command-line: keyboard shortcut Windows+r then type cmd OK

runas /user:postgres cmd 

You will need to enter postgres user’s password if you are not sure what the password is you should be able to change it through Computer Management under control panel. Please ask if you are not sure.

Once you successfully logged in as postgres user you will need to open Regional and Language settings via the command-line:

control intl.cpl

Make all the required configurations then restart postgresql service.

Advertisements

Run the commandline as administrator.

Steps:

Type cmd on the search box, right click on the cmd icon and Run as administrator.

Then copy and paste command below:

REG ADD "HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon\SpecialAccounts\UserList" /v postgres /d 0 /t REG_DWORD /f

original post here.

Usually the error log complains about not being able to read postgresql.conf. If you check postgres directory there is NO data folder created. In order to fix the problem you would need to follow this:

Fix:

This error is caused by the failure of initdb in creating a DB. It
fails probably due to the locale. To fix the problem:

runas /user:postgres cmd
c:
cd "\Program Files\PostgreSQL\8.3\bin"
initdb -D "c:\Program Files\PostgreSQL\8.3\data" -E UTF8 --locale=English

Don’t for get to add the locale at the end otherwise it will fail.