PostgreSQL
No edit summary
No edit summary
Line 4: Line 4:
#* Register server, localhost:5432  
#* Register server, localhost:5432  
#* Create Database, First
#* Create Database, First
# C:\Program Files\PostgreSQL\16\ run pg_env.bat  
# run  C:\Program Files\PostgreSQL\16\pg_env.bat  
# C:\Program Files\PostgreSQL\16\bin>psql.exe dbname=First (case sensitive)
# C:\Program Files\PostgreSQL\16\bin>psql.exe dbname=First (case sensitive)
#* Just make sure it works...
#* Just make sure it works...

Revision as of 17:19, 25 October 2023

PostgreSQL

  1. Install, remember pwd,
  2. C:\Program Files\PostgreSQL\16\pgAdmin 4\runtime>pgAdmin4.exe
    • Register server, localhost:5432
    • Create Database, First
  3. run C:\Program Files\PostgreSQL\16\pg_env.bat
  4. C:\Program Files\PostgreSQL\16\bin>psql.exe dbname=First (case sensitive)
    • Just make sure it works...
  5. Connectionstring takes this form: host=localhost port=5432 dbname=First user=postgres password=xxxxxxx sslmode=prefer connect_timeout=10
  6. Server=localhost;Port=5432;User Id=postgres;Password=<yourpwd>;Database=First;Include Error Detail=True

Install an MDrivenServer or start MDrivenServerCore, and set Connection Type, and connection string:

MDrPostgreSQL.png
This page was edited 4 days ago on 04/29/2024. What links here