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 <adrian.klaver@xxxxxxxxxxx
<mailto:adrian.klaver@xxxxxxxxxxx>> 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
> <adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
<mailto:adrian.klaver@xxxxxxxxxxx
<mailto:adrian.klaver@xxxxxxxxxxx>>> 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
> adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
<mailto:adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>>
>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
