Categories
Tag Cloud
cpanel
Cyber Threats
database
Domain
Epp Code
Facebook
Firefox
Google
graphics design in Kenya
Hosting
How to create a free website in Kenya
how to stay safe with PayPal
http error 500
Internet Explorer Browser
iOS
iPhone
Microsoft Bing
Safari Browser
simple steps to register a domain
spam
spamexperts
ssl certificate
web hosting kenya
Web security
webhosting in Kenya
webmail
website
website design in kenya
Website Designers in Kenya
What is XOVI NOW
windows 10
winodws 11
Wordpress
Yandex
Why the PostgreSQL Service does not start?
- 1
-
Tired of reading? Press play to listen instead. N/B. Might not work on some articles
Ready
If the database/server connection is not able to open there are certain steps to follow in order to determine the cause; the basic cause is the service account not initializing the service. In order to troubleshoot this problem follow the below steps:
- Go to Control Panel > Administrative Tools > Services.
- Manually initialize the PostgreSQL Database Server Service.
- If it's able to initialize, the service is most likely set to a Manual Startup type and needs to be changed to Automatic; if it does not continue with Step 4.
- Go to Control Panel > Administrative Tools > Computer Management > Local Users and Groups > Users.
- If a PostgreSQL Service Account (by default bio1) exists, proceed to Step 6. Otherwise continue below sub-steps:
- Right-click on Users > select New User.
- Set user name as bio1.
- Set full name as bio1.
- Description is PostgreSQL Service Account.
- Create a password that meets the users domain policy.
- Uncheck User must change password at next logon box.
- Check User cannot change password box.
- Check the Password never expires box.
- Click Create.
- Double click the new bio1 user and select the Member Of tab.
- Delete any included group.
- Right click the user and re-assign the default password Biosystems1 or Biosystems1! if the password policy needs a more complex one.
- Go to Control Panel > Administrative Tools > Services.
- Double click on the PostgreSQL Database Server Service.
- Click on the Log On tab and type the password recently created. Be sure to use the Service Account.
- Click Apply.
- Click on General tab.
- Click Start button.
If company policies are being pushed in the PC, the Logon as a Service right will be removed from bio1 with each update. If this is the case and as long as the user is able to start and stop services, use the Local Account to start and stop the service. To do so perform steps 7-12 selecting the Local Account instead.
Credit: honeywell
Was this answer helpful?
Related Articles
How to start PostgreSQL on Windows
To start PostgreSQL on Windows, you can follow these steps:
Open the PostgreSQL installation...
How to export users from cpanel phpmyadmin
Step 1: Export Users from cpanel
You can Export users from one site to another site by...
Connecting to Advanced Server with the pgAdmin 4 client
pgAdmin 4 provides an interactive graphical interface that you can use to manage your database...
Install PostgreSQL Database For Windows
To use Postgre in your machine, you need to install:
Postgre Database Server
A graphical tool...
Import a SQL File in MySQL
Importing SQL files into MySQL is a common task for developers and database administrators. The...
Tag Cloud
cpanel
Cyber Threats
database
Domain
Epp Code
Facebook
Firefox
Google
graphics design in Kenya
Hosting
How to create a free website in Kenya
how to stay safe with PayPal
http error 500
Internet Explorer Browser
iOS
iPhone
Microsoft Bing
Safari Browser
simple steps to register a domain
spam
spamexperts
ssl certificate
web hosting kenya
Web security
webhosting in Kenya
webmail
website
website design in kenya
Website Designers in Kenya
What is XOVI NOW
windows 10
winodws 11
Wordpress
Yandex
