Documentation:PostgreSQL: Difference between revisions

PostgreSQL

Latest revision as of 06:38, 29 April 2024

PostgreSQL

Install, remember pwd,
C:\Program Files\PostgreSQL\16\pgAdmin 4\runtime>pgAdmin4.exe
- Register server, localhost:5432
- Create Database, First
Run C:\Program Files\PostgreSQL\16\pg_env.bat
C:\Program Files\PostgreSQL\16\bin>psql.exe dbname=First (case sensitive)
- Just make sure it works...
Connectionstring takes this form:
1. 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:

This page was edited more than 8 months ago on 04/29/2024. What links here

@@ Line 1: / Line 1: @@
 PostgreSQL
-* - Install, remember pwd,
+# Install, remember pwd,
-* - C:\Program Files\PostgreSQL\16\pgAdmin 4\runtime>pgAdmin4.exe
+# C:\Program Files\PostgreSQL\16\pgAdmin 4\runtime>pgAdmin4.exe
-** - 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 sensistive)
+# C:\Program Files\PostgreSQL\16\bin>psql.exe dbname=First (case sensitive)
-** just make sure it works...
+#* Just make sure it works...
-* - Connectionstring takes this form: host=localhost port=5432 dbname=First user=postgres password=xxxxxxx sslmode=prefer connect_timeout=10
+# Connectionstring takes this form:
-* - Server=localhost;Port=5432;User Id=postgres;Password=<yourpwd>;Database=First;Include Error Detail=True
+## Server=localhost;Port=5432;User Id=postgres;Password=<yourpwd>;Database=First;Include Error Detail=True
 Install an [[MDrivenServer Summarized|MDrivenServer]] or start MDrivenServerCore, and set Connection Type, and connection string:
 [[File:MDrPostgreSQL.png|none|thumb|566x566px]]
+{{Edited|July|12|2024}}
+[[Category:MDriven Server]]