tag:blogger.com,1999:blog-14872114.comments2009-09-28T04:50:32.825-06:00Roberto Mellohttp://www.blogger.com/profile/12351821831652782671noreply@blogger.comBlogger27125tag:blogger.com,1999:blog-14872114.post-54572368399629948992009-05-22T19:32:55.861-06:002009-05-22T19:32:55.861-06:00anonymous,<br /><br />Você tem duas opções:<br /><br />1) Re-inicia o cluster do PostgreSQL no seu windows (imagino que seja em windows por usar a codificação win1252). Para fazer isso, uma vez que tenhas feito backup de todos os bancos na NOVA codificação (com pg_dump), pare o serviço, e faça um initdb (utilitário do PG) passando os parâmetros da codificação que tu queres (deverias usar UTF-8) e o caminho onde estão teus arquivos de dados.<br /><br />2) Converta o arquivo de dump (se estiver em formato texto) usando um utilitário como o GNU convert (não sei se funciona no Windows)Roberto Mellohttp://www.blogger.com/profile/12351821831652782671noreply@blogger.comtag:blogger.com,1999:blog-14872114.post-70098578221021658292009-05-22T12:42:35.510-06:002009-05-22T12:42:35.510-06:00Preciso restaurar um backup que foi gerado na versão latin1 do postgress... como posso alterar a configuraçao do programa(esta com win1252)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-14872114.post-11968241113364533732009-03-04T22:47:00.000-07:002009-03-04T22:47:00.000-07:00This has been the most helpful instruction I have found online. Thanks!lockphoto.comhttp://www.blogger.com/profile/00569346140244797661noreply@blogger.comtag:blogger.com,1999:blog-14872114.post-45650816011734541862009-01-04T22:49:00.000-07:002009-01-04T22:49:00.000-07:00Artigo esclarecedor,escrito de forma clara, didática e simples contendo todas as informações que a minoria já sabe,mas não põe em prática e se destrói sabendo; e que a maioria não sabe por ignorância, e se destrói sem saber.Sônia Lafayettehttp://www.blogger.com/profile/07894666485793640793noreply@blogger.comtag:blogger.com,1999:blog-14872114.post-14623954471325815382008-11-03T10:40:31.728-07:002008-11-03T10:40:31.728-07:00Devrim,<BR/><BR/>I *wasn't* comparing RPM to apt. I'm very aware of their differences. I was comparing the idiomatic, normal, *standard* usage of Debian packages versus RPM packages, and their usability at the time, from my point of view.<BR/><BR/>As far as I know YUM is an *add-on* tool, not an official part of Red Hat, not sure it's part of CentOS. It's probably part of Fedora though.<BR/><BR/>I wasn't given any warnings about the need to run initdb.<BR/><BR/>Yes, the default for PG config is $PGDATA, but that's not the LSB default. If I was expecting all the defaults of building from scratch, I would have built from scratch, not looked for a binary package.<BR/><BR/>The Debian packages:<BR/><BR/>1) Put a *working* set configuration files (with decent defaults) under /etc, where I expect configuration files to go. <BR/><BR/>If you prefer them to be under /var/lib/pgsql to stay close to the PG default, fine, but you could easily include symlinks from /etc/postgresql or something similar, therefore inclusing usability.<BR/><BR/>2) Give me a working cluster by running initdb for me.<BR/><BR/>3) Setup cron jobs to do regular, commonly-needed maintenance (a pg_maintenance script that runs vacuum analyze)<BR/><BR/>4) Handle minor and major versions upgrades smoothly with scripts that know how to handle dumping, creating, removing, loading of clusters.<BR/><BR/>In short, the Debian packages give me a much smoother and more productive experience by taking care of the defaults and giving me a working installation.<BR/><BR/>Peter Eisentreut is part of the the team that packages PG for Debian, and I'm sure they're under some free software license.Roberto Mellohttp://www.blogger.com/profile/12351821831652782671noreply@blogger.comtag:blogger.com,1999:blog-14872114.post-74640871846573769402008-11-01T13:59:00.000-06:002008-11-01T13:59:00.000-06:00You are comparing RPM versus APT, which is terribly wrong. Please compare RPM with dpkg, or compare apt with yum. <BR/><BR/>So, if you need a yum repo, please use http://yum.pgsqlrpms.org for RPM installations of PostgreSQL and PostgreSQL related projects.<BR/><BR/>We don't perform initdb -- it is intentional and users are warned against this. <BR/><BR/>All distros use "ident sameuser" auth in prepackaged versions -- this is for security and IMHO there is no reason to change this behaviour.<BR/><BR/>Also, we don't use /etc for PostgreSQL config files -- it is not PostgreSQL's default. Per documents, it is under $PGDATA. It is Debian that changes this behaviour.<BR/><BR/>Sincerely,<BR/>--<BR/>Devrim GÜNDÜZ - PostgreSQL RPM MaintainerDevrim Gündüzhttp://www.blogger.com/profile/06310074761027270876noreply@blogger.comtag:blogger.com,1999:blog-14872114.post-68467856675810493012008-10-28T19:02:00.000-06:002008-10-28T19:02:00.000-06:00Interesting to know.Zaidahttp://catheeinsurance.blogspot.comnoreply@blogger.comtag:blogger.com,1999:blog-14872114.post-85131291275922117962008-10-27T09:18:25.269-06:002008-10-27T09:18:25.269-06:00You're welcome Veronica. I'm glad it was of help to someone :-)<BR/><BR/>RobertoRoberto Mellohttp://www.blogger.com/profile/12351821831652782671noreply@blogger.comtag:blogger.com,1999:blog-14872114.post-85286814488853409982008-10-27T00:53:00.000-06:002008-10-27T00:53:00.000-06:00Roberto,<BR/>thank you so much. I have been trying to connect to my Blackjack for months. All the instruction I found were too complicated to follow. Yours were great and dumb proof.<BR/>Thanks again.<BR/><BR/>VeronicaVeronicahttp://www.blogger.com/profile/12907227276790769979noreply@blogger.comtag:blogger.com,1999:blog-14872114.post-54721580937573934562008-07-29T08:29:00.000-06:002008-07-29T08:29:00.000-06:00I really enjoyed your description of the parintins feast.Keep going bros.Nice going.Best wishes , RonDr. Ronald Mellohttp://www.blogger.com/profile/16791562902612624019noreply@blogger.comtag:blogger.com,1999:blog-14872114.post-87080225145704967702008-07-23T16:32:00.000-06:002008-07-23T16:32:00.000-06:00Best Party Ever! Everyone is really getting into it. <I>Everyone</I>, in the whole stadium! And J looks really happy.the paulhttp://www.blogger.com/profile/04473135091883661753noreply@blogger.comtag:blogger.com,1999:blog-14872114.post-11642890998068173692008-07-14T05:24:47.495-06:002008-07-14T05:24:47.495-06:00I agree, but I understand what they were going for. Its hard to show a heart attack, but I didn't really like that picture. The baby-in-an-ashtray one could have been just a premature baby, leaving the whole ashtray thing out.<BR/><BR/>Another point to consider is that these pictures will be seen by many smokers who can't read, so the picture has to convey the whole message.Roberto Mellohttp://www.blogger.com/profile/12351821831652782671noreply@blogger.comtag:blogger.com,1999:blog-14872114.post-27168692610922227392008-07-13T22:51:00.000-06:002008-07-13T22:51:00.000-06:00Powerful images. I think they cheated a bit, though, in the pictures which showed cigarette butts in places where they obviously wouldn't really be. I actually feel like that would lessen the overall effect for me- I'd see them more as contrived propaganda instead of depictions of genuine consequences.the paulhttp://www.blogger.com/profile/04473135091883661753noreply@blogger.comtag:blogger.com,1999:blog-14872114.post-66215184231728893742008-07-05T11:23:26.436-06:002008-07-05T11:23:26.436-06:00I don't have many of that nature in the US. Most cases I've seen in the US were around Temple Square in Salt Lake City, and here and there on intersections.<BR/><BR/>Most people just walk or drive by. The only beggars I've seen receive money are those who were playing some musical instrument.<BR/><BR/>I do see a lot fewer people asking for money around the busy (and grid-locked) intersections of Manaus these days than almost 10 years ago, when I left to the U.S. The beggars have been mostly replaced by people seeling fruits, snacks, beverages, etc.<BR/><BR/>Maybe it's a reflection of the improvement on the Brazilian economy. Maybe the beggars went somewhere else.<BR/><BR/>Yesterday I was at an intersection and this cute 9-ish-year-old girl was selling cloth. She said to me "it's 3 for 5 reais sir" with a face that was just sooo needy it broke my heart. I ended up buying the cloth even though I really did not want any.Roberto Mellohttp://www.blogger.com/profile/12351821831652782671noreply@blogger.comtag:blogger.com,1999:blog-14872114.post-41218535614110718522008-07-05T01:06:00.000-06:002008-07-05T01:06:00.000-06:00How does that compare to your experiences of a similar nature in the US?thepaulhttp://www.blogger.com/profile/04473135091883661753noreply@blogger.comtag:blogger.com,1999:blog-14872114.post-77509534259203372672007-10-29T11:43:00.000-06:002007-10-29T11:43:00.000-06:00Hi ROberto,<BR/><BR/>I found your blog with google.<BR/>I am looking for the author of <BR/>http://forums.openqa.org/message.jspa?messageID=28153#28153<BR/><BR/>and I think you're on!<BR/><BR/>I was wondering if you could explain the winexplorer launcher you wrote. I am trying to use a custom launcher but it doesn't seem to work very well, it times out on wait_page_to_load ...<BR/><BR/>You can contact me at http://21croissants.blogspot.com/2006/01/contact-me.html<BR/><BR/>Thank you,<BR/><BR/>Jean-MichelJean-Michelhttp://www.blogger.com/profile/12541109166975793396noreply@blogger.comtag:blogger.com,1999:blog-14872114.post-760218645537448452007-10-04T11:40:09.307-06:002007-10-04T11:40:09.307-06:00Randy, I don't know how patents help to deal with ethical issues. Usually when I think of "ethical issues" I think of "abortion", "euthanasia" and other suchs topics.<BR/><BR/>The big question for me as an engineer -- and one which I tried to pose on this post -- is whether allowing trivial things to be patented is really protecting innovation. Who's the current software patent system really protecting or helping?<BR/><BR/>-RobertoRoberto Mellohttp://www.blogger.com/profile/12351821831652782671noreply@blogger.comtag:blogger.com,1999:blog-14872114.post-54612595135810715632007-10-03T20:21:00.000-06:002007-10-03T20:21:00.000-06:00IMO, the purpose of patents is not to protect against those who unknowingly infringe, they are to protect against competitors which knowingly do so.<BR/><BR/>For me, patents are a grey way to deal with ethical issues, and as engineers, it is natural for us to feel uncomfortable with the overall process.<BR/><BR/>Thanks for the read.Randy Secristnoreply@blogger.comtag:blogger.com,1999:blog-14872114.post-28831279488664782022007-05-30T16:09:00.000-06:002007-05-30T16:09:00.000-06:00Hmmm. Thinking about it in Windows land...<BR/><BR/>Download the package, unzip, and double-click the exe, during which, you are asked a number of questions about what to do when, where and why. No wonder people just "Next","Next","Next" as fast as they can. PostgreSQL installed. Time to reboot the machine.<BR/><BR/>Yup. Debian-based distros, taking advantage of apt, are *much* easier to install software than other package managers or operating systems.Aaron Toponcehttp://www.blogger.com/profile/09803144837381169974noreply@blogger.comtag:blogger.com,1999:blog-14872114.post-83586776117126878962007-05-28T14:41:00.000-06:002007-05-28T14:41:00.000-06:00Thanks again for being a fantastic tour guide. Brazil was simply amazing!<BR/><BR/>I have a dozen blogs I will post on our adventures, here's the first one:<BR/><A HREF="http://www.ryanbyrd.net/rambleon/?p=718" REL="nofollow">Brazilian Adventure</A>ryanbyrdhttp://www.blogger.com/profile/06013653197345634618noreply@blogger.comtag:blogger.com,1999:blog-14872114.post-73052438643774213892007-05-28T00:40:00.000-06:002007-05-28T00:40:00.000-06:00Even though it has been eleven years since I last visited Manaus, <A HREF="http://blog.cleverly.com/permalinks/290.html" REL="nofollow">I obviously need to start saving now</A>. Can you take (and post) some pictures of the temple site?Michaelhttp://www.blogger.com/profile/00128838005093704045noreply@blogger.comtag:blogger.com,1999:blog-14872114.post-62521456208772937922007-02-27T10:21:08.281-07:002007-02-27T10:21:08.281-07:00Here's a recent article I saw of which I was reminded when I read your post. It makes the claim that the vast majority of applicants for a typical software engineering position can't write code at all:<BR/><BR/>http://www.codinghorror.com/blog/archives/000781.html<BR/><BR/>My own experience has been similar. I wonder how much better those CS graduate interviewees could have been had they had a "no training wheels" class like the one taught by that Dr. Allan.paul cannonhttp://www.blogger.com/profile/05503230932209221337noreply@blogger.comtag:blogger.com,1999:blog-14872114.post-14843885369541496202007-02-27T06:26:38.497-07:002007-02-27T06:26:38.497-07:00Robert Oak's argument against raising the H1-B cap would have been a lot more believable to me if he had not focused so much on the "over 100k a year" argument.<BR/><BR/>As it is, it just sounds like a strawman rant to me. What I would like to have seen is how well Microsoft pays their H1-Bs, in comparison with their American workers. <BR/><BR/>What I can say as someone trying to hie in the software industry, I have a hard time finding good talent in the current tech boom.<BR/><BR/>Maybe it's a good thing for the overall global economy if the H1-B cap is not raised, or even reduced. The engineers who are currently coming to the U.S. to study and stay will go back to their countries of origin and work the very American companies they would work for here. Except they will leave those companies and start companies of their own in their countries of origin, instead of starting them in the U.S.<BR/><BR/>That will force American companies to improve in order to compete.Roberto Mellohttp://www.blogger.com/profile/12351821831652782671noreply@blogger.comtag:blogger.com,1999:blog-14872114.post-12461879287620545152007-02-26T23:26:09.469-07:002007-02-26T23:26:09.469-07:00Bill Gates also recently got in trouble when speaking about H1-B Visas:<BR/><BR/>http://arstechnica.com/news.ars/post/20070226-8924.htmlryanbyrdhttp://www.blogger.com/profile/06013653197345634618noreply@blogger.comtag:blogger.com,1999:blog-14872114.post-68475077786306839422007-02-22T23:18:46.738-07:002007-02-22T23:18:46.738-07:00Heheh, true, true. But that was a one-time shot. Beginner's luck. I am certain I can KO you next time without breaking a sweat.<BR/><BR/>I challenge you for a Friday match!Roberto Mellohttp://www.blogger.com/profile/12351821831652782671noreply@blogger.com