NMDA: Falha no backup Postgres: não foi possível conectar ao banco de dados 'template1'

Summary: Falha no backup do Postgres do NMDA com "couldn_connect to database "template1": could not connect to server"

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms

Falha no backup Postgres do NetWorker Module for Database Applications (NMD) com "couldn_connect to database "template1": could not connect to server"

Backup Error:  
The command '/usr/bin/nwbackup.sh' did not complete successfully. Exit code: 1. Error: + /usr/local/pgsql/bin/pg_dumpall --file=/nsr/apps/tmp/<random numbers>/<sql script>

pg_dumpall: error: could not connect to database "template1": could not connect to server: No such file or directory

Cause

A credencial do usuário não foi definida corretamente no ambiente Postgres.

Resolution

Atualize o script de backup do NMDA para incluir o nome de usuário, o nome do banco de dados e o endereço IP do servidor Postgres.

Roteiro original:

#! /bin/sh
( set -x; /usr/local/pgsql/bin/pg_dumpall --file=$OAPP_MOUNT_DIR/<sql script>)
rc=$?


Script revisado:

#! /bin/sh
( set -x; /usr/local/pgsql/bin/pg_dump -U <user> <database name> -h <Postgres server IP>  --file=$OAPP_MOUNT_DIR/gepdba.sql)
rc=$?
Article Properties
Article Number: 000220603
Article Type: Solution
Last Modified: 29 Oct 2024
Version:  1
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.