My locale settings were not properly configured when PostgreSQL was installed. Purging and reinstalling didn't help. I followed the instructions here and that did the trick for me.
Essential parts of the linked information reproduced below:
The problem showed itself in the following manner:
I want to query in a database like :
Let us consider a student table A with following attributes: (Id, Age, CGPA, Address, Gender). Our table
contains record for all the student in the world (so my table is Big with million of records). I want to search this table to find out the student of my ch...
@PaulWhite Hopefully the answerer will learn the right lesson ("I'll make sure my future answers will not depend on external references" rather than "I'll post link-only answers from now on, someone will surely make them salvageable").
@dezso You're suggesting it should be closed because the OP hasn't responded?
I don't think that's a good reason to close what is quite a reasonable question with two answers. Closing would prevent someone adding a better answer. It's not 100% clear cut though, so I'm willing to be persuaded otherwise. The age of the question shouldn't really affect the calculation too much:
Here's my $0.05 (I'm giving you more than a tupence so deal with it).
If the question is old and good, then answer it if you can.
If the question is old and poor but can be edited to be good, then edit it and answer it.
If the question is old and off topic then vote for it to b...
@MarkStorey-Smith it really depends on the RPO and RTO objectives. Hourly log backups (with a daily full) means you only ever have to restore at-most 23 log backups. If you don't have an automated restore strategy in place, that is far quicker than manually restoring 1400+ backups.
It was really messing with my head as well. I put a space between whatever not-y is and lowercase delta? and google translate turned it into abc dezith I couldn't figure out how a space two characters away would influence whether a letter was b or v
Yes. I had mixed feelings about it. On the one hand, the edit is ultimately pointless, and I wanted to draw his attention to that. On the other, if the OP sees the formatting edit, that might be helpful on its own. In the end, I decided the former was more useful. If the OP reposts as a question, any formatting issues will be highlighted more permanently there.
The SQLSaturday in Lisbon this year was pretty cool btw. I'm not sure how many more people they drew in just because Paul White was speaking, but that was what got me (and probably Martin Smith) to come.