Thread: PgBackRest custom compiled postgres server

PgBackRest custom compiled postgres server

From
Gokan Atmaca
Date:
Hello

I want to backup from custom compiled postgres database. But I am
getting an error as below. This database does not work with the
default "postgres" user. That's why I added the "pg1-host-user"
parameter. However, I am still getting the error as below.  A
specially compiled postgres server always asks for a password when
connecting. (for example when connecting: pgsql -U custom_username
postgres)

Is there a variable like "pg1-host-pass"?


error:
pgbackrest --stanza=customdb1 stanza-create

WARN: unable to check pg-1: [DbConnectError] unable to connect to
'dbname='postgres' port=5432': fe_sendauth: no password supplied
ERROR: [056]: unable to find primary cluster - cannot proceed

Thanks.

--
⢀⣴⠾⠻⢶⣦⠀
⣾⠁⢠⠒⠀⣿⡁ Debian - The universal operating system
⢿⡄⠘⠷⠚⠋⠀ https://www.debian.org
⠈⠳⣄⠀⠀⠀⠀



Re: PgBackRest custom compiled postgres server

From
Gokan Atmaca
Date:
> Is there a variable like "pg1-host-pass"?
I did. I added ".pgpass" for the password. Pgbackrest was able to get a backup.

stanza: postgres1
    status: ok
    cipher: none

    db (current)
        wal archive min/max (11):
000000010000000000000001/00000001000000000000000D

        full backup: 20210920-155236F
            timestamp start/stop: 2021-09-20 15:52:36 / 2021-09-20 15:52:43
            wal start/stop: 00000001000000000000000D / 00000001000000000000000D
            database size: 23.1MB, database backup size: 23.1MB
            repo1: backup set size: 2.7MB, backup size: 2.7MB

On Mon, Sep 20, 2021 at 3:54 PM Gokan Atmaca <linux.gokan@gmail.com> wrote:
>
> Hello
>
> I want to backup from custom compiled postgres database. But I am
> getting an error as below. This database does not work with the
> default "postgres" user. That's why I added the "pg1-host-user"
> parameter. However, I am still getting the error as below.  A
> specially compiled postgres server always asks for a password when
> connecting. (for example when connecting: pgsql -U custom_username
> postgres)
>
> Is there a variable like "pg1-host-pass"?
>
>
> error:
> pgbackrest --stanza=customdb1 stanza-create
>
> WARN: unable to check pg-1: [DbConnectError] unable to connect to
> 'dbname='postgres' port=5432': fe_sendauth: no password supplied
> ERROR: [056]: unable to find primary cluster - cannot proceed
>
> Thanks.
>
> --
> ⢀⣴⠾⠻⢶⣦⠀
> ⣾⠁⢠⠒⠀⣿⡁ Debian - The universal operating system
> ⢿⡄⠘⠷⠚⠋⠀ https://www.debian.org
> ⠈⠳⣄⠀⠀⠀⠀