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
> ⠈⠳⣄⠀⠀⠀⠀
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 |