"Editor's note" as an open source object-relational database, Postgres has been loved by many developers. Recently, Postgres officially released version 9.5, which has been a lot of repair and functional improvements. This article will share 10
Recently, I have been working on a project related to PostgreSQL database, documenting the knowledge that I have learned in this process. About PostgreSQL database online already have too many relevant introduction, in order to blog the system or
Postgres is a very good open-source database. Good performance.
When it comes to databases, there's the topic of backup and import.
Backups are also broken down in a number of ways.
1. Full backup
This is the way most people use it to back up the
Reference: https://hub.docker.com/_/postgres/https://docs.docker.com/engine/installation/debian/Using Docker for multi-instance installation is simpler, more convenient, and better isolated than the source code.Installing Docker
Update the
Basic concepts:
Container
Container. Each container can be viewed as a standalone host. The creation of container usually has an image as its template. Analogy to a virtual machine can be understood as image is the mirror of the
Original link: https://my.oschina.net/u/2612999/blog/1036388 Summary: Dockerfile best Practices
While Dockerfile simplifies the process of mirroring building, and it can be versioned, improper Dockerfile use can also cause many problems: The Docker
Step 1: Install Postgresql in Ubuntu
Sudo apt-get install postgresql-8.4 postgresql-client-8.4 postgresql-contrib-8.4Run the preceding command to install psql on the server and command line client.
/Usr/lib/postgresql/8.4/Stores postgresql-related
Make one to mirror and upload it to hub.docker.com. (1) Login to the following URL to register an account namehttps://hub.docker.com/(2) login on the Docker host[[email protected] docker]# docker loginLogin with your Docker ID to push and pull
Docker is an open-source application container engine that allows developers to package their applications and dependencies into a portable container, and then publish them to any popular Linux machine or virtualize them. Since its release in 2013,
Symfoware Open System"Symfoware new instance--instance (each instance uses a folder directory, has its own profile, uses a separate port (default 26500, multiple instance can be configured in the postgresql.conf file))There are several table spaces
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.