Re: Feedback about hybrid SAN snap and rsync'd approach for large systemcloning

[Laurenz Albe]

On Tue, 2022-04-12 at 18:07 -0500, Jerry Sievers wrote:
> Suppose we have a DB cluster with an additional tablespace and we are
> able to make an atomic SAN snapshot of *only* the main cluster
> volume...
> 
> The additional tablespace contains only UNLOGGED relations.
> 
> We cannot snap that volume so we use rsync as follows...
> 
> 1. pg_start_backup('foo');
> make SAN snapshot
> rsync the add'l tablespace
> pg_stop_backup()
> 
> Now provision a new cluster around the snapshot and rsync'd volume,
> rejigger the pg_tblspc link if necessary... and start it up maybe or
> not having it remain as a streaming replica.
> 
> It's been my experience that possibly bulky data in the additional
> tablespace does *not* need be rsync'd if we capture only the *_init
> files.
> 
> Id' be curious to here feedback re the sanity of this approach.

I thought that an unlogged table is rendered empty by recovery,
but perhaps I misunderstood what you are doing.

Yours,
Laurenz Albe

RE: OpenSSL@1.1 not getting linked with Homebrew - trying to install postgresql

[cecile rougnaux]

Hello Adrian,

As suggested from another user, I am going to reinstall and upgrade my OS to 
Catalina, which is better supported.
Then I will follow the steps with homebrew and hopefully this will clean the 
mess I am in 😉
Thanks for your answer!
C

De : Adrian Ho 
Envoyé : mercredi 13 avril 2022 06:16
À : pgsql-general@lists.postgresql.org 
Objet : Re: OpenSSL@1.1 not getting linked with Homebrew - trying to install 
postgresql

On 12/4/22 18:33, cecile rougnaux wrote:
My system is OS Mojave 10.14.6, I got homebrew from this command :

 /bin/bash -c "$(curl -fsSL 
https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"

when I try to install postgresql with the command
brew install postgresql

I have this error:

Error: An exception occurred within a child process:
  RuntimeError: /usr/local/opt/openssl@1.1 not present or broken
Please reinstall openssl@1.1. Sorry :(

When I try to install openssl@1.1 I have this message:


Note that the error message is literally asking you to:


brew reinstall openssl@1.1


not:


brew install openssl@1.1


and not:


brew reinstall openssl


Do the reinstall and see if the postgresql formula works now. If it still 
doesn't work, the Homebrew discussions forum is a more appropriate place to 
follow up: https://github.com/Homebrew/discussions/discussions


Also:


brew link openssl@1.1


and all the exports you said you added to your .zshrc should not be needed, so 
you should:


brew unlink openssl@1.1


and revert all your additions.


--
Best Regards,
Adrian