4/5/2023 0 Comments Mac psequel list database![]() įor a tool like PgAdmin you can define your connection. Now you can connect with your database using \c. ![]() postgres=# \l List of databases Name | Owner | Encoding | Collate | Ctype | - - - - - mytestdb | postgres | UTF8 | en_US.utf8 | en_US.utf8 | postgres | postgres | UTF8 | en_US.utf8 | en_US.utf8 | template0 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | | | | | | template1 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | | | | | | (4 rows)Īfter authenticating you will see the mytestdb is in the list of available databases. $ psql -h localhost -p 5432 -U postgres -W Password for user postgres: psql (9.5.5, server 10.3 (Debian 10.3-1.pgdg90 1)) WARNING: psql major version 9.5, server major version 10. (For Windows docker-machine you probably need to use 192.168.99.100). If it is running on a specific server, use your server IP. My PostgreSQL container is running on my local machine, which explains why I am connecting with localhost. Here you need some PostgreSQL Client tool installed: You can exit your container ( \q) and go to your local machine. postgres=# CREATE DATABASE mytestdb CREATE DATABASE postgres=#\q psql -U postgres psql (10.3 (Debian 10.3-1.pgdg90 1)) Type "help" for help. We can access postgres and create the database. We will create a database inside our PostgreSQL container. Port 5432 of our container will be mapped on port 5432 of our host or server.Īccess the container on your host or server. This command will start a PostgreSQL database and map ports using the following pattern: -p. With the following command it is possible to start your PostgreSQL Docker container on your server or local machine: $ docker run -d -p 5432:5432 -name my-postgres -e POSTGRES_PASSWORD=mysecretpassword postgres Docker makes it very easy to spin up a PostgreSQL database management system.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |