pg_dump 17 produces files incompatible with older server versions

2024-10-02 Thread Sam Kidman
e for us as we have a few different postgres server versions in use in different applications but we use the same set of client tools for all of them. Best, -- Sam Kidman Web Developer Melbourne 0498 592 582 s...@fresho.com www.fresho.com

Re: Poor performance after restoring database from snapshot on AWS RDS

2024-06-07 Thread Sam Kidman
2024 at 4:23 AM Sam Kidman wrote: > > > We get very poor performance in the staging environment after this > > restore takes place - after some usage it seems to get better perhaps > > because of caching. > > > > This is due to the way that RDS resto

Poor performance after restoring database from snapshot on AWS RDS

2024-06-05 Thread Sam Kidman
have seen some advice that vacuum analyze should be run after the snapshot restore but I thought this was supposed to happen automatically. If we did run it manually how would that help? Are there any other tools in postgres we can use to figure out why it might be so much slower? Best -- Sam K

Re: errcodes.h and others not generated when compiling 13.6 on M1 Mac

2022-04-29 Thread Sam Kidman
n for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. This program built for i386-apple-darwin11.3.0 On Fri, Apr 29, 2022 at 10:16 AM Tom Lane wrote: > Sam Kidman writes: > > So for some reason that submake-generated-headers target isn't getting > > called for us. > &

Re: errcodes.h and others not generated when compiling 13.6 on M1 Mac

2022-04-29 Thread Sam Kidman
; On Wed, 2022-04-27 at 10:05 +1000, Sam Kidman wrote: > >> I recently upgraded one of our applications to use postgres 13.6. When > I try to compile > >> from a source checkout or by running asdf install (our version manager > which also compiles 13.6) > >> I

Re: errcodes.h and others not generated when compiling 13.6 on M1 Mac

2022-04-29 Thread Sam Kidman
Also the README.md makes mention of an INSTALL file that contains instructions about prerequisites for compilation but I couldn't find it in the repository. Regards, Sam On Wed, Apr 27, 2022 at 11:38 PM Tom Lane wrote: > Laurenz Albe writes: > > On Wed, 2022-04-27 at 10:05 +1000,

errcodes.h and others not generated when compiling 13.6 on M1 Mac

2022-04-27 Thread Sam Kidman
Hello I recently upgraded one of our applications to use postgres 13.6. When I try to compile from a source checkout or by running asdf install (our version manager which also compiles 13.6) I get the same error message: ../../src/include/utils/elog.h:71:10: fatal error: 'utils/errcodes.h' file n