• Update Postgresql Windows Update
• Postgresql Update Join

This command conforms to the SQL standard, except that the FROM and RETURNING clauses are PostgreSQL extensions, as is the ability to use WITH with UPDATE. Some other database systems offer a FROM option in which the target table is supposed to be listed again within FROM. That is not how PostgreSQL interprets FROM. Be careful when porting. Interactive installer by EnterpriseDB. This installer includes the PostgreSQL server, pgAdmin; a graphical tool for managing and developing your databases, and StackBuilder; a package manager that can be used to download and install additional PostgreSQL tools and drivers. Stackbuilder includes management, integration, migration, replication, geospatial, connectors and other tools. Install PostgreSQL on Windows. To install PostgreSQL on Windows: Download and run the Windows PostgreSQL one click installer.When the wizard prompts you to choose where to install PostgreSQL, point it to the apps subdirectory of your, i.e. C: labkey apps postgresql-10.6.

I have installed Postgresql on my Windows 10 PC. I have used the pgAdmin II tool to create a database called company, and now I want to start the database server running. I cannot figure out how to do this. I have run the start command on the postgres command line, and nothing seems to happen.

What I doing is:

.....-> I am seeing nothing returned.

a_horse_with_no_name

7 Answers

pg_ctl is a command line (Windows) program not a SQL statement. You need to do that from a cmd.exe. Or use net start postgresql-9.5

If you have installed Postgres through the installer, you should start the Windows service instead of running pg_ctl manually, e.g. using:

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

I have used the pgAdmin II tool to create a database called company

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?

Update Postgresql Windows Update

a_horse_with_no_namea_horse_with_no_name

Go inside bin folder in C drive where Postgres is installed.run following command in git bash or Command prompt:

Ex:

Another way:type 'services.msc' in run popup(windows + R).This will show all services runningSelect Postgres service from list and click on start/stop/restart.

Thanks

Tim Biegeleisen

After a lot of search and tests i found the solution : if you are in windows :

1 - first you must found the PG databases directory execute the command as sql command in pgAdmin query tools

result :

2 - go to the bin directory of postgres in my case it's located 'c:/programms/postgresSql/bin'

and open a command prompt (CMD) and execute this command :

This should do it.

If you have installed postgres via the Windows installer you can start it in Services like so:

Matthew LockMatthew Lock

If you are getting an error 'psql.exe' is not recognized as an internal or external command,... '

There can be :Causes

• System is unable to find the psql.exe tool, because the path to this tool is not specified in the system environment variable PATH

or - PostgreSQL Database client not installed on your PC

Since you have already installed PostgreSQL the latter can not be the issue(assuming everything is installed as expected)

Postgresql Update Join

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.'

For example

Path: 'C:Program FilesPostgreSQL10bin'

Nandan ChaturvediNandan Chaturvedi

I found using

net start postgres_service_name

the only reliable way to operate Postgres on Windows

Remove Postmaster file in 'C:Program FilesPostgreSQL9.6data'

and restart the PostgreSQL services

Not the answer you're looking for? Browse other questions tagged postgresql or ask your own question.