Backup works great! Do you know an eta on the release version or is this the version that will be rolled to release? I'm just weighing time vs using H2 until this is released for my upgrade window.
Thanks!! On Thursday, November 3, 2022 at 3:13:26 AM UTC-5 Chad Wilson wrote: > Great, thanks Chantry! > > An experimental code-signed server installer version is available at > https://download.gocd.org/experimental/binaries/22.3.0-15295/win/go-server-22.3.0-15295-jre-64bit-setup.exe > > (check experimental tab here <https://www.gocd.org/download/#windows> if > you want to verify checksums etc) > > The Windows installers allow upgrades but prevent downgrades (perhaps for > some historical reason I am not aware of), so keep that in mind. There > aren't any DB or config.xml format changes in this release in any case so > should have strong backward compatibility with your 22.2.0 installation, > and agents will auto-upgrade/downgrade where necessary to match the server > version so there should be no need to also install an experimental agent > version. > > You can preview the release notes at > https://gocd.github.io/pr-review.gocd.org/pr-1416/releases/ if you have > any concerns about the other included changes since the 22.2.0 you are > testing with. > > -Chad > > > On Thu, Nov 3, 2022 at 1:39 AM <chan...@gmail.com> wrote: > >> Sure! I’d be happy to drop it in and see if that works! I can double >> check on the folder creation that way as well. I haven’t entirely worked >> out building the package myself so if you have an installer I can run or >> just the files to replace and instructions on where they need to go I’m >> happy to give it a run. >> >> >> >> Thanks! >> >> >> >> *From:* go...@googlegroups.com <go...@googlegroups.com> *On Behalf Of *Chad >> Wilson >> *Sent:* Wednesday, November 2, 2022 11:05 AM >> *To:* go...@googlegroups.com >> *Subject:* Re: [go-cd] Issues with backups on Go 22.2 and PostgreSQL v12 >> >> >> >> With a bit of quick pg_dump testing on Windows (via choco install >> postgresql12/choco install postgresql14) without actually integrating >> with GoCD) I can confirm the utility complains about the order of the >> positional (non-option) dbname arguments in ways that the same utility >> on MacOS does not. Only checked v12 and v14. >> >> So it seems we need to fix something on the server here. I have a draft >> fix at https://github.com/gocd/gocd/pull/10982 which should be easy to >> get into the next 22.3.0 release (we were planning to release shortly >> anyway), especially if you are willing to help with sanity testing backups >> on your trial Windows setup you are working on. >> >> -Chad >> >> >> >> On Wed, Nov 2, 2022 at 11:13 PM Chad Wilson <ch...@thoughtworks.com> >> wrote: >> >> Technically speaking, the docs say the dbname without --dbname= should >> be the last argument after all connection options, which GoCD doesn't >> respect. Possibly pg_dump is more flexible on other OSes than Windows? >> >> If you move "gocd" to the end of the command line you will probably find >> it works. >> >> >> If you can raise an issue with the specific details to make it easy to >> reproduce (I don't work with Windows much, so the easier the better) at >> https://github.com/gocd/gocd/issues it can probably be fixed/addressed >> with `--dbname=` prefix to be unambiguous. >> >> You could try other versions of pg_dump and see if the behaviour is >> different as well. >> >> >> >> -Chad >> >> >> >> On Wed, Nov 2, 2022 at 10:46 PM Funkycybermonk <chan...@gmail.com> wrote: >> >> It looks like the file version is 12.0.12.22220. I'm using the version >> that shipped with the PostgreSQL 12 installer. I can downgrade to a lower >> PostgreSQL version if this is an issue with this release of pg_dump. >> >> >> >> The message I get when constructing the command line using as-is from the >> logs is: >> >> >> >> "C:\Users\removed>pg_dump --no-password --host=localhost --port=5432 >> --username=removed gocd --file="C:\Program Files (x86)\Go >> Server\artifacts\serverBackups\backup_20221101-202201\db.gocd" >> pg_dump: error: too many command-line arguments (first is >> "--file=C:\Program Files (x86)\Go >> Server\artifacts\serverBackups\backup_20221101-202201\db.gocd") >> Try "pg_dump --help" for more information." >> >> >> >> I can make it work by adding the --dbname= in front of the gocd value >> although the directory has to be created before the path from the logs will >> work. I'm assuming thats because the process failed in GoCD so the folder >> was removed as cleanup. Creating the folder results in a successful db.gocd >> backup file being created. >> >> >> >> Thanks! >> >> On Wednesday, November 2, 2022 at 8:58:17 AM UTC-5 ketanpad...@gmail.com >> wrote: >> >> What version of pg_dump are you using? According to >> https://www.postgresql.org/docs/current/app-pgdump.html, the command >> line string looks OK. But we've not tested this on windows. >> >> >> >> - Ketan >> >> >> >> >> >> On Wed, Nov 2, 2022 at 4:31 AM Funkycybermonk <chan...@gmail.com> wrote: >> >> Hello! >> >> >> >> New upgrade going from GoCD 20.1 to 22.2 and migrated to PostgreSQL v12 >> on Windows. Everything is now working properly but the backups were blowing >> up due to not being able to find pg_dump. I added the bin for PostgreSQL to >> the system path and the backup exits with a status code 1. I went back and >> checked the command and it looks like it might be blowing up because the >> dbname isn't defined with a parameter name. >> >> >> >> The executing bit is showing [pg_dump, --no-password, --host=localhost, >> --port=5432, --username=<removed>, gocd, --file=C:\Program Files (x86)\Go >> Server\artifacts\serverBackups\backup_20221101-215455\db.gocd] with >> environment {PGPASSWORD=<removed>} >> >> >> >> The gocd bit in the middle appears to be the dbname but its not qualified >> as --dbname. Is that a bug or is there something I haven't configured >> properly? If I take that parameter string and run it in a command prompt >> with the commas removed it blows up on the parameters not matching up. >> Adding the --dbname= to that parameter works for me but I'm not sure if >> that should be required. >> >> >> >> I can roll back to H2 but I was hoping there would be a performance >> improvement and future-proofing if I went ahead with the migration now. If >> that doesn't make sense then I'm happy to stay with H2. >> >> >> >> Thanks! >> >> -- >> You received this message because you are subscribed to the Google Groups >> "go-cd" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to go-cd+un...@googlegroups.com. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/go-cd/1a7de3d6-8dae-4da0-b675-6d02ab885993n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/go-cd/1a7de3d6-8dae-4da0-b675-6d02ab885993n%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> >> -- >> You received this message because you are subscribed to the Google Groups >> "go-cd" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to go-cd+un...@googlegroups.com. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/go-cd/991c4de4-b112-4fc9-a8ed-4a8e3a2bdd3an%40googlegroups.com >> >> <https://groups.google.com/d/msgid/go-cd/991c4de4-b112-4fc9-a8ed-4a8e3a2bdd3an%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> >> -- >> You received this message because you are subscribed to a topic in the >> Google Groups "go-cd" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/go-cd/AMtgQQS3Gck/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> go-cd+un...@googlegroups.com. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/go-cd/CAA1RwH_cbCo-gjqtjv8tfheiuUDGTWwyQC5iJR3H2izX3DfOuA%40mail.gmail.com >> >> <https://groups.google.com/d/msgid/go-cd/CAA1RwH_cbCo-gjqtjv8tfheiuUDGTWwyQC5iJR3H2izX3DfOuA%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> >> -- >> You received this message because you are subscribed to the Google Groups >> "go-cd" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to go-cd+un...@googlegroups.com. >> > To view this discussion on the web visit >> https://groups.google.com/d/msgid/go-cd/04a101d8eee2%24108c7650%2431a562f0%24%40gmail.com >> >> <https://groups.google.com/d/msgid/go-cd/04a101d8eee2%24108c7650%2431a562f0%24%40gmail.com?utm_medium=email&utm_source=footer> >> . >> > -- You received this message because you are subscribed to the Google Groups "go-cd" group. To unsubscribe from this group and stop receiving emails from it, send an email to go-cd+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/go-cd/03ad20e4-7d26-4734-b915-c8d6307770cfn%40googlegroups.com.
