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. Active 1 month ago. Viewed k times. Improve this question. Sean Sean 1, 2 2 gold badges 8 8 silver badges 6 6 bronze badges. Thank you. Show 1 more comment. 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. Better solution. Posted by Leo Hsu and Regina Obe in 8. Trackback specific URI for this entry. Weblog: www. Weblog: webdevon. Display comments as Linear Threaded. Thomas, Thanks for the tip. We'll correct. Could you please help me start postgresql without installing it. I have read the post but I didn't understand how to make the batch file.
Sergey, You copy the contents of that script above into notepad or text editor you choose. Then you save the file with a. Then double-click on the. Hi I'm a bit of a nube when it comes to postgresql. I'm struggling a bit to get the script to run Here's what i did. Originally i tried following your directions to the letter, so I dowlnoaded the binaries, and I made a bat file and copied the updated script into it and uncommented the necessary line.
I ran the script and it complained a bit. So I removed the extra slashes and continued. I also created bin and data directories. It still complains that it cant find the path specified for the log file. I was wondering if I'm supposed to create the log file separately and point the script at it somehow?
It looks like this is the only part that doesn't work but i would really like a log file. Any assistance would be greatly appreciated. Hi I followed your directions exactly and things aren't going according to plan.
I'm pretty inexperienced when it comes to batch files and Postgresql so it could be that i'm just being silly The postgres program also takes a number of other command-line options. For more information, see the postgres reference page and Chapter 18 below.
This shell syntax can get tedious quickly. For example:. The -D option has the same meaning here as for postgres. Normally, you will want to start the database server when the computer boots. Autostart scripts are operating-system-specific. Installing one will require root privileges.
Different systems have different conventions for starting up daemons at boot time. Others use init. Whatever you do, the server must be run by the PostgreSQL user account and not by root or any other user.
Therefore you probably should form your commands using su postgres -c ' Here are a few more operating-system-specific suggestions. In each case be sure to use the proper installation directory and user name where we show generic values.
0コメント