|
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!
|
|
|
|
|
Just create a MKV and the subtitle files will be in the resulting MKV container.
It's a complex program. Maybe it would be better to use something that specializes in just subtitles. Go here:
Subtitle Editors/Converters Free Downloads - VideoHelp[^]
Change the second combo box to "Subtitle Editors/Converters" and press "Search" and there are 71 to choose from.
Good Luck.
|
|
|
|
|
Thanks for the good wishes - but I haven't had that good luck yet
I never thought of creating an MKV to extract an SRT. I tried it, and had an MKV made that certainly includes the subtitle track. I can turn it on and off in an MKV player. But neither MKVToolNix (mkvextract.exe) nor MKVExtractGUI2 seems to find the subtitle track. At least not as something that they are able to extract.
Several of those 71 entries in the "Subtitle Editors/Converters" group talks about 'extraction' in the description, but when you start the program, it insists on opening an existing subtext file, not a BD image / directory for extracting and creating a subtext file. The majority of the 71 tools are for authoring your own subtitle file and having it incorporated into a container (such as MKV) - not the other way around, which is what I am looking for. I am still searching, but it is a rather frustrating experience!
I would certainly be grateful for advice from someone who has actually succeeded in extracting subtitles from BD disks, willing to reveal which tools they used for the task.
|
|
|
|