Re: PgBackRest custom compiled postgres server

Поиск
Список
Период
Сортировка
От Gokan Atmaca
Тема Re: PgBackRest custom compiled postgres server
Дата
Msg-id CAHg8tEAw4OnH1xzS=cCHh2gg33m=7sP98MctY8iY9L0X0uKt2Q@mail.gmail.com
обсуждение исходный текст
Ответ на PgBackRest custom compiled postgres server  (Gokan Atmaca <linux.gokan@gmail.com>)
Список 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.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
> ⠈⠳⣄⠀⠀⠀⠀



В списке pgsql-admin по дате отправления:

Предыдущее
От: Gokan Atmaca
Дата:
Сообщение: PgBackRest custom compiled postgres server
Следующее
От: satish v
Дата:
Сообщение: Autovacuum on toast tables