Re: [ADMIN] uuid extension not available

2013-10-11 Thread Christofer C. Bell
On Thu, Oct 10, 2013 at 8:09 AM, Thara Vadakkeveedu wrote: > > > > [root@perf277 ~]# yum install postgresql92-contrib.x86_64 > Loaded plugins: product-id, security, subscription-manager > This system is not registered to Red Hat Subscription Management. You can use > subscription-manager to regis

Re: [ADMIN] convert from latin1 to utf8

2013-10-11 Thread Marc Fromm
Using locale=c worked. Thanks!!! I did try creating the databases that were latin1 on the new server run 8.4 as utf8 and then do the restore (without using locale=c during intidb) and it almost worked. Most of the latin1 databases were imported with their tables and data. I don’t know what stop

Re: [ADMIN] Mysql to Postgresql

2013-10-11 Thread Payal Singh
Hey, There are a couple of free tools to convert mysql dumps to postgresql dumps. Although these do not cater to functions and stored procedures. They will need to be converted manually. For the rest, you can have a look at: https://github.com/ahammond/mysql2pgsql (Perl) http://rubygems.org/gems/my

[ADMIN] Mysql to Postgresql

2013-10-11 Thread alfred
Hi i want to convert mysql to postgresql , any free tools available?. Is it possible to convert manually. Please guide me best regards Alfred -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] Re: PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 300000000 large objects

2013-10-11 Thread luckyjackgao
Hello I have encountered some issues of PG crash when dealing with too much data. It seems that PG tries to do its task as quckly as it can be and will use as much resource as it can. Later I tried cgroups to limit resource usage to avoid PG consuming too much memory etc. too quickly. And PG wo