Re: PgBackRest custom compiled postgres server

From: Gokan Atmaca <linux(dot)gokan(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: PgBackRest custom compiled postgres server
Date: 2021-09-20 13:03:53
Message-ID: CAHg8tEAw4OnH1xzS=cCHh2gg33m=7sP98MctY8iY9L0X0uKt2Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> 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(dot)gokan(at)gmail(dot)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
> ⠈⠳⣄⠀⠀⠀⠀

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bossart, Nathan 2021-09-21 00:08:22 Re: Estimating HugePages Requirements?
Previous Message Gokan Atmaca 2021-09-20 12:54:30 PgBackRest custom compiled postgres server