I'll be very happy if someone had used it in a Perl script and send me
an example.
Best regards
Thierry Missimilly
--- End Message ---
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send &
Rodrigo Carvalhaes a écrit :
Hi!
I am using PostgreSQL with a proprietary ERP software in Brazil. The
database have around 1.600 tables (each one with +/- 50 columns).
My problem now is the time that takes to restore a dump. My customer
database have arount 500mb (on the disk, not the dump file)
disks RAID0 LUN with PG
7.4, pg_dump takes about 17 min and pg_restore takes about 67 min.
I hope that these info will help you.
Thierry Missimilly
Colm De Barra wrote:
HiI've
built up 30 gig database on a performance test machine whichnow
needs to be transferred over onto the production har
akes at least twice disk
space on Postgres than on Oracle. I haven't still, dicovered why.
Thierry Missimilly
Cláudia Morgado wrote:
Hi
, We still
don´t obtain to user the Ora2pg.pl. :(
In the installation of the requirement ones of the Ora2pg.pl a problem
in the compilation of module P
Hi Claudia,
I have done a successuff schema and data migration from Oracle 8i to
PostgreSQL 7.4 by using the contrib : postgresql-7.4/contrib/Oracle/ora2pg
Regards,
Thierry
Cláudia Morgado wrote:
Hello!!
Somebody
could help me to pass the data that are of a database Oracle 8i for my
new dat
Jon,
I have tried a little bench with pgbench on my 2 proc 2.4 Gb with 4 GB RAM and Linux
RH 9.0.
The database size is 700 MB, so it can be loaded in memory.
Postgres 7.4 is on disk sda (Root disk)
Meta Data are on disk sdb
bench data are on disk sdc
When pgbench is running, i can see with top t
Jonathan,
Could you tell me what is the real impact of "fsync=false" on the WAL and on the
database in the same catastrophic scenario ?
Thierry Missimilly
Jonathan Bartlett wrote:
> WAL is write-ahead logging. Basically, before the database actually
> performs an operation, it
Hi,
I have got an error with PostgreSQL-7.4Beta4 :
ERROR SET AUTOCOMMIT TO OFF is no longer supported
I used these option to load huge Database as i can save time with it. Is
there an other option in PG 7.4 to do the same ?
Regards
Thierry Missimilly
begin:vcard
n:Missimilly;Thierry
tel;fax
PLATE
Your name : Thierry Missimilly
Your email address : [EMAIL PROTECTED]
System Configuration
-
Architecture (example: Intel Pentium) : Pentium IV 1.8 Ghz
Operating System (example: Linux 2.0.26 ELF) : Linux Red Hat 7.3
PostgreSQL ve
I've try the trail version of PostgreSQL Manager by EMS
http://www.ems-hitec.com/pgmanager . But it is not free but not very
expensive (aboot 200$). It is a good tools.
I've try PgAdmin III on Windows 2000 . It's very good and free.
http://www.ems-hitec.com/pgmanager
You should get both and see w
:48:19PM +0200, Thierry Missimilly wrote:
> > I'm not sure it's a bug or it's normal, so i don't send it to pgsq-bugs.
> > ...
> > So, i use #ifdef ORACLE #else #endif preprocessing instructions to
> > differentiate PG from Oracle Pro*c syntaxes.
>
Hi,
I'm not sure it's a bug or it's normal, so i don't send it to pgsq-bugs.
Well, i have written pgbench in PRO*C to have a common pgbench.pgc
source for Postgres and Oracle.
However, there are some differences between the Postgres Pro*c and
Oracle Pro*c.
So, i use #ifdef ORACLE #else #endif
Hi,
As i haven't got any reply on my message, i re-post it, as i think it
can help 7.4 developpers.
Thierry Missimilly
--- Begin Message ---
Hi,
I've got the tar ball postgresql-7.4beta1.tar.gz and tried to build
it on i686-pc-linux with a RedHat 7.3.
1) configure --with-tcl --ena
13 matches
Mail list logo
