About
A default howto postgres connection is provided after a fresh installation that is used in the howto's. To use this connection, you need to start the docker image
Docker
Download and run the image
This connection is based on the Official Postgres Docker image.
- You can download and start the image with the following command:
docker run \
-e POSTGRES_PASSWORD=welcome \
-p 5432:5432 \
-d \
--name postgres \
postgres:9.5
docker run ^
-e POSTGRES_PASSWORD=welcome ^
-p 5432:5432 ^
-d ^
--name postgres ^
postgres:9.5
- Ping your connection to check that the database is up.
tabli connection ping postgres
The connection (postgres) has been pinged successfully
Start / Stop
You can then start and stop the image with the following command:
docker stop postgres
docker start postgres
Info
tabli connection info postgres
Information about the connection (postgres)
Attribute Value Description
---------------------- ----------------------------------------- --------------------------------------------------------------------
Comment The default postgres data store A connection description
DatabaseMajorVersion 9 The major version number of the database
DatabaseMinorVersion 5 The minor version number of the database
DatabaseProductName PostgreSQL The name of the database
DatabaseProductVersion 9.5.23 The version of the database
Driver org.postgresql.Driver The driver class
Driver org.postgresql.Driver The driver class
DriverName PostgreSQL JDBC Driver The driver name
DriverVersion 42.2.16 The driver version
JdbcMajorVersion 4 The major version number of JDBC
JdbcMinorVersion 2 The minor version number of JDBC
MaxConcurrentThread 8192 The maximum number of threads that can be created against the system
MaxNameInPath 3 The maximum number of names in a path
Name postgres The name of the connection
Password xxxxxxxxx The user password to login
SupportBatchUpdates true If the system supports batch SQL updates
SupportNamedParameters false If the system supports named parameters in the SQL statement
TabBooleanDataType Native Boolean data type used to store boolean values
TabDateDataType Native Date data type used to store date values
TabTimeDataType Native Time format data type to store time values
TabTimestampDataType Native Timestamp data type used to store timestamp values
Url jdbc:postgresql://localhost:5432/postgres The url of the connection
User postgres The user name to login