[GENERAL] Out of memory using ora2pg

Hi, I try to migrate an Oracle database 9.2.0.5 ( one schema) to an Postgresql (8.1.3) database. I use ora2pg to do this ... When I use it after a while I get the following error: MONTANTTVARECUP => type:NUMBER , length:22, precision:, scale:, nullable:Y , default: DTCREA => typ

Re: [GENERAL] TSearch2 from HEAD UTF8 German Compunds.

hey theodor, the dicts are ony one half of the solution, aren't they? i also want to use the UTF8 stemmers from the snowball project so i have to take them from their "libstemmers", right? i haven't found instructions on how to use gendict libstemmers (btw: i am using tsearch2 from CVS HEAD

Re: [GENERAL] Out of memory using ora2pg

[EMAIL PROTECTED] wrote: Is it a problem with perl memory or posgresql memory ? Can you hellp me please ? What does "top" show for memory usage of the processes in question? How much memory do you have in the machine? -- Richard Huxton Archonet Ltd ---(end of bro

Re: [GENERAL] Postgresql Replication

Nareen S wrote: Current Setup I am having a Mailserver running on Postfix.For the same I had configured a High Availability Solution using Heartbeat and DRBD for replication.Thesetup is like Primary/Secondary Node Servers and all mails are replicated to secondary using DRBD.If primary server fai

Re: [GENERAL] TSearch2 from HEAD UTF8 German Compunds.

You should use libstemmer_c/src_c/stem_UTF_8_german.[ch] and tsearch2/gendict/config.sh script to generate stemmer for UTF8 as usial: Thies C. Arntzen wrote: hey theodor, the dicts are ony one half of the solution, aren't they? i also want to use the UTF8 stemmers from the snowball project

Réf. : Re: [GENERAL] Out of memory using ora2pg

Thanks for the answer... the configuration is as below: Oracle > Ora2pg> PostgreSQL Windows 2000Linux Windows 2000 500 MB 3 GB256 MB Ora2pg.pl is executed on linux top gives for porcess ora2pg.pl VIRTRES 44272 28m T

Réf. : Re: [GENERAL] Out of memory using ora2pg

Thanks fro your answer ... TRANSACTIONS has 55412 rows to much ?? "E. Lefty Kreouzis" <[EMAIL PROTECTED]> 22/02/2006 12:38 Pour : [EMAIL PROTECTED] cc :pgsql-general@postgresql.org Objet : Re: [GENERAL] Out of memory using ora2pg > Hi, > > > I try to migrat

Re: [GENERAL] How do I use the backend APIs

Thanks Martijn/Alban, This look interesting. I'll make some time to try this problem out using your approach. I have a few questions like: -Could I skip the FETCH FORWARD and go straight to the FETCH BACKWARD i.e. declare cursor to be at "Mal" and go backwards from there or is the cursor limited t

Re: [GENERAL] Postgresql Replication

Richard Huxton wrote: > Nareen S wrote: >> Current Setup >> I am having a Mailserver running on Postfix.For the same I had configured a >> High Availability Solution using Heartbeat and DRBD for >> replication.Thesetup is like Primary/Secondary Node Servers and all >> mails are replicated to >> s

Re: [GENERAL] Réf. : Re: [GENERAL] Out

[EMAIL PROTECTED] wrote: Thanks for the answer... the configuration is as below: Oracle > Ora2pg> PostgreSQL Windows 2000Linux Windows 2000 500 MB 3 GB256 MB Ora2pg.pl is executed on linux top gives for porcess ora2pg.pl

Re: [GENERAL] How do I use the backend APIs

Chad wrote: Thanks Martijn/Alban, This look interesting. I'll make some time to try this problem out using your approach. I have a few questions like: -Could I skip the FETCH FORWARD and go straight to the FETCH BACKWARD i.e. declare cursor to be at "Mal" and go backwards from there or is the cu

Re: [GENERAL] Attn. PostgreSQL.org webmasters: Site Link not working

On Tue, 2006-02-21 at 17:24, Sanjay Arora wrote: > Page: http://www.postgresql.org/docs/faqs.FAQ.html > > > Section 2.3 GUI Tools Link > http://techdocs.postgresql.org/guides/GUITools > > > Proxy Er

Re: [GENERAL] Attn. PostgreSQL.org webmasters: Site Link not working

> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Robert Treat > Sent: 22 February 2006 14:35 > To: Sanjay Arora > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Attn. PostgreSQL.org webmasters: Site > Link not working > > > It's a kno

Re: [GENERAL] Out of memory using ora2pg

[EMAIL PROTECTED] writes: > Dumping table TRANSACTIONS... > DBD::Pg::st > execute failed: ERROR: out of memory > DETAIL: Failed on request of size 16. > ERROR: out of memory > DETAIL: Failed on request of size 16. > Is it a problem with

[GENERAL] ecpg error --> DbPg_cre_sect_buf.pgc:1334: ERROR: syntax error at or near "RELEASE"

I'm relatively new to database programming & I've inherited a system to maintain that contains lots of embedded SQL. I'm attempting to port my C source code from RH 7.2 (with ecpg 2.8.0) to Mandrake 10.0 (with ecpg 4.1.1). ecpg 4.1.1 is generating an error which I did not get on the RH7.2 sy

Re: [GENERAL] ecpg error --> DbPg_cre_sect_buf.pgc:1334: ERROR:

[EMAIL PROTECTED] writes: > I'm relatively new to database programming & I've inherited a system to > maintain that contains lots of embedded SQL. I'm attempting to port my C > source code from RH 7.2 (with ecpg 2.8.0) to Mandrake 10.0 (with ecpg > 4.1.1). ecpg 4.1.1 is generating an error whic

[GENERAL] PG 8 stop working !?

Hello,   I've a development workstation using Win XP Pro SP2 with PostgreSQL 8.1 win32. This box use P4 3.2 Ghz, 1 Go RAM, 160 Go disk, no hardware problem detected. From several weeks PG seem to start (it appear as started in the services), but when I want to use PG it hangs in the connexio

Réf. : Re: [GENERAL] Out of memory using ora2pg

I tried with less tables and it works now thanks again for your help Tom Lane <[EMAIL PROTECTED]> 22/02/2006 15:58 Pour : [EMAIL PROTECTED] cc :pgsql-general@postgresql.org Objet : Re: [GENERAL] Out of memory using ora2pg [EMAIL PROTECTED] writes: > Du

Fw: [GENERAL] ecpg error --> DbPg_cre_sect_buf.pgc:1334: ERROR: syntax error at or near "RELEASE"

>I think you should omit the word "RELEASE" after the > "ROLLBACK". Will this still result in the closed DB connection that the "ROLLBACK RELEASE" used to give me? Jason Alburger HID/NAS/LAN Engineer L3/ATO-E En Route Peripheral Systems Support 609-485-7225 - Forwarded by Jason CTR A

Re: Fw: [GENERAL] ecpg error --> DbPg_cre_sect_buf.pgc:1334: ERROR:

[EMAIL PROTECTED] writes: >>I think you should omit the word "RELEASE" after the >> "ROLLBACK". > > Will this still result in the closed DB connection that the "ROLLBACK > RELEASE" used to give me? I don't know--you should check the current docs for ECPG (I don't use it). -Doug

Re: [GENERAL] PG 8 stop working !?

Ets ROLLAND wrote: Hello, I've a development workstation using Win XP Pro SP2 with PostgreSQL 8.1 win32. This box use P4 3.2 Ghz, 1 Go RAM, 160 Go disk, no hardware problem detected. From several weeks PG seem to start (it appear as started in the services), What do PG's logs show? but wh

Re: [GENERAL] Attn. PostgreSQL.org webmasters: Site Link not working

On Wed, 22 Feb 2006, Dave Page wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Treat Sent: 22 February 2006 14:35 To: Sanjay Arora Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Attn. PostgreSQL.org webmasters: Site Link not wor

Re: [GENERAL] is there webadmin sw written in jsp/servlet

Ibrahim Tekin wrote: > i need an admin tool like phpPgAdmin but written in jsp or servlets. > does anybody know such project? Why do you require your admin tool to be written in a particular language? If you don't want to run PHP on your web server, there are other administrative tools available

Re: [GENERAL] How to specify infinity for intervals ?

On Mon, Feb 20, 2006 at 07:24:05PM +0100, Karsten Hilbert wrote: > I am storing the maximum age a vaccination is due in a > patient (eg. "don't give this vaccination beyond the age of > 10 years" or some such). Some vaccinations are to be given > regardless of age. > > Up to now I have used NULL t

Re: [GENERAL] Performance Problems

On Mon, Feb 20, 2006 at 02:38:08PM -0600, Scott Marlowe wrote: > On Mon, 2006-02-20 at 14:12, Warren wrote: > > I have one table that gets slower and slower over time. It has a lot of > > UPDATES INSERTS and DELETES run on it. It may have as many as 20,000 rows at > > any given time. I am running a

[GENERAL] now() time off

Earlier this week when I logged into my database, I just so happened to notice that the value for now() was six hours off of the time reported by the operating system when using the date command from the command line. How is this possible? I rebooted the server and the problem magically went

Re: [GENERAL] now() time off

On Wed, 2006-02-22 at 16:36, John McCawley wrote: > Earlier this week when I logged into my database, I just so happened to > notice that the value for now() was six hours off of the time reported > by the operating system when using the date command from the command > line. How is this possibl

Re: [GENERAL] now() time off

On Wed, Feb 22, 2006 at 04:46:35PM -0600, Scott Marlowe wrote: > On Wed, 2006-02-22 at 16:36, John McCawley wrote: > > Earlier this week when I logged into my database, I just so happened to > > notice that the value for now() was six hours off of the time reported > > by the operating system whe

[GENERAL] DBD::Pg 1.44 released

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I am pleased to announce that version 1.44 of DBD::Pg has been released. You can find it on CPAN: http://search.cpan.org/~dbdpg/DBD-Pg-1.44/ This will be one of the last versions that supports PostgreSQL 7.3. If you are using that, you are strongly