EDB Database creation Process Guide

1.1 Creating an EDB database with tools

1.1.1 Open Postgres Enterprise Manager tool, connect to EDB server

1.1.2 Open Connection

1.1.3 New Login User

1.1.4 jianxin Database Rico, if you need to create a new tablespace, please refer to section 1.3 of this article, and then select the new table space in the Definition tab (in the following two images, select the built-in table space in the tablespace)

1.1.5 Open Rico Database, build new schema

1.1.6 schema Rico was built.

1.1.7 with Navicat Premium login Rico Database

1.2 Creating an EDB database using SQL commands

1.2.1 Connect to EDB server using the SSH tool and cut to the installation directory of the EDB server. /bin under

1.2.2 Create role and user (assign login permissions when creating role, the system will automatically create users with the same name)

1.2.3 Execute./edb-psql in the bin directory, if "..." appears. Does not exist ", create a new database enterprisedb, if there is no error, skip to section 1.2.5

1.2.4 Create a new database enterprisedb, use the script to help you ./createdb --help view

1.2.5 Execute./edb-psql in the Bin directory, enter the default database Enterprisedb

1.2.6 \l command to view all databases

1.2.7 View the previously created role and user

1.2.8 Start creating a tablespace (if you use the default tablespace, you do not need to create a new tablespace, skip to 1th. 2.10 steps), refer to section 1.3 of this article, creating a Tablespace folder/opt/edbdata and setting permissions

1.2.9 cut to Enterprisedb user, and enter Edb-psql, run create tablespace "ricodata" Location '/opt/edbdata ';

1.2.10 start creating the database Rico./createdb -D RicoDATA -O rico rico

1.2.11 Enter EDB-PDQL (./edb-pslq) to view all database information

1.2.12 Use EDB-PSLQ to enter the RICO database, create a new schema (Rico) create SCHEMA Rico AUTHORIZATION Rico

1.3 New Enterprisedb Table space

1.3.1 with root user to opt directory, new table space directory Edbdata,mkdir edbdata

1.3.2 Assign permissions to Edbdata chmod 760/opt/edbdata

1.3.3 Enable Edbdata to have read and write permissions for enterprisedb users   chown-r enterprisedb:enterprisedb/opt/edbdata

1.3.4 using PEM (Postgres Enterprise Manager) to connect to EDB server, create a new table space

1.3.5 you have built a table space, you can choose a new table space when you create a new database Edbdata

1.4 Easy to confuse enterprisedb password

1.4.1 Sometimes, may forget the Enterprisedb account password, or need to modify the Enterprisedb account password, the following for you to introduce the Enterprisedb password modification process (login Linux server password, operation EDB Database dba password for server)
1.4.2 Modify the password of the Enterprisedb login Linux server: Use SSH tool to connect to the Linux server installed by EDB server, need root permission, then enter passwd enterprisedb and press ENTER to confirm, You can modify the password of the Enterprisedb login Linux Server

1.4.3 Modify the DBA password of the enterprisedb operation EDB Server (set when Edbserver is installed):
Using the SSH tool to connect to the Linux server installed by EDB server, if logged in as root, you need to cut to the Enterprisedb user and then go to the bin directory of the EDB server installation directory and use the./edb-psql EDB cut to interactive command mode with EDB database, input alter user enterprisedb with password ' admin1 ', last input \q exit

If you modify the Enterprisedb operation database dba password, enter the./edb-psql EDB error in the bin directory as follows, because the modified Enterprisedb user password is not updated in the. pgpass file

You only need to modify the connection password (Vi. pgpass) of the EDB database.

EDB Database creation Process Guide