PostgreSQL
No edit summary
(Adding template at the end of the page)
Line 11: Line 11:
Install an [[MDrivenServer Summarized|MDrivenServer]] or start MDrivenServerCore, and set Connection Type, and connection string:
Install an [[MDrivenServer Summarized|MDrivenServer]] or start MDrivenServerCore, and set Connection Type, and connection string:
[[File:MDrPostgreSQL.png|none|thumb|566x566px]]
[[File:MDrPostgreSQL.png|none|thumb|566x566px]]
{{Edited|July|12|2024}}

Revision as of 14:47, 10 February 2024

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 9 days ago on 04/29/2024. What links here