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
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 >
> thanks for replies.. > > > > On Fri, Oct 18, 2024 at 1:00 PM Adrian Klaver <adrian.klaver@aklaver.com > <mailto:adrian.klaver@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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com> > <mailto:adrian.klaver@aklaver.com > <mailto:adrian.klaver@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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com> > <mailto:adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> > > > > -- > Adrian Klaver > adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com> >
