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 <adrian.kla...@aklaver.com> 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 <adrian.kla...@aklaver.com > > <mailto:adrian.kla...@aklaver.com>> 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.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> > > <mailto:adrian.kla...@aklaver.com > > <mailto:adrian.kla...@aklaver.com>>> 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.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> > > <mailto:adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com > >> > > > > > > > -- > > Adrian Klaver > > adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
