Server

What is a database server?

A database server allows multiple local or remote clients to connect to the same database. You start a database server process on a host. The database server process opens a port or socket and then clients connect with a compatible client. The database server handles authentication.

How to use database servers

Database servers are used to allow multiple users to access the same database over a network. Database servers are often used to back applications. In that case, the application instances are the user.

Difference between the Postgres database server and the Doltgres database server

Doltgres behaves the same way as the Postgres database server started using postgres. By default, Doltgres starts on the same port as Postgres, 5432.

Interaction with Doltgres Version Control

Doltgres allows users to connect to multiple branches using a connection string. All users connected to the same branch see the same branch state.

Example

Start a Server

doltgres
Starting server with Config HP="localhost:3306"|T="28800000"|R="false"|L="info"

Connect a client

PGPASSWORD=password psql -h 127.0.0.1 -U postgres