Knowledge articles - Backup/Recovery

I created a batch to run the backup command pgx_dmpall and attempted to run it automatically, but I am prompted for a password which prevents me from automatic execution. What is the cause and how can I run the command automatically?KB1001

This happened because the user did not add the -w option or the --no-password option to pgx_dmpall. By using these options, the user won't be prompted for a password.

For details refer to Fujitsu Enterprise Postgres Reference Guide > Chapter 3 - Server commands > 3.2 - pgx_dmpall.

Resolution

Run pgx_dmpall with the -w option or the --no-password option. If either is used, one of the following configuration must also be in place.

Using the pgpass.conf
Write the password in the %APPDATA%\postgresql\pgpass.conf file (where %APPDATA% refers to the Application Data subdirectory in the user's profile).

For details, refer to PostgreSQL documentation > Part IV - Client interfaces > Chapter 34 - libpq-C library > 34.16 - The password file.
Using the password file pg_hba.conf
Specify "trust" in the "auth-method" field of the pg_hba.conf file in the data directory for the database cluster.

For details, refer to PostgreSQL documentation > Part III - Server administration > Chapter 21 - Client authentication > 21.1 pg_hba.conf file.

These methods allow batch processing without password input.

Applicable to

Product: Fujitsu Enterprise Postgres SE, Fujitsu Enterprise Postgres AE, PostgreSQL

Versions: from 9.5

Architecture: X86, S390x

Operating System: Windows, Linux

How do I perform an online database backup and restore which ensures data consistency with no system disruption?KB1002

Fujitsu Enterprise Postgres databases can be backed up and recovered in the following ways, both of which can be performed without stopping the database:

Using WebAdmin for backup and recovery
Using pgx_dmpall for backup and pgx_rcvall for recovery

For more information and precautions on these backup methods, refer to Fujitsu Enterprise Postgres Operation Guide > Chapter 3 - Backing up the database [Linux version] [Windows version].

For information on how to recover after backup using these methods, refer to the following in Fujitsu Enterprise Postgres Operation Guide > Chapter 15 - Actions when an error occurs [Linux version] [Windows version]:

It's also possible to back up the database without stopping it using PostgreSQL pg_dump.

For more information on these backup methods, refer to PostgreSQL documentation > Part III - Server administration > Chapter 26 - Backup and restore.

Applicable to

Product: Fujitsu Enterprise Postgres SE, Fujitsu Enterprise Postgres AE, PostgreSQL

Versions: from 9.5

Architecture: X86, S390x

Operating System: Windows, Linux

I am planning to copy an online backup made using pgx_dmpall to a network drive or external storage to store it while the database is running. Are there any folders in the backup destination that I should exclude when copying the content?KB1003

pgx_dmpall saves backup files to the directory set in backup_destination in postgresql.conf, so when saving the contents of the backup directory to another location, make sure you save all content of this backup directory.

When restoring, restore the content of the backup directory to the same state as the source.

For details on pgx_dmpall, refer to Fujitsu Enterprise Postgres Reference Guide > Chapter 3 - Server commands > 3.2 - pgx_dmpall.

Applicable to

Product: Fujitsu Enterprise Postgres SE, Fujitsu Enterprise Postgres AE, PostgreSQL

Versions: from 9.5

Architecture: X86, S390x

Operating System: Windows, Linux

How do I implement real-time WAL backups?KB1004

In postgresql.conf, enable WAL archiving by setting wal_level, archive_mode, and archive_command parameters as follows:

wal_level = replica (or, when using logical replication, set to logical)

archive_mode = on

archive_command = 'cp %p <archive directory path>/%f'

(Note that in releases prior to 9.6, wal_level parameter also allowed the values archive and hot_standby. These are still accepted but mapped to replica.)

Applicable to

Product: Fujitsu Enterprise Postgres AE, PostgreSQL

Versions: from 9.6

Architecture: X86, S390x

Operating System: Windows, Linux

How much storage space will be required to execute pg_basebackup on the same server?KB1005

You will need at least twice the amount of space used by the instance.

Applicable to

Product: Fujitsu Enterprise Postgres AE, PostgreSQL

Versions: from 9.5

Architecture: X86, S390x

Operating System: Windows, Linux

Fujitsu Knowledge Base

Knowledge articles
Backup/Recovery