Go inside bin folder in C drive where Postgres is installed. Another way: type "services. You need to do that from a cmd.
Or use net start postgresql Note that the name of the service might be different in your installation. Another option is to start the service through the Windows control panel. Which means that Postgres is already running, so I don't understand why you think you need to do that again. Especially because the installer typically sets the service to start automatically when Windows is started.
The reason you are not seeing any result is that psql requires every SQL command to be terminated with ; in your case it's simply waiting for you to finish the statement. See here for more details: In psql, why do some commands have no effect? If you are getting an error "psql. Since you have already installed PostgreSQL the latter can not be the issue assuming everything is installed as expected. In order to fix the first one " please specify the full path to the bin directory in the PostgreSQL installation folder, where this tool resides.
There are different way to open PostgreSql database. To do that got to installed postgresql file and select the path of bin and add to enviroment variable of window setting.
Hit enter and it ask you password. After giving password you can create database and tables and can access it. I was try to solve the problem with Windows Terminal and I've cannot to solve it. The version number must be changed to take into account the installed version of your PostgreSQL Server. Stack Overflow for Teams — Collaborate and share knowledge with a private group.
Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Ask Question. Asked 5 years, 9 months ago. Contact us and we will be happy to help! Start Service Protector. In a couple of seconds the shield icon on the right will go to green to indicate that PostgreSQL is being monitored by Service Protector: That's it! Service Protector. What is Service Protector? Version 8. Our customers include Active Oldest Votes. Improve this answer. Vicky Ibrahim Vicky Ibrahim 11 1 1 bronze badge.
The whole point of postgres creating an account is that it shouldn't run as the system account for security reasons. Nixphoe 4, 7 7 gold badges 32 32 silver badges 50 50 bronze badges.
Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown.
The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Linked 1. Related 5. Hot Network Questions. Question feed.
0コメント