MIME-Version: 1.0
From: Andy Hartman <hartman60home@gmail.com>
Date: Wed, 16 Oct 2024 15:37:39 -0400
Message-ID: <CAEZv3cqct1WFb9KYmYa5kjdxfVK8JEFdzbJ5bRL6b4r+XR2dug@mail.gmail.com>
Subject: Backup
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000921f4a06249d34e0"
Archived-At: <https://www.postgresql.org/message-id/CAEZv3cqct1WFb9KYmYa5kjdxfVK8JEFdzbJ5bRL6b4r%2BXR2dug%40mail.gmail.com>
Precedence: bulk

--000000000000921f4a06249d34e0
Content-Type: text/plain; charset="UTF-8"

I am very new to Postgres and have always worked in the mssql world. I'm
looking for suggestions on DB backups. I currently have a DB used to store
Historical information that has images it's currently around 100gig.

I'm looking to take a monthly backup as I archive a month of data at a
time. I am looking for it to be compressed and have a machine that has
multiple cpu's and ample memory.

Suggestions on things I can try ?
I did a pg_dump using these parms
--format=t --blobs lobarch

it ran my device out of storage:

pg_dump: error: could not write to output file: No space left on device

I have 150gig free on my backup drive... can obviously add more

looking for the quickest and smallest backup file output...

Thanks again for help\suggestions

--000000000000921f4a06249d34e0
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr">I am very new to Postgre=
s and have always worked in the mssql world. I&#39;m looking for suggestion=
s on DB backups. I currently have a DB used to store Historical information=
 that has images it&#39;s currently around 100gig.=C2=A0<br><br>I&#39;m loo=
king to take a monthly backup as I archive a month of data at a time. I am =
looking for it to be compressed and have a machine that has multiple=C2=A0c=
pu&#39;s=C2=A0and ample memory.<div><br>Suggestions on things I can try ?=
=C2=A0=C2=A0</div><div>I did a pg_dump using these parms<br>--format=3Dt --=
blobs lobarch<br><br>it ran my device out of storage:<br><br>pg_dump: error=
: could not write to output file: No space left on device<br><br>I have 150=
gig free on my backup drive... can obviously=C2=A0add more<br><br>looking f=
or the quickest and smallest backup file output...<br><br>Thanks again for =
help\suggestions=C2=A0<br><br></div></div></div></div>

--000000000000921f4a06249d34e0--