Active1 month ago
Maintainer: Dave Page. PgAdmin is available for Windows™ 7 SP1 (desktop) or 2008R2 (server) and above. The packages below include both the Desktop Runtime and Web Application: pgAdmin 4 v3.2 (released Aug. 9, 2018) pgAdmin 4 v3.1 (released June 28, 2018) pgAdmin 4 v3.0 (released April 13, 2018) pgAdmin 4 v2.1 (released Jan. PostgreSQL is a product developed by Marc Ligyanage.This site is not directly affiliated with Marc Ligyanage.All trademarks, registered trademarks, product names and company names or logos mentioned herein are the property of their respective owners.
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_name334k5555 gold badges519519 silver badges613613 bronze badges
SeanSean
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?
Community♦
a_horse_with_no_namea_horse_with_no_name334k5555 gold badges519519 silver badges613613 bronze badges
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 Biegeleisen276k1414 gold badges122122 silver badges185185 bronze badges
Santosh PatelSantosh Patel
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.
ALWANALWAN
If you have installed postgres via the Windows installer you can start it in Services like so:
Matthew LockMatthew Lock8,61977 gold badges6868 silver badges113113 bronze badges
Postgresql 10.3 Windows
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)
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 Chaturvedi77311 gold badge99 silver badges2424 bronze badges
Postgresql
I found using
net start postgres_service_name
the only reliable way to operate Postgres on Windows
Tomasz PlonkaTomasz Plonka
Remove Postmaster file in 'C:Program FilesPostgreSQL9.6data'
and restart the PostgreSQL services
Kathir MKathir M
Postgresql Windows 10 Odbc
Not the answer you're looking for? Browse other questions tagged postgresql or ask your own question.
Hi,
As you’re facing issue with the Deleting the account, we would surely assist you.
Before I assist you, I would like to know the below information.
- Is it a Microsoft account or a Local account you are trying to delete.
Method 1: Let’s Try the following steps to delete a Microsoft account from the Control Panel.
- Right click on the Start button and select the Control Panel.
- Click on the User Accounts and Click on the Manage another account link.
- If prompted by UAC, click on Yes.
- Click on a user account which you want to delete.
- Click on the Delete the account link.
- Click on Delete Files or Keep Files for what you want to do with the user account's personal files.
- Click on Delete Account to confirm.
- When finished, you can close the Control Panel if you like
Note: You must be signed in as an administrator to be able to delete a user account. You will not be able to delete a user account that is currently signed in. You will need to sign out the user first. Be sure to always have at least one enabled administrator account on the PC to avoid not being able to perform actions that require administrator rights.
Method 2: Let’s try the following steps to delete a Local account from the “netplwiz”
When you want to delete a user account from your computer:
- You must be signed in as an administrator to be able to delete a user account.
- You will not be able to delete a user account that is currently signed in. You will need to sign out the user first.
- Be sure to always have at least one enabled administrator account on the PC to avoid not being able to perform actions that require administrator rights.
Step 1: Steps to Remove a User Account in Settings
- Press Windows key, click on Settings.
- Click on Account, click on Family and other users.
- Select the user you want to delete under Other users and click on Remove.
- Accept the UAC (User Account Control) prompt.
- Select Delete account and data if you wish to delete account and the data.
OR
Step 2: Steps to Delete a User Account in Command Prompt
- Press Windows + X keys from the keyboard, select Command Prompt (Admin).
- Type net user and hit Enter to list the user accounts on your device.
- Type net user 'User account”/delete and hit Enter to delete the user account.
Hope it helps. Reply to the post with an updated status of this issue and required information, we will be happy to help you accordingly.
Thank you.