Re: Postgre Architecture

Lists: pgsql-general
From: Cláudia Morgado <claudia(dot)morgado(at)widesoft(dot)com(dot)br>
To: <pgsql-general(at)postgresql(dot)org>
Cc: "Carla Mello" <carla(dot)mello(at)widesoft(dot)com(dot)br>
Subject: Postgre Architecture
Date: 2003-11-11 12:28:17
Message-ID: 00d701c3a84f$4965d8c0$15011aac@widesoft.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Hello!

We working currently with the Oracle and we would like to know if postgresql has some similar components as the concept of instance, buffer database cache, Redo log buffer, datafiles, background process, etc.

How postgre works? It works in memory?

There is some figure that ilustrates your architecture?

regards,
Carla Mello e Cláudia Morgado.

From: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
To: Cláudia Morgado <claudia(dot)morgado(at)widesoft(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org, Carla Mello <carla(dot)mello(at)widesoft(dot)com(dot)br>
Subject: Re: Postgre Architecture
Date: 2003-11-12 18:05:16
Message-ID: 3FB2765C.6020109@trade-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
<br>
<br>
you may check<br>
<li><br>
</li>
<li><a
href="http://developer.postgresql.org/docs/pgsql/src/tools/backend/index.html">Flowchart
of the
PostgreSQL backend</a>
</li>
<li><a href="http://developer.postgresql.org/pdf/internalpics.pdf">Database
Internals Presentation</a>
</li>
<li><a href="http://developer.postgresql.org/osdn.php">The
Implementation of PostgreSQL</a>
</li>
<br>
in the URL below<br>
<br>
<a class="moz-txt-link-freetext" href="http://developer.postgresql.org/">http://developer.postgresql.org/</a><br>
<br>
<br>
Regds<br>
Mallah.<br>
<br>
Cl&aacute;udia Morgado wrote:<br>
<blockquote type="cite"
cite="mid00d701c3a84f$4965d8c0$15011aac(at)widesoft(dot)com(dot)br">
<meta http-equiv="Content-Type" content="text/html; ">
<meta content="MSHTML 6.00.2600.0" name="GENERATOR">
<style></style>
<div><font face="Arial" size="2"><strong><em>Hello!</em></strong></font></div>
<div>&nbsp;</div>
<div><font face="Arial" size="2">We working currently with the Oracle
and we would like to know if&nbsp;postgresql has some similar components as
the&nbsp;concept of&nbsp;instance, buffer database cache, Redo log buffer,
datafiles, background process, etc. </font></div>
<div>&nbsp;</div>
<div><font face="Arial" size="2">How&nbsp;postgre works? It works in
memory?</font></div>
<div>&nbsp;</div>
<div><font face="Arial" size="2">There is some figure that ilustrates
your architecture?</font></div>
<div>&nbsp;</div>
<div><font face="Arial" size="2">regards,</font></div>
<div><font face="Arial" size="2">Carla Mello e Cl&aacute;udia Morgado.</font></div>
<div>&nbsp;</div>
</blockquote>
<br>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 1.8 KB
From: Cláudia Morgado <claudia(dot)morgado(at)widesoft(dot)com(dot)br>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Pass data of database Oracle to PostgreSQL
Date: 2004-01-12 19:12:25
Message-ID: 010601c3d940$04149d20$15011aac@widesoft.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Hello!!
Somebody could help me to pass the data that are of a database Oracle 8i for my new database Postgre 7.3.4 (linux).
Regards,
Cláudia
-----------------------------------------------------------------------------------------
Cláudia Morgado cmorgado(at)widesoft(dot)com(dot)br
Banco de Dados
Fone: (19) 3451-6300 www.widesoft.com.br
-----------------------------------------------------------------------------------------

From: "Dieter Fischer" <dieter(dot)fischer(at)grid-it(dot)ch>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Pass data of database Oracle to PostgreSQL
Date: 2004-01-19 08:48:38
Message-ID: 001301c3de69$09525970$0f00a8c0@DFP
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Hello Claudia

Have a look at http://www.samse.fr/GPL/ora2pg/

Regards

Dieter

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Cláudia Morgado
Sent: Monday, January 12, 2004 8:12 PM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] Pass data of database Oracle to PostgreSQL

Hello!!
Somebody could help me to pass the data that are of a database Oracle 8i
for my new database Postgre 7.3.4 (linux).
Regards,
Cláudia
------------------------------------------------------------------------
-----------------
Cláudia Morgado cmorgado(at)widesoft(dot)com(dot)br
Banco de Dados
Fone: (19) 3451-6300 www.widesoft.com.br
------------------------------------------------------------------------
-----------------

From: Thierry Missimilly <THIERRY(dot)MISSIMILLY(at)BULL(dot)NET>
To: Cláudia Morgado <claudia(dot)morgado(at)widesoft(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Pass data of database Oracle to PostgreSQL
Date: 2004-01-19 10:20:39
Message-ID: 400BAF77.D276F435@BULL.NET
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

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 database Postgre 7.3.4 (linux).
> Regards,
> Cláudia
> ------------------------------------
> ----------------------------------------------------
> Cláudia Morgado cmorgado(at)widesoft(dot)com(dot)br
> Banco de Dados
> Fone: (19) 3451-6300 www.widesoft.com.br
>
> ----------------------------------------------------------------------------------------
>

Attachment Content-Type Size
THIERRY.MISSIMILLY.vcf text/x-vcard 327 bytes
From: Thierry Missimilly <THIERRY(dot)MISSIMILLY(at)BULL(dot)NET>
To: Cláudia Morgado <claudia(dot)morgado(at)widesoft(dot)com(dot)br>
Cc: cmmello(at)wide(dot)com(dot)br, pgsql-general(at)postgresql(dot)org
Subject: Re: Pass data of database Oracle to PostgreSQL
Date: 2004-01-23 09:02:34
Message-ID: 4010E32A.CB9E409D@BULL.NET
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Hi,

I'm not sure to well understand your problem.
But, Ora2pg need 3 modules :
- Two of them : DBI-1.38 and DBD-Pg-1.22 have to be comile and install
from your Postgres environnement. For example /home/postgres.
- And DBD-Oracle-1.14 has to be compile and install in your Local Oracle
environment. For example : /home/oracle. With the Oracle Shell variables
set :
$ORACLE_BASE
$ORACLE_HOME

Futher more, the script ora2pg need in the first lines the setting of
your local host ORACLE_HOME, for example :
$ENV[ORACLE_HOME]='/home/oracle/product/9.2.0'

That means that if your Postgres Database is on serverA and you want to
migrate an Oracle database form serverB, you have to have an Oracle
client on ServerA and set the Perl variables as these :
my $dbsrc = 'dbi:Oracle:host=serverB;sid=advisor2; port=1521';
my $dbuser = 'system';
my $dbpswd = 'syspasswd'

If you don't have an Oracle Client Licence on serverA. It is more
complex. I think in that case, that a better idea is to install Postgres
on ServerB, do the migration, dump the Postgres migrate DB, and restore
the dump on ServerA.
One more thing, I have noted that a same DB takes 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 Perl DBD:Oracle occurred.
> It sees the error below:
> " The ORACLE_HOME environment variable must be set.
> It must be set to hold the path to an Oracle installation directory
> on this machine (or a machine with a compatible architecture).
> See the README.clients file for more information.
> ABORTED!" The migration that we are making is of the database
> Oracle 8i for PostgreSQL 7.4.1, being that the database are installed
> in different servers. How we can continue in this
> installation? regards,Carla e Cláudia
>
> ----- Original Message -----
> From: Thierry Missimilly
> To: Cláudia Morgado
> Cc: pgsql-general(at)postgresql(dot)org
> Sent: Monday, January 19, 2004 8:20 AM
> Subject: Re: [GENERAL] Pass data of database Oracle to
> PostgreSQL
> 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 database Postgre 7.3.4
> > (linux).
> > Regards,
> > Cláudia
> > -----------------------------------------------------------------------------------------
> >
> > Cláudia Morgado cmorgado(at)widesoft(dot)com(dot)br
> > Banco de Dados
> > Fone: (19) 3451-6300 www.widesoft.com.br
> >
> > ----------------------------------------------------------------------------------------
> >

Attachment Content-Type Size
THIERRY.MISSIMILLY.vcf text/x-vcard 327 bytes
From: "Carla Mello" <carla(dot)mello(at)widesoft(dot)com(dot)br>
To: "Thierry Missimilly" <THIERRY(dot)MISSIMILLY(at)BULL(dot)NET>, Cláudia Morgado <claudia(dot)morgado(at)widesoft(dot)com(dot)br>
Cc: <cmmello(at)wide(dot)com(dot)br>, <pgsql-general(at)postgresql(dot)org>
Subject: Executing dynamic queries (EXECUTE)
Date: 2004-01-26 21:19:23
Message-ID: 00f701c3e452$12a59ac0$16011aac@widesoft.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general


Hello!

I need to execute a dynamic query and capture your result in a integer variable.

I´m using the statement "EXECUTE string", but I don´t obtain to capture the result of dynamic query.

See the example:

======================================================
create or replace function f_population_check() returns bigint as
'
declare
v_tot bigint;
v_query varchar(4000);
v_count integer;
r record;
begin
v_tot:= 0;
for r in select * from pg_tables loop
v_count:= 0;
v_query := ''select count(*) from '' || r.tablename;
v_count:= EXECUTE v_query;
if v_count = 0 then
RAISE NOTICE ''Empty table % '',r.tablename;
end if;
v_tot:= v_tot + 1;
end loop;
return v_tot;
end;
'
language 'plpgsql';

======================================================
ERROR: parse error at or near "$1" at character 18
CONTEXT: PL/pgSQL function "f_population_check" line 11 at assignment

======================================================
Somebody could help me?
Thanks, Carla Mello.