Jayadevan M, 25.10.2012 05:15:
There are tools which generate data, but most of them seem to
generate junk data.
Have a look a Benerator. It can create quite reasonable test data (e.g. valid addresses,
"real" looking names and so on).
It has a bit steep learning curve, but I'm quite happy wit
Hi, I'm trying to upgrade from 9.1 to 9.2 but lc_collate issue is very
difficult to solve, How I know the old lc_collate? I've only could grepped
old settings lc_numeric, lc_time, lc_messages and lc_monetary all them =
'C' but I don't know what lc_collate was or how to find it. please help.
Thanks
Hi, I'm trying to upgrade from 9.1 to 9.2 but lc_collate issue is very
difficult to solve, How I know the old lc_collate? I've only could grepped
old settings lc_numeric, lc_time, lc_messages and lc_monetary all them =
'C' but I don't know what lc_collate was or how to find it. please help.
Thanks
I could after some work, what I want to ask now is this:
In the middle of the pg_restore process I had to stop it (^Z) and remove
one problematic and not needed database from the
generated pg_upgrade_dump_db.sql file and then continue the process with
fg, of course it failed BUT: I started the new
Hello all,
Does anyone know of reasonably-sized data dumps (csv or excel or xml..) that
can be used for learning/teaching about performance tuning. Say - a set of 6-7
tables, may be two of them with a few million records etc? Total data volume
would be in a few GB range. There are tools which ge
On 10/24/12 2:41 PM, Toni wrote:
La aplicación HL-DBExporter (PostgresSQL a MySQL) permite
exportar,convertir,transferir, migrar datos de una base de datos
PostgreSQL a otra base de datos MySQL.
googlelated -> "The HL-DBExporter application (PostgreSQL to MySQL)
allows export, convert, t
PostgreSQL a MySQL
HL-DBExporter (PostgreSQL a MySQL)
www.hlevelsoft.com/index.php/es/postgres/postgresql-mysqlb
La aplicación HL-DBExporter (PostgresSQL a MySQL) permite
exportar,convertir,transferir, migrar datos de una base de datos PostgreSQL a
otra base de datos MySQL.
Puede trabaja
I have been struggling mightily to get pgagent working on our system, with no
success, and would appreciate any instructions or advice. I have spent hours
searching the net for insight, but so far nothing has helped get me over the
hump.
It would be gratifying if someone could simply reassure
On Thu, 25 Oct 2012 03:56:39 +1100, Chris Angelico said:
> On Thu, Oct 25, 2012 at 2:42 AM, Steve Litt
> wrote:
> > Also, with the organization they're using, one can make new
> > "columns" on the fly. ... Anyway, the keypuncher is punching
> > data, comes across a brand new type of data (let's sa
Shaun Thomas escribió:
> On 10/24/2012 02:57 PM, Eliot Gable wrote:
>
> >In general, autovacuum seems to work well on most of the tables I deal
> >with. However, in a couple of specific cases, it seems to fail
> >miserably. I would like to switch to manual vacuuming on those tables
> >and disable
Eliot Gable escribió:
> In general, autovacuum seems to work well on most of the tables I deal
> with. However, in a couple of specific cases, it seems to fail miserably. I
> would like to switch to manual vacuuming on those tables and disable
> auto-vacuuming for those tables alone. Is this possib
On 10/24/2012 02:57 PM, Eliot Gable wrote:
In general, autovacuum seems to work well on most of the tables I deal
with. However, in a couple of specific cases, it seems to fail
miserably. I would like to switch to manual vacuuming on those tables
and disable auto-vacuuming for those tables alone
In general, autovacuum seems to work well on most of the tables I deal
with. However, in a couple of specific cases, it seems to fail miserably. I
would like to switch to manual vacuuming on those tables and disable
auto-vacuuming for those tables alone. Is this possible? I searched the
docs and th
> > data=# \o /tmp/datos_para_proceso.csv
> > data=# select * from datos_para_proceso;
> > /opt/PostgreSQL/9.2/bin/psql: línea 30: 9608 Terminado (killed)
> > LD_PRELOAD=$PLL LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$PG_BIN_PATH/../lib
> > "$PG_BIN_PATH/psql.bin" "$@"
Moshe Jacobson escribió:
> More i
Hola Alejandro
Muchas gracias!! la verdad no me acordaba que el copy podía funcionar en
doble via!!!
2012/10/24 Alejandro Carrillo
> http://www.postgresql.org/docs/current/static/sql-copy.html
>
> --
> *De:* Hellmuth Vargas
> *Para:* Lista Postgres ES ;
> pgsql-
More important than the solution to this specific problem is the question
of why psql crashed when doing this export...
2012/10/24 Alejandro Carrillo
> http://www.postgresql.org/docs/current/static/sql-copy.html
>
> --
> *De:* Hellmuth Vargas
> *Para:* Lista Postgr
http://www.postgresql.org/docs/current/static/sql-copy.html
>
> De: Hellmuth Vargas
>Para: Lista Postgres ES ;
>pgsql-general@postgresql.org
>Enviado: Miércoles 24 de octubre de 2012 12:22
>Asunto: [pgsql-es-ayuda] como exportar separado por comas una tabla gr
Hola Lista
tengo una tabla con la siguiente estructura
CREATE TABLE datos_para_proceso
(
id bigint,
identificador character varying,
nombre character varying(255),
nombreusuario text,
identificacion character varying(255),
tema character varying(255),
notatema text,
subtema chara
On Thu, Oct 25, 2012 at 2:42 AM, Steve Litt wrote:
> Also, with the organization they're using, one can make new "columns"
> on the fly. ... Anyway, the keypuncher is punching
> data, comes across a brand new type of data (let's say "artist"), so
> for this row the keypuncher puts in a key-value p
On Wed, Oct 24, 2012 at 8:04 AM, Chris Angelico wrote:
> On Tue, Oct 23, 2012 at 9:51 AM, Scott Marlowe
> wrote:
>> On Mon, Oct 22, 2012 at 7:17 AM, Chris Angelico wrote:
>>> After reading the comments last week about SSDs, I did some testing of
>>> the ones we have at work - each of my test-bo
Hello,
I think you might need to have a look on a binary replication and Pgpool ii
Regards
From: Mino Haluz
To: pgsql-general@postgresql.org
Sent: Wednesday, October 24, 2012 2:28 PM
Subject: [GENERAL] Postgresql high available solution
Hi,
we would lik
On Tue, 23 Oct 2012 18:52:52 +, Gauthier, Dave said:
> Here's the deal...
>
> Instead of architecting and loading a table like...
> create teble foo (col1 text, col2 text, col3 text, col4 text, col5
> text); insert into foo (col1,col2,col3,col4,col5) values
> ('c1',null,'c3','c4',null);
>
> T
On Tue, Oct 23, 2012 at 9:51 AM, Scott Marlowe wrote:
> On Mon, Oct 22, 2012 at 7:17 AM, Chris Angelico wrote:
>> After reading the comments last week about SSDs, I did some testing of
>> the ones we have at work - each of my test-boxes (three with SSDs, one
>> with HDD) subjected to multiple sta
What's the current status on installs of PostGis with Postgres 9.2? Can I run
PostGIS 1.5 and/or PostGIS 2.0 with Postgres 9.2?
I noticed StackBuilder does not include PostGis with Postgres 9.2, but does
include it (PostGis 1.5) with Postgres 9.1.
I'm running Postgres 9.1 on a Mac OSX 10.7 (In
Hi,
we would like to switch from mysql cluster to postgresql. We need high
available solution so we can store telco data for our PBXes. The
problem is, we dont know what would best suit to our needs, we need:
1) High availability with failover - if one node goes down, nothing
bad happens (<5sec d
Hi,
In my case is different. i have only 2 DB login user.. say postgres and
dbuser1
My other friends login into this db server using different app server say
app1,app2.
Their user names are osuser1,osuser2
I want to know who is logging via which server and what db they are access
and what que
Not sure. But you can always avoid the OS authentication with empty user and
password to access Oracle.
You can use other authentication mode to access oracle instead.
--
Thanks&Regards,
Xiong He
-- Original --
From: "Papiernik Anna-A
27 matches
Mail list logo
