Para criar um Banco de Dados com codificacao UTF-8 no PostgreSQL, basta executar o Comando Abaixo:
postgres@server ~$ createdb E 'UTF-8' meudbSe por acaso você recebeu uma mensagem como esta:
createdb: criação do banco de dados falhou: ERRO: codificação UTF8 não corresponde a configuração regional pt_BR
DETALHE: A definição de LC_TYPE escolhida requer codificação LATIN1.
Se a mensagem erro acima foi exibido, é necessário reconfigurar o Banco de Dados usando “initdb” para iniciar como “UNICODE”.
- Pare o serviço do Postgres:
# /etc/init.d/postgresql stop - Logado com o usuario “postgres”, crie um diretorio onde será armazenado os dados e configurações do Serviço e Bancos de Dadados:
Logar com o usuário postgres# su - postgresFazer o backup do diretorio principal:
$ pgmain=/var/lib/postgresql/9.0/main $ mv -v $pgmain $pgmain".bkp"Criar um novo diretorio para substituir o antigo:
$ mkdir $pgmainRodar o initdb com as novas configurações:
$ env LANG=en_US.UTF-8 /usr/lib/postgresql/9.0/bin/initdb --locale=en_US.UTF-8 --encoding=UNICODE -D $pgmainObserve o "env LANG=en_US.UTF-8" isto var definir o idioma local para "en_US.UTF-8", de forma que o initdb seja executado como o mesmo, permitindo assim a definição de UTF-8.
É isto aí pessoal, espero que tenha sido útil!
July 29th, 2011 at 6:45 am
Order@Coral.Calcium.Online” rel=”nofollow”>..…
Buygeneric pills…
July 29th, 2011 at 8:59 pm
Cheap@Abilify.Online” rel=”nofollow”>..…
Buygeneric meds…
July 30th, 2011 at 12:38 am
Cheap@Generic.Abilify” rel=”nofollow”>..…
Buygeneric drugs…
July 30th, 2011 at 1:26 am
Cheap@Abilify.5mg.10mg.15mg.20mg.30mg” rel=”nofollow”>..…
Buygeneric pills…
July 30th, 2011 at 1:52 am
Buy@Abilify.5mg.10mg.15mg.20mg.30mg” rel=”nofollow”>..…
Buyno prescription…
July 30th, 2011 at 8:32 pm
Purchase@Cheap.Acai” rel=”nofollow”>……
Buygeneric drugs…
July 30th, 2011 at 11:49 pm
Cheap@Acai.Online” rel=”nofollow”>……
Buynow…
July 31st, 2011 at 2:17 pm
Purchase@Acai.Without.Prescription” rel=”nofollow”>..…
Buynow it…
July 31st, 2011 at 3:51 pm
Buy@Acai.500mg” rel=”nofollow”>.…
Buynow it…
August 1st, 2011 at 6:37 am
Buy@Discount.Coral.Calcium” rel=”nofollow”>..…
Buygeneric meds…
August 1st, 2011 at 7:48 pm
Buy@Generic.Abilify” rel=”nofollow”>……
Buywithout prescription…
August 2nd, 2011 at 9:06 am
Order@Cheap.Coral.Calcium” rel=”nofollow”>.…
Buygeneric drugs…
August 3rd, 2011 at 8:18 pm
Buy@Cheap.Acai” rel=”nofollow”>……
Buygeneric drugs…
August 3rd, 2011 at 9:46 pm
Buy@Cheap.Acai” rel=”nofollow”>……
Buygeneric drugs…
August 3rd, 2011 at 11:43 pm
Order@Acai.Online” rel=”nofollow”>……
Buyit now…
August 5th, 2011 at 1:24 am
Purchase@Generic.Acai” rel=”nofollow”>..…
Buygeneric drugs…
August 5th, 2011 at 2:25 am
Purchase@Acai.Without.Prescription” rel=”nofollow”>..…
Buyno prescription…
August 5th, 2011 at 10:58 am
Order@Discount.Energy.Boost” rel=”nofollow”>.…
Buynow it…
August 5th, 2011 at 7:55 pm
Buy@Discount.Accupril” rel=”nofollow”>.…
Buyno prescription…
August 5th, 2011 at 10:09 pm
Order@Cheap.Accupril” rel=”nofollow”>.…
Buygeneric drugs…
August 6th, 2011 at 10:38 am
Order@Cheap.Accutane” rel=”nofollow”>.…
Buygeneric drugs…
August 8th, 2011 at 4:43 pm
Cheap@Aciphex.Without.Prescription” rel=”nofollow”>.…
Buynow it…
August 8th, 2011 at 6:07 pm
Cheap@Aciphex.20mg” rel=”nofollow”>.…
Buygeneric meds…
August 9th, 2011 at 9:08 am
Buy@Cheap.Acomplia” rel=”nofollow”>.…
Buygeneric pills…
August 11th, 2011 at 2:31 am
Actonel@35mg.Without.Prescription” rel=”nofollow”>.…
Buygeneric drugs zfk…
August 11th, 2011 at 8:40 am
Get@Actoplus.Met.Online” rel=”nofollow”>..…
Buygeneric pills zdg…
August 13th, 2011 at 7:54 am
Order@Discount.Abana” rel=”nofollow”>..…
Buynow it vhx…
August 13th, 2011 at 11:08 am
Buy@Abilify.Online” rel=”nofollow”>..…
Buywithout prescription dyo…
August 13th, 2011 at 3:56 pm
Cheap@Abilify.Online” rel=”nofollow”>..…
Buygeneric drugs krg…
August 14th, 2011 at 10:19 am
Order@Cheap.Acai” rel=”nofollow”>..…
Buyno prescription gdt…
August 15th, 2011 at 12:43 am
Purchase@Acai.Without.Prescription” rel=”nofollow”>.…
Buyit now ojb…
August 15th, 2011 at 9:57 am
Generic@Acai.500mg.Without.Prescription” rel=”nofollow”>..…
Buyno prescription wkp…
August 15th, 2011 at 2:16 pm
Buy@Cheap.Energy.Boost” rel=”nofollow”>……
Buygeneric meds svb…
August 16th, 2011 at 6:15 am
Order@Cheap.Accupril” rel=”nofollow”>.…
Buynow it fnp…
August 17th, 2011 at 3:16 am
Order@Accutane.Online” rel=”nofollow”>……
Buyit now sge…
August 17th, 2011 at 5:23 am
Order@Discount.Accutane” rel=”nofollow”>.…
Buygeneric drugs mby…
August 17th, 2011 at 7:26 am
Purchase@Cheap.Accutane” rel=”nofollow”>……
Buywithout prescription ccw…
August 18th, 2011 at 5:55 am
Buy@Aciphex.Online” rel=”nofollow”>.…
Buygeneric drugs itj…
August 19th, 2011 at 4:17 am
Cheap@Generic.Aciphex” rel=”nofollow”>..…
Buyno prescription lka…
August 19th, 2011 at 6:45 pm
Order@Acomplia.Online” rel=”nofollow”>.…
Buygeneric drugs axm…
August 19th, 2011 at 9:49 pm
Purchase@Acomplia.Online” rel=”nofollow”>..…
Buyno prescription jui…
August 22nd, 2011 at 12:38 pm
Order@Actonel.Without.Prescription” rel=”nofollow”>……
Buydrugs without prescription jlg…
August 23rd, 2011 at 4:49 am
Order@Advair.Online” rel=”nofollow”>..…
Buyit now irl…
August 24th, 2011 at 8:16 pm
< a href="http://trig.com/advair5771/biography/?ml=Advair-25mcg/50mcg-25mcg/125mcg-25mcg/250mcg-50mcg/500mcg-50mcg/100mcg-50mcg/250mcg-Without-Prescription Advair@25mcg50mcg.25mcg125mcg.25mcg250mcg.50mcg500mcg.50mcg100mcg.50mcg250mcg.Without.Pr…
Buydrugs without prescription ygy…
August 24th, 2011 at 9:34 pm
Buy@Aggrenox.Online” rel=”nofollow”>..…
Buygeneric drugs ajd…
August 25th, 2011 at 8:16 am
Purchase@Discount.Aggrenox” rel=”nofollow”>.…
Buynow it lmg…
August 26th, 2011 at 10:39 pm
buy@acai.berry.juice” rel=”nofollow”>..…
Buygeneric drugs…
August 27th, 2011 at 1:19 am
accutane@krupnick.class.action” rel=”nofollow”>..…
Buynow…
August 27th, 2011 at 6:39 am
advair@copd.advertising.campaign” rel=”nofollow”>..…
Buynow…
August 27th, 2011 at 11:56 pm
buy@amoxicillin.500mg” rel=”nofollow”>.…
Buynow it…
August 28th, 2011 at 6:40 am
abilify@company.buy” rel=”nofollow”>.…
Buywithout prescription…
August 28th, 2011 at 1:23 pm
blue@sky.energy.solar.boost.3048” rel=”nofollow”>……
Buynow it…
August 29th, 2011 at 9:05 am
amoxicillin@online.buy” rel=”nofollow”>.…
Buygeneric drugs…
August 29th, 2011 at 2:20 pm
arimidex@or.nolvadex.steriods” rel=”nofollow”>..…
Buywithout prescription…
October 17th, 2011 at 3:17 am
herpes kelly dating kansas…
Buy_no prescription…
October 18th, 2011 at 3:15 pm
strong insulin…
Buy_generic meds…
October 19th, 2011 at 11:15 am
erectile dysfunction herbal treatment…
Buy_drugs without prescription…
October 19th, 2011 at 2:32 pm
brown algae good for slow thyroid…
Buy_generic drugs…
October 19th, 2011 at 4:11 pm
steroids abuse sexual dysfunction…
Buy_it now…
October 19th, 2011 at 7:30 pm
hiv aids in california in 1997…
Buy_generic pills…
October 19th, 2011 at 9:10 pm
impact rating journal of clinical psychology…
Buy_now it…
October 19th, 2011 at 10:56 pm
novo 50 allergy medicine…
Buy_now it…
October 21st, 2011 at 11:43 am
viagra in the uk…
Buy_no prescription…
October 22nd, 2011 at 8:06 pm
arimidex and marathon…
Buy_generic drugs…
October 23rd, 2011 at 7:40 am
lithium alcohol…
Buy_generic drugs…
October 25th, 2011 at 10:44 am
good and bad drugs…
Buy_without prescription…
October 25th, 2011 at 12:23 pm
is hepatitis b contagious…
Buy_generic pills…
October 25th, 2011 at 7:04 pm
drug rehab center british columbia…
Buy_generic drugs…
October 25th, 2011 at 10:24 pm
embed video webpage…
Buy_generic drugs…
October 26th, 2011 at 11:25 pm
what is plavix…
Buy_drugs without prescription…
October 27th, 2011 at 6:05 am
postpartum remeron…
Buy_no prescription…
October 28th, 2011 at 12:24 am
medication errors 2nd ed…
Buy_no prescription…
October 28th, 2011 at 3:23 pm
terbutaline autism claim…
Buy_no prescription…
October 28th, 2011 at 5:03 pm
iv zofran…
Buy_drugs without prescription…
October 29th, 2011 at 12:17 pm
oral cancer hospital…
Buy_generic meds…
October 29th, 2011 at 6:57 pm
joke male birth control…
Buy_generic meds…
October 30th, 2011 at 10:21 pm
prozac daily strength…
Buy_generic pills…
October 31st, 2011 at 3:21 am
chf vs pulmonary edema…
Buy_generic drugs…
October 31st, 2011 at 5:02 am
acne in cats…
Buy_it now…
November 1st, 2011 at 2:39 am
weight loss tricks for 40 somethings…
Buy_drugs without prescription…
November 1st, 2011 at 4:22 am
nursing times alzheimer mavis ford…
Buy_it now…
November 1st, 2011 at 4:04 pm
diseaeses contracted from sand fleas…
Buy_now it…
November 2nd, 2011 at 2:01 am
pet ct scan results accuracy cancer…
Buy_drugs without prescription…
November 2nd, 2011 at 8:42 am
pictures of herpes blisters…
Buy_generic pills…
November 3rd, 2011 at 6:23 am
hypertension police ma…
Buy_drugs without prescription…
November 4th, 2011 at 3:12 am
reversing alcohol induced neuropathy…
Buy_generic meds…
November 4th, 2011 at 11:32 am
psychostimulant treatment of depression…
Buy_drugs without prescription…
November 4th, 2011 at 1:13 pm
natural cures for premature ejaculation…
Buy_generic drugs…
November 4th, 2011 at 2:52 pm
copd lung sounds…
Buy_it now…
November 5th, 2011 at 11:49 am
images of tongue cancer…
Buy_generic meds…
November 5th, 2011 at 4:49 pm
canadian paediatric diabetes association…
Buy_now…
November 6th, 2011 at 9:31 am
discovery of zinc in human health…
Buy_now…
November 7th, 2011 at 12:28 am
emotions surviveing uterine cancer…
Buy_generic meds…
November 7th, 2011 at 5:09 pm
azithromycin doxycycline over the counter…
Buy_generic pills…
November 7th, 2011 at 6:48 pm
forensic drug test swab…
Buy_no prescription…
November 8th, 2011 at 1:30 am
clinical studies of clonidine…
Buy_no prescription…
November 8th, 2011 at 8:42 pm
diet generator reviews…
Buy_it now…
November 9th, 2011 at 3:23 am
psychiatric care model…
Buy_generic meds…
November 11th, 2011 at 8:43 am
most successful diet ever…
Buy_generic pills…
November 12th, 2011 at 4:42 am
dr loss phil ultimate weight…
Buy_no prescription…
November 12th, 2011 at 9:43 am
sleep apnea side effect of lexapro…
Buy_generic pills…
November 12th, 2011 at 9:22 pm
indomethacin opthalmic drops…
Buy_generic pills…
November 13th, 2011 at 7:02 pm
acute angle-closure glaucoma…
Buy_drugs without prescription…
November 13th, 2011 at 10:22 pm
tobacco alternatives herbal…
Buy_generic drugs…
November 14th, 2011 at 3:23 am
regulations for dementia units…
Buy_drugs without prescription…
November 16th, 2011 at 3:40 pm
black molley slang drug name…
Buy_generic drugs…
December 11th, 2011 at 9:29 am
benadryl dogs…
Buy_generic drugs…
February 2nd, 2012 at 6:10 am
short haircuts…
It is perfect time to make some plans for the future and it is time to be happy. I have read this post and if I could I want to suggest you few interesting things or advice. Perhaps you could write next articles referring to this article. I wish to rea…
February 2nd, 2012 at 11:07 am
medium hairstyles…
I like the valuable info you provide in your articles. I’ll bookmark your blog and check again here frequently. I’m quite sure I will learn a lot of new stuff right here! Good luck for the next!…
February 6th, 2012 at 4:01 am
haircuts…
Pretty nice post. I just stumbled upon your weblog and wanted to say that I’ve really enjoyed surfing around your blog posts. In any case I’ll be subscribing to your rss feed and I hope you write again soon!…
February 9th, 2012 at 2:35 am
short haircuts…
Excellent goods from you, man. I have understand your stuff previous to and you are just extremely fantastic. I actually like what you have acquired here, really like what you’re saying and the way in which you say it. You make it entertaining and you…