Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Backup from replica #47

Closed
Closed
@windowsisnotos

Description

@windowsisnotos

Hello! How can I backup from replica? I configured max_wal_senders and hot_standby on the replica. Configured on replica and master in pg_hba.conf:
host replication postgres 0.0.0.0/0 trust
On the master included full_page_writes.

When trying to backup from a replica with the command:
pg_probackup backup -B / data / pgsql / backup --instance pgsql-02 -b FULL -j 4 --master-host = pgsql-02 --master-db = postgres --master-user = postgres --master-port = 5432

I get the error message:

ERROR: WAL segment 000000020000000400000063 could not be archived in 300 seconds

If I specify the IP instead of the name in --master-host, the program will ask for the password forever (although I successfully connect from this machine using psql).

If I delete recovery.conf and run the command:
pg_probackup backup -B / data / pgsql / backup --instance pgsql-02 -b FULL -j 4
The backup will be successfully created.

archive_command on the replica and on the wizard (at the moment backup is configured on the master):

/usr/pgpro-9.6/bin/pg_probackup archive-push -B / data / pgsql / backup --instance pgsql-02 --wal-file-path% p --wal-file-name% f

How should I set up the server in order to successfully make a backup from the replica?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions


      [8]ページ先頭

      ©2009-2025 Movatter.jp