Content-Type: multipart/alternative;
 boundary="------------GlI8xo6bii1EWHzKA0NDdnPn"
Message-ID: <5dc88f2c-c806-4ff1-aa9e-64cc7378278f@cloud.gatewaynet.com>
Date: Sun, 12 May 2024 10:39:29 +0300
MIME-Version: 1.0
Subject: Re: PostgreSQL on netapp AFF C250A storage ?
To: pgsql-admin@lists.postgresql.org
References: <91a6f140-e3bb-f7d5-5bce-9b89d05a43ff@cloud.gatewaynet.com>
 <20934d7e-e093-41e6-95d5-7868f3ee200c@cloud.gatewaynet.com>
 <CANzqJaC+XJYceGASAqqbv8kH5=j1nN35C+v65jmQCfY1JLty4Q@mail.gmail.com>
Content-Language: en-US
From: Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
In-Reply-To: 
 <CANzqJaC+XJYceGASAqqbv8kH5=j1nN35C+v65jmQCfY1JLty4Q@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/5dc88f2c-c806-4ff1-aa9e-64cc7378278f%40cloud.gatewaynet.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------GlI8xo6bii1EWHzKA0NDdnPn
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Στις 11/5/24 16:05, ο/η Ron Johnson έγραψε:
> On Sat, May 11, 2024 at 4:24 AM Achilleas Mantzios 
> <a.mantzios@cloud.gatewaynet.com> wrote:
>
>     Στις 10/5/24 14:30, ο/η Achilleas Mantzios - cloud έγραψε:
>     > Hello All
>     >
>     > Has anyone run PostgreSQL on netapp AFF C250A storage ? Have you
>     run
>     > into any problems regarding reliability or performance ?
>     >
>     > Thank you
>     >
>     Just to make our situation more clear, we are thinking about
>     moving from
>     cloud to premise again, for the moment this is just a long term
>     vision.
>     So nothing is cemented, but we have purchased a couple of those
>     systems
>     already so I'd like to know your general experience with running
>     PostgreSQL on netapp AFF.
>
>     Or maybe recommend something else.
>
>     I am the same guy who had sent this message 9 years earlier :
>
>     https://www.postgresql.org/message-id/flat/5502C98F.2090806%40matrix.gatewaynet.com
>
>     Then in summer 2016 while on vacations I lost the WAL disk.
>
>
> Backups... take them early, take them often, and make sure they 
> restore properly.  Then you can run on cheaper hardware with some 
> confidence that all your data will still be there.
>
> I'm a big fan of PgBackRest.  Our infrastructure is (so far) reliable, 
> and Postgresql is (so far) too, so I've never had to do a crash 
> recovery, but the applications or users occasionally break something, 
> and then it's OMG WE MUST RESTORE THE DATABASE NOW!!!  PgBR's 
> continuous and integrated PITR has always worked perfectly for us.
thank you Ron, we run PgSQL since 2001, my question was strictly on this 
vendor / model.

-- 
Achilleas Mantzios
  IT DEV - HEAD
  IT DEPT
  Dynacom Tankers Mgmt (as agents only)

--------------GlI8xo6bii1EWHzKA0NDdnPn
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <div class="moz-cite-prefix">Στις 11/5/24 16:05, ο/η Ron Johnson
      έγραψε:<br>
    </div>
    <blockquote type="cite"
cite="mid:CANzqJaC+XJYceGASAqqbv8kH5=j1nN35C+v65jmQCfY1JLty4Q@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <div dir="ltr">On Sat, May 11, 2024 at 4:24 AM Achilleas
          Mantzios &lt;<a href="mailto:a.mantzios@cloud.gatewaynet.com"
            moz-do-not-send="true" class="moz-txt-link-freetext">a.mantzios@cloud.gatewaynet.com</a>&gt;
          wrote:<br>
        </div>
        <div class="gmail_quote">
          <blockquote class="gmail_quote"
style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Στις
            10/5/24 14:30, ο/η Achilleas Mantzios - cloud έγραψε:<br>
            &gt; Hello All<br>
            &gt;<br>
            &gt; Has anyone run PostgreSQL on netapp AFF C250A storage ?
            Have you run <br>
            &gt; into any problems regarding reliability or performance
            ?<br>
            &gt;<br>
            &gt; Thank you<br>
            &gt;<br>
            Just to make our situation more clear, we are thinking about
            moving from <br>
            cloud to premise again, for the moment this is just a long
            term vision. <br>
            So nothing is cemented, but we have purchased a couple of
            those systems <br>
            already so I'd like to know your general experience with
            running <br>
            PostgreSQL on netapp AFF.<br>
            <br>
            Or maybe recommend something else.<br>
            <br>
            I am the same guy who had sent this message 9 years earlier
            :<br>
            <br>
            <a
href="https://www.postgresql.org/message-id/flat/5502C98F.2090806%40matrix.gatewaynet.com"
              rel="noreferrer" target="_blank" moz-do-not-send="true"
              class="moz-txt-link-freetext">https://www.postgresql.org/message-id/flat/5502C98F.2090806%40matrix.gatewaynet.com</a><br>
            <br>
            Then in summer 2016 while on vacations I lost the WAL disk.</blockquote>
          <div><br>
          </div>
          <div>Backups... take them early, take them often, and make
            sure they restore properly.  Then you can run on cheaper
            hardware with some confidence that all your data will still
            be there.</div>
          <div><br>
          </div>
          <div>I'm a big fan of PgBackRest.  Our infrastructure is (so
            far) reliable, and Postgresql is (so far) too, so I've never
            had to do a crash recovery, but the applications or users
            occasionally break something, and then it's OMG WE MUST
            RESTORE THE DATABASE NOW!!!  PgBR's continuous and
            integrated PITR has always worked perfectly for us.</div>
        </div>
      </div>
    </blockquote>
    thank you Ron, we run PgSQL since 2001, my question was strictly on
    this vendor / model.<br>
    <pre class="moz-signature" cols="72">-- 
Achilleas Mantzios
 IT DEV - HEAD
 IT DEPT
 Dynacom Tankers Mgmt (as agents only)</pre>
  </body>
</html>

--------------GlI8xo6bii1EWHzKA0NDdnPn--