|
md5 is pretty vulnerable. That's almost certainly why they changed it. Be careful.
To err is human. Fortune favors the monsters.
|
|
|
|
|
The idea was indeed that upgrading was needed for security reasons, so that will be the next step.
But first a well deserved rest after all this hard labour!
[Edit]
It seems we are in luck: Quote: Beginning with Postgres 10, you can change your PostgreSQL password authentication to SCRAM-SHA-256, which is a more secure authentication method than md5 and plain password. Change PostgreSQL Password Authentication to SCRAM-SHA-256[^]
modified 4-Jun-22 6:47am.
|
|
|
|
|
Having upgraded from earlier versions of postgres since at least v 7.1, the way I have always found is the easiest way to do it, no matter what the platform is as follows:
1) Install the new version that you want to upgrade too, in a different location (File system wise) and listening on a different TCP port to the old instance.
2) Configure the Postgres pg_hba.conf file to allow the terminal your working from full access (The MD5 warnings are valid here), MD5 is fine if the server is not exposed to the internet as you are only allowing this access for the duration of the upgrade, if you make the access address have an IP V4 address with a 32 bit mask, no one except your workstation will be able to access it anyway...
3) Configure an second access in pg_hba.conf that allows the IP address of the already running older postgres server to also access the new one.
4) use "pg_dump -U postgres -h oldpgip -p oldpgport dbname | psql -U postgres -h newpgip -p newpgport dbname" to copy directly from the old DB to the new DB, make sure that ALL apps using the old db are shut down and inactive before you do this.
5) Wait.... possibly a long time.... I usually do things like this overnight....
6) Once the transfer is complete, shut down the old instance and remove it (After first testing the new instance has the data in it etc) then if you desire configure the new instance to have be on the same port/IP etc as the old one.
This trick will work on a machine where both servers are on the same machine, and that's even better because you can then just assign the pg_hba entries with IP=127.0.0.1/32 with trust authentication, then use the PG command line tools on the same box. Just make sure you configure the data directories to be separate from each other.
This is great in another respect too, because as long as you have the required add on extensions installed for the new version (EG: PostGIS) then this will transfer across all the required statements to re-add user accounts, extension objects, data types you name it.
|
|
|
|
|
Thanks, useful information!
But my problem is that I have to do it all programmatically from C#, got this working already and it is in the testing phase. If there is enough interest (don't get the impression) I could be persuaded to write a CodeProject article about it
|
|
|
|
|
no worries rick, just thought I'd mention that's the way it's worked for me all these years.
However, if you have to do this in C#, you might want to take a look at the latest version of NpgSQL and the fact if now supports bulk upload/download in a binary format
basically, you would skip the PG dump step and replace that with your tool using NpgSQL.
I wrote the syncfusion eBook on postgres years ago (And if I'm being honest, it needs an update ), anyway... point being, feel free to ask me if you have any PG queries...
|
|
|
|
|
Wordle 350 6/6
⬜⬜⬜⬜⬜
⬜🟨🟨⬜⬜
⬜🟨🟩🟨⬜
🟨🟩🟩⬜⬜
⬜🟩🟩🟨🟨
🟩🟩🟩🟩🟩
Just managed.
|
|
|
|
|
Wordle 350 4/6
⬜⬜⬜⬜⬜
⬜🟨🟨🟩🟩
⬜🟩🟩🟩🟩
🟩🟩🟩🟩🟩
4 again...
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
|
|
|
|
|
Wordle 350 4/6
🟨⬜⬜⬜⬜
⬜🟨🟩⬜🟨
⬜🟩🟩🟩🟩
🟩🟩🟩🟩🟩
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Wordle 350 5/6*
⬜🟩⬜⬜⬜
⬜🟩⬜⬜⬜
🟨🟩🟩⬜⬜
⬜🟩🟩🟩🟩
🟩🟩🟩🟩🟩
|
|
|
|
|
Wordle 350 3/6
⬜🟩⬜⬜⬜
🟨🟩⬜⬜⬜
🟩🟩🟩🟩🟩
Life should not be a journey to the grave with the intention of arriving safely in a pretty and well-preserved body, but rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming “Wow! What a Ride!" - Hunter S Thompson - RIP
|
|
|
|
|
Wordle 350 4/6
⬜⬜🟨🟩⬜
🟨⬜⬜⬜⬜
🟩🟩🟩⬜⬜
🟩🟩🟩🟩🟩
I didn't know this word, got lucky on my third guess.
|
|
|
|
|
How can you guess a word if you don't know it?
If you did, I would say you (re)invented it
|
|
|
|
|
Because I have 4/5th or 3/5th of the word, and any other letter wouldn't make sense
In this case, I had "fro" and some spare letters.
I know it's not "froqx" or something like that, but "th" is a valid end of word and "froth" sounds like it may be an existing word.
So I tried "froth" and it worked, but it's a bit of (educated) trial and error sometimes.
|
|
|
|
|
Wordle 350 4/6
⬛⬛⬛⬛⬛
⬛🟩🟩⬛⬛
🟩🟩🟩⬛⬛
🟩🟩🟩🟩🟩
|
|
|
|
|
3 possible words at the end, so it could have gone to 6.
Wordle 350 4/6
⬛🟨⬛🟨⬛
🟨🟩⬛⬛⬛
⬛🟩🟩⬛🟨
🟩🟩🟩🟩🟩
|
|
|
|
|
I suspect OG and I had the same penultimate shot. There were two obvious candidates at that point and we both guessed wrong.
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
|
|
|
|
|
Wordle 350 6/6
⬜⬜⬜⬜⬜
⬜🟨🟩🟨⬜
🟨🟩🟩⬜⬜
⬜🟩🟩🟩🟩
⬜🟩🟩🟩🟩
🟩🟩🟩🟩🟩
Same here. 3 possible words, but I took it to the end.
|
|
|
|
|
I pretty much ruled out one of the three, but I guess you tried it.
|
|
|
|
|
Yeah. I just popped the 1st one off my mental the stack as it were without thinking. Had I thought about it first I would have solved in 5 because I would have given the actual solution a lower chance than my other choice. It's a good thing there wasn't a 4th word that I'd missed.
|
|
|
|
|
|
Wordle 350 2/6*
⬜🟨🟩⬜🟨
🟩🟩🟩🟩🟩
Very lucky guess for the first word
Happiness will never come to those who fail to appreciate what they already have. -Anon
|
|
|
|
|
Wordle 350 5/6
⬛⬛⬛🟨⬛
🟨⬛⬛⬛⬛
🟨🟩🟩⬛⬛
⬛🟩🟩⬛🟨
🟩🟩🟩🟩🟩
Get me coffee and no one gets hurt!
|
|
|
|
|
In the old days of DVDs I had a program for extracting and OCRing subtitles from DVDs. It wasn't very good, and it never handled BluRay disks.
Are there (Windows) programs around doing a decent job of extracting subtitles from BD disks, preferably into SRT format (or at least a format with time stamps)?
|
|
|
|
|
|
Maybe it can, but then it is well hidden. I can't find it!
|
|
|
|