When you run the createdb command, by default, a copy of template1 is created.
Parameter settings end with a semicolon like below. If there is no semicolon, it continues to the next line.
param1 = val1;
I recovered with the base backup and archive log from a PostgreSQL 8.4 environment using the point in time recovery (PITR) function, in the environment of a PostgreSQL 9.0 installation.
When changing the client side character set to UTF 8, as a SQL statement
SET client_encoding = utf 8;
, Or by using the meta command of psql
\set client_encoding = utf 8
, The effect is almost the same.
If you do not specifically specify at the time of termination, the client connected to the database is automatically disconnected and the running transaction is rolled back
Connect to database as administrator user in psql, select pg_start_backup ('label');
After that, make a physical copy of the database cluster with the tar command.
In order to execute the COPY statement, the database administrator authority is required.
Holds various information about objects in the database.
It is defined as a view in the schema named information.
Content is equivalent to system catalog.
It can refer to the table test, but it can not update it.
When you create a new database with CREATE DATABASE, unless specified in the option, template0 is used as a template database.
To create a new template database called template2, add the TEMPLATE option when executing the CREATE DATABASE command.
By default, no users can connect to the template database template0.
Only one database cluster can be created on one server.
Different versions of PostgreSQL server can be used for each database in the database cluster.
© EDUCO (General Incorporated Association Educo) all rights reserved.