postgresql pg dump

One, database upgrade 9.4 to 9.51.pg_dump Import and export (used when data volume is small)Postgres User Login$ pg_dumpall > Db_export.out$ env|grep LANGLang=en_us. UTF-8If the database character set is en_US. UTF-8, the system character set is

Initdb will specify a PGDATA directory, which is where PostgresQL stores data, such as:/var/lib/pgsql/10/data.====== Display Data Catalog1. Enter PsqlSudo-u Postgres Psql2. Locate the Data directorypostgres=# SHOW data_directory;Data_directory-------

PostgreSQL physical file ing We know that in PG, each relation, that is, the table, has several fork mappings. "MAIN" fork is used to store the data in the master table, "FSM" fork is used to manage the free space, and "visibility" fork is used to

first, compile and install: Environment Preparation: GNU make version >=3.8 (make--version) Iso/ansi C compiler, at least compatible with C89 standard, GCC or Intel translator, etc. can be gzip, bzip2, tar, source

I. Installation of PhppgadminUnzip the downloaded compressed package For tar.gz, execute the following command: Copy Code code as follows: Gunzip phppgadmin-*.tar.gz TAR-XVF Phppgadmin-*.tar For TAR.BZ2, execute the following

The PHP version of Mamp is compiled without the--enable-debug option, so I'm going to recompile php myself so that I can use GDB to view the core dump file when I do my php extension research. First use the PHP version in Mamp to view Phpinfo ()Got

A view is a database that stores only the query statements that define the view (the content is generated when the query is queried), and the materialized view is a view of the content after its query statement is queried and stored (the content is