Logo: Fujitsu and home icon
    Download trial version
    Fujitsu Logo
    ENQUIRE

      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.

      These methods allow batch processing without password input.

      Applicable to

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

      Architecture: X86, S390x

      Operating System: Windows, Linux

      Versions: from 9.5

      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

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

      Applicable to

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

      Architecture: X86, S390x

      Operating System: Windows, Linux

      Versions: from 9.5

      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

      Architecture: X86, S390x

      Operating System: Windows, Linux

      Versions: from 9.5

      Read our latest blogs

      Read our most recent articles regarding all aspects of PostgreSQL and FUJITSU Enterprise Postgres.