Re: [GENERAL] Looking for professionals for a PG server move

2010-01-01 Thread Tom Lane
Phoenix Kiula writes: > Biggest problem is utf-8 crap. Some other databases are much more > forgiving of the data. PG takes utf-8 data but somehow gives problem > with backup/restore. I've tried everything, including iconv etc, but > this truly could be a lot better in the future versions I hope.

Re: [GENERAL] Looking for professionals for a PG server move

2010-01-01 Thread Phoenix Kiula
Andy Biggest problem is utf-8 crap. Some other databases are much more forgiving of the data. PG takes utf-8 data but somehow gives problem with backup/restore. I've tried everything, including iconv etc, but this truly could be a lot better in the future versions I hope. Thanks. On Sat, Jan 2

[GENERAL] Benetl, a free ETL tool for files using postgreSQL, is out in version 3.3

2010-01-01 Thread benoƮt carpentier
Dear all, Benetl, a free ETL tool for files using postgreSQL, is out in version 3.3. You can freely download it at: www.benetl.net This version brings two new improvements, you should update. You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load Thanks

Re: [GENERAL] Query very slow when in plpgsql function

2010-01-01 Thread Chris McDonald
Thanks for your assistance guys, and special thanks to Greg for his blog page. This is exactly my problem which is resolved using dynamic SQL. I can now see how the function was behaving badly, and have been able to fix the query. Once again, thanks guys - and Happy New Year from a snow-covered pa

Re: [GENERAL] Error during make when installing geos for postgis install...still trying

2010-01-01 Thread Tom Lane
Nick writes: > Still having problems installing the geos file when trying to install > postgis...have a printout of errors we are still getting > checking for geos-config... no > configure: error: could not find geos-config within the current path. > You may need to try re-running configure with

Re: [GENERAL] please help

2010-01-01 Thread Rilindo Foster
Funny thing, a workmate ask me about this same type of question. I found this book to be useful. http://www.amazon.com/Beginning-Databases-PostgreSQL-Novice-Professional/dp/1590594789/ref=sr_1_2?ie=UTF8&s=books&qid=1262365492&sr=8-2 I will second Craig's recommendation, though, since good Postg

[GENERAL] Re: Error during make when installing geos for postgis install...still trying

2010-01-01 Thread Andy Colson
On 12/31/2009 06:35 PM, Nick wrote: Still having problems installing the geos file when trying to install postgis...have a printout of errors we are still getting computer/compiler/postgis info rhel 5, gcc-4.1.2-46el14.4.1 postgis1.4.0 below is our process and the errors we are getting, can

Re: [GENERAL] Looking for professionals for a PG server move

2010-01-01 Thread Andy Colson
On 01/01/2010 02:01 AM, Phoenix Kiula wrote: From 8.2.9 on a 32 bit Linux CentOS server to a different server (Cpanel/WHM) which is now running 8.4.2 with 64 bit CentOS. Truly appreciate any pointers or recommendations of good folks who can do this, or have done this. Thanks! Ahh? Above a b

Re: [GENERAL] please help

2010-01-01 Thread Craig Ringer
Shu Ho wrote: > Dear sir, > I work as a new DBA in postgresql, please recommend some good books, > website for tutorial. The best starting point is the PostgreSQL documentation: http://postgresql.org/docs Additionally, remain subscribed to this mailing list, and read the discussions that happe

Re: [GENERAL] Save MySQL? HA

2010-01-01 Thread Joshua D. Drake
> Monty made his be, let him lie in it. I repeat, this if off-topic. Please drop it. Joshua D. Drake -- PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving s

Re: [GENERAL] Error during make when installing geos for postgis install...still trying

2010-01-01 Thread John R Pierce
Nick wrote: Don't mean to keep asking the same question over and over, I'm new at this. Happy New Year, mine would be much happier if I could have this all installed now!! delete all that stuff you've been trying to build the hard way. # rpm -Uvh http://yum.pgsqlrpms.org/reporpms/8.4/p

[GENERAL] Looking for professionals for a PG server move

2010-01-01 Thread Phoenix Kiula
>From 8.2.9 on a 32 bit Linux CentOS server to a different server (Cpanel/WHM) which is now running 8.4.2 with 64 bit CentOS. Truly appreciate any pointers or recommendations of good folks who can do this, or have done this. Thanks! -- Sent via pgsql-general mailing list (pgsql-general@postgres