About us

Join us FREE!

Postgress Setup

Tutorial by Abhishek connectclue-author-image

All > Technical > Matlab

1 like

Please login to like this article.

connectclue-linkedin-share

1. Download postgress -  ex - version 10 as zip file
 https://www.postgresql.org/download/
 2. unzip postgress. and go to command prompt.
 3. create a folder named data anywhere as ex - "C:\Users\Abhishek\data"
 4. go to bin folder of postgress and run command like below.
    C:\pgsql\bin>set PGDATA=C:\Users\Abhishek\data
5. run -  pg_ctl init
6. run below command
   pg_ctl -D "C:\Users\Abhishek\data" -l logfile start
  7. create user ? and enter password as shown below
   createuser.exe -P -s -e pguser
8. createdb.exe -U "pguser" localdb
 9 connect DB with username and password using pgadmin, HeidiSql.


All review comments

Great!!

Login for enhanced experience

connectclue-tick Create and manage your profile

connectclue-tick Refer an author and get bonus Learn more

connectclue-tick Publish any lost and found belongings

connectclue-tick Connect with the authors & add your review comments

connectclue-tick Join us for Free to advertise for your business or Contact-us for more details

connectclue-tick Join us for Free to publish your own blogs, articles or tutorials and get your Benefits

connectclue-login

Back to top