Looks like the new DB might have been initialized with a different locale. Read about locales and initdb in the docs.
Good luck. Fernando. En un mensaje anterior, Pedro Miguel Guedes escribió: [...] > > The problem seems to be on accent on letters. So I thought maybe some stuff > on charsets/encoding and I tried all the advices on the html/docs changing > database and client encodings to LATIN1 (it was SQL_ASCII) to no help. > Environ var like LANG and LC_ALL equal "pt_PT" on /etc/init.d/postgres. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster