public inbox for [email protected]
help / color / mirror / Atom feedFrom: Andy Hartman <[email protected]>
To: Adrian Klaver <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: Backup
Date: Wed, 23 Oct 2024 10:07:02 -0400
Message-ID: <CAEZv3crUuwOoGbD754awgJ7cRZoJ7-wYmoVTymR9GbfNbMFsSQ@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAEZv3cqct1WFb9KYmYa5kjdxfVK8JEFdzbJ5bRL6b4r+XR2dug@mail.gmail.com>
<CAJ9xe=sdH2-kgM0+bMH8Oe_4=npPwetue+ukz9MXDTZfJ_poUg@mail.gmail.com>
<CAEZv3cpDuCNg=vN_Q=ogk7ems0fho3xTWoCjLhZr47yM5u77KQ@mail.gmail.com>
<CAEZv3co3spuFH6JWB7fwxjobZA2CfiBxjx59kPvBLrmm_ro_0A@mail.gmail.com>
<[email protected]>
<CAEZv3coA9H5FA0pJ2Fcm9pXn76SwBUC3UBDGmNaAQApfp90hgA@mail.gmail.com>
<[email protected]>
<CAEZv3cqpyQX66xvWJHWLKmN8HAOL73Zu-mbEzPj+6Q1VW9RDKg@mail.gmail.com>
<[email protected]>
I have been testing different backup methods suggested and wonder if I have
all my files used to load the DB .. could that be considered a backup...
obviously need to have schema backup in case of problem, but that seems to
be easily re-created
Thoughts?
On Fri, Oct 18, 2024 at 2:30 PM Adrian Klaver <[email protected]>
wrote:
>
>
> On 10/18/24 11:25 AM, Andy Hartman wrote:
> > Windows Server 2022
> >
> > I would like a backup process similar to what I'm used to using in the
> > mssql world if that's possible with Postgres... I will be
> > loading monthly archive data to Postgresql so that's why I probably only
> > need once a backup .. once loaded data is just viewed thru an app... no
> > updates..
> >
> > in mssql you create the .bak and easily restorable .... that's what I'm
> > looking for with Postgres
> >
>
> Then pg_dump for database backup:
>
> https://www.postgresql.org/docs/current/app-pgdump.html
>
> and pg_dumpall for entire cluster backup:
>
> https://www.postgresql.org/docs/current/app-pg-dumpall.html
>
> > thanks for replies..
> >
> >
> >
> > On Fri, Oct 18, 2024 at 1:00 PM Adrian Klaver <[email protected]
> > <mailto:[email protected]>> wrote:
> >
> > On 10/18/24 09:52, Andy Hartman wrote:
> >
> > Reply to list also
> > Ccing list.
> >
> > > Windows 22 and Postgres 16.4
> > >
> > Is that Windows Server 2022 or Windows 10/11 with the 22H2 update?
> >
> > You also need to provide a more detailed description of what you want
> > the backup to do?
> >
> > >
> > >
> > > On Fri, Oct 18, 2024 at 12:04 PM Adrian Klaver
> > > <[email protected] <mailto:[email protected]>
> > <mailto:[email protected]
> > <mailto:[email protected]>>> wrote:
> > >
> > > On 10/18/24 05:39, Andy Hartman wrote:
> > > > I would like to use the closest thing to a mssql backup...
> > > >
> > >
> > > As in?
> > >
> > > Searching on 'mssql backup' returns a lot of choices. You
> > will need to
> > > be more specific on what you want to achieve. Also be
> > specific about
> > > what versions of OS and Postgres you are using.
> > >
> > > --
> > > Adrian Klaver
> > > [email protected] <mailto:[email protected]>
> > <mailto:[email protected] <mailto:[email protected]
> >>
> > >
> >
> > --
> > Adrian Klaver
> > [email protected] <mailto:[email protected]>
> >
>
> --
> Adrian Klaver
> [email protected]
>
view thread (5+ 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]
Subject: Re: Backup
In-Reply-To: <CAEZv3crUuwOoGbD754awgJ7cRZoJ7-wYmoVTymR9GbfNbMFsSQ@mail.gmail.com>
* 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