public inbox for [email protected]  

help / color / mirror / Atom feed

From: Stephen Frost <[email protected]>
To: [email protected]
Cc: [email protected]
Subject: Re: Pgbackrest - conflict between 'main' and 'demo'
Date: Thu, 5 Mar 2020 13:33:06 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <7732d309470ed3447b26f5420fc54866.squirrel@danielas3rtn54uwmofdo3x2bsdifr47huasnmbgqzfrec5ubupvtpid.onion>
References: <7732d309470ed3447b26f5420fc54866.squirrel@danielas3rtn54uwmofdo3x2bsdifr47huasnmbgqzfrec5ubupvtpid.onion>

Greetings,

* [email protected] ([email protected]) wrote:
> This is a 'pgbackrest' question. Please let me know if this is not the
> correct group for such a query.
> 
> I am attempting to follow the guide
> (https://pgbackrest.org/user-guide.html) which creates a 'demo' cluster
> and then configures it.
> 
> Everything is fine until I run: sudo -u postgres pgbackrest --stanza=demo
> --log-level-console=info stanza-create
> 
> The error is:
> 
> INFO: stanza-create command begin 2.25dev: --log-level-console=info
> --pg1-path=/var/lib/postgresql/10/demo --repo1-path=/var/lib/pgbackrest
> --stanza=demo
> ERROR: [058]: version '10' and path '/var/lib/postgresql/10/main' queried
> from cluster do not match version '10' and '/var/lib/postgresql/10/demo'
> read from '/var/lib/postgresql/10/demo/global/pg_control'
> HINT: the pg1-path and pg1-port settings likely reference different clusters.
> INFO: stanza-create command end: aborted with exception [058]
> 
> I don't understand how to edit the "read from cluster" in order to set it
> to /var/lib/postgresql/10/demo
> 
> I have modified every entry in the data_directory in
> /etc/postgresql/10/main/postgresql.conf to point to
> /var/lib/postgresql/10/demo but that didn't change anything.
> 
> My /etc/pgbackrest/pgbackrest.conf shows:
> 
> [demo]
> pg1-path=/var/lib/postgresql/10/demo
> 
> [global]
> repo1-path=/var/lib/pgbackrest
> 
> Can anyone please advise me how to fix this error, thanks?

If you log into your PostgreSQL cluster and do 'show data_directory;'
does the result match what you have for pg1-path..?

If you have multiple clusters running on your system (us pg_lsclusters
to check), the issue might be that pgbackrest is connecting to the
default one, which isn't the same as the one that you're trying to do a
backup of.  You can change the port for pgbackrest to match if you need
to.

Thanks,

Stephen


Attachments:

  [application/pgp-signature] signature.asc (819B, ../[email protected]/2-signature.asc)
  download

view thread (3+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Pgbackrest - conflict between 'main' and 'demo'
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox