postgres: do I really need to use Collate and Ctype when restoring database?
The main consideration is that if you use ORDER BY with a column of a string data type, the result will be sorted according to the database collation unless you specify an explicit COLLATE clause for the column definition or with the ORDER BY. If your users expect the results sorted according to Hebrew sorting rules, they might be unhappy.
To get a Hebrew collation on Unix, use the locale he_IL.utf8.