pg_ctl.exe restart -D "C:\Program Files\PostgreSQL\9.6\data"

pg_ctl.exe restart -D "<path upto data>"

postgresql-9.3.3-1-windows-x64.exe --unattendedmodeui minimal --mode unattended --superpassword "password" --servicename "postgreSQL"
--servicepassword "password" --serverport 5432

To install and use PostgreSQL on Windows, you can follow these steps:
1. Download the PostgreSQL installer for Windows from the official website: https://www.postgresql.org/download/windows/
2. Run the installer and choose the installation directory.
3. During the installation, you will be prompted to set a password for the default PostgreSQL user 'postgres'. Choose a strong password and remember it.
4. After the installation is complete, you can open the pgAdmin tool, which is a graphical interface for managing PostgreSQL databases.
5. To create a new database, right-click on 'Databases' in the Object browser and select 'Create' > 'Database'. Give your database a name and configure any additional options.
6. To connect to the PostgreSQL database, you can use a programming language like Python. Here's an example using the psycopg2 library: import psycopg2 # Connect to PostgreSQL conn = psycopg2.connect( host="localhost", port="5432", database="your_database", user="postgres", password="your_password" ) # Execute a query cursor = conn.cursor() cursor.execute("SELECT * FROM your_table") results = cursor.fetchall() # Print the results for row in results: print(row) # Close the connection cursor.close() conn.close()
Make sure to replace "your_database" with the actual name of your database, and "your_password" with the password you set during the installation.
Happy coding!