[GENERAL] Looking for professionals for a PG server move
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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Error during make when installing geos for postgis install...still trying
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/pgdg-redhat-8.4-1.noarch.rpm # yum install postgresql-server postgis postgis-utils compat-postgresql-libs done. replace the first line if you want to run a different PG version with any of URLs, http://yum.pgsqlrpms.org/reporpms/repoview/pgdg-redhat.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Save MySQL? HA
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 since 1997 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] please help
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 happen here. You will learn a LOT that way. -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Looking for professionals for a PG server move
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 backup and restore? Like Absolutely no down time? Or its a 50 Terabyte database? Or both? What problems are you having? On the new box, pg_dump the database from the old box, then restore it on the new. Did you try this? -Andy -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Re: Error during make when installing geos for postgis install...still trying
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 anyone tell us where the issue is? [r...@zoa-project postgis-1.4.1]# ./configure checking build system type... i686-pc-linux-gnu ...snip.. checking for gcc... (cached) gcc checking for g++... no checking for c++... no checking for gpp... no checking for aCC... no checking for CC... no checking for cxx... no checking for cc++... no checking for cl.exe... no checking for FCC... no checking for KCC... no checking for RCC... no checking for xlC_r... no checking for xlC... no checking whether we are using the GNU C++ compiler... no checking whether g++ accepts -g... no checking whether we are using the GNU C++ compiler... (cached) no checking whether g++ accepts -g... (cached) no See.. You don't have g++ installed. You may have the package installed... but something is broke... there is no c++ compiler. -Andy -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] please help
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=UTF8s=booksqid=1262365492sr=8-2 I will second Craig's recommendation, though, since good PostgreSQL books are hard to find, for some reason. - Rilindo On Jan 1, 2010, at 6:54 AM, Craig Ringer wrote: 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 happen here. You will learn a LOT that way. -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Error during make when installing geos for postgis install...still trying
Nick nick.uebel...@noaa.gov 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 a --with-geosconfig parameter. It's telling you exactly what the problem is and what to do about it. [r...@zoa-project postgis-1.4.1]# find / | egrep -i geos-config /usr/local/geos-3.2.0/tools/geos-config.in /usr/local/geos-3.2.0/tools/geos-config What you'd probably need here is --with-geosconfig=/usr/local/geos-3.2.0/tools or else persuade geos to install itself in a more standard place. But I concur with the suggestions to install RPMs built by someone else, instead. In a Red Hat system it's just a lot easier to manage software that's packaged that way than to deal with loose software. If you really feel a need to do it yourself, why don't you download Devrim's SRPMs and build RPMs from those? You could study the spec files to see what you missed while trying to do it by hand. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Query very slow when in plpgsql function
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 part of the UK. chris -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Benetl, a free ETL tool for files using postgreSQL, is out in version 3.3
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 for your interest. Regards -- Benoît Carpentier www.benetl.net Founder of Benetl Java project manager -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Looking for professionals for a PG server move
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, 2010 at 12:06 AM, Andy Colson a...@squeakycode.net wrote: 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 backup and restore? Like Absolutely no down time? Or its a 50 Terabyte database? Or both? What problems are you having? On the new box, pg_dump the database from the old box, then restore it on the new. Did you try this? -Andy -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Looking for professionals for a PG server move
Phoenix Kiula phoenix.ki...@gmail.com 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. If you want forgiving, maybe you should run your database in SQL_ASCII mode. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
