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.
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.
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 33 - libpq-C library > 33.15 - The password file.
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 20 - Client authentication > 20.1 pg_hba.conf file.
These methods allow batch processing without password input.
Product: Fujitsu Enterprise Postgres SE, Fujitsu Enterprise Postgres AE, PostgreSQL
Architecture: X86, S390x
Operating System: Windows, Linux
Versions: from 9.5
Fujitsu Enterprise Postgres databases can be backed up and recovered in the following ways, both of which can be performed without stopping the database:
It's also possible to back up the database without stopping it using PostgreSQL pg_dump.
Product: Fujitsu Enterprise Postgres SE, Fujitsu Enterprise Postgres AE, PostgreSQL
Architecture: X86, S390x
Operating System: Windows, Linux
Versions: from 9.5
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.
Product: Fujitsu Enterprise Postgres SE, Fujitsu Enterprise Postgres AE, PostgreSQL
Architecture: X86, S390x
Operating System: Windows, Linux
Versions: from 9.5
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.)
Product: Fujitsu Enterprise Postgres AE, PostgreSQL
Architecture: X86, S390x
Operating System: Windows, Linux
Versions: from 9.6
You will need at least twice the amount of space used by the instance.
Product: Fujitsu Enterprise Postgres AE, PostgreSQL
Architecture: X86, S390x
Operating System: Windows, Linux
Versions: from 9.5
Read our most recent articles regarding all aspects of PostgreSQL and FUJITSU Enterprise Postgres.