PostGres

This implementation connects to a Postgres datastore.

Artifact

<artifact>
    <groupId>com.incadencecorp.coalesce</groupId>
    <artifactId>coalesce-framework-persister-postgresql</artifactId>
    <version>...</version>
</artifact>

Blueprint Example

Feature

persister-postgres-feature

Bean

<bean id="postgres" 
    class="com.incadencecorp.coalesce.framework.persistance.postgres.PostGreSQLPersistorExt">
    <property name="connectionSettings">
        <bean class="com.incadencecorp.coalesce.framework.persistance.ServerConn">
            <property name="database" value="coalesce" />
            <property name="portNumber" value="5432" />
            <property name="serverName" value="${Server IP}" />
            <property name="user" value="${Username}" />
            <property name="password" value="${Password}" />
        </bean>
    </property>
    <property name="schema" value="coalesce" />
</bean>

Commands

Connect

psql <database> -U <username>

Change Database

\c <databasename>

List Tables

\dt 

Help

\?

Docker

https://hub.docker.com/_/postgres

docker run --name some-postgres -e POSTGRES_PASSWORD=postgres -d postgres