Re: [ADMIN] [GENERAL] Migrating Oracle to PostgreSQL

2002-04-18 Thread Leif Jensen
Hi, Have a look at www.openacs.org. This is an open project for converting the ACS (Oracle based) web system into an open source system based on PostgreSQL (in the first place). I believe there is a migration document somewhere in there. Greetings, Leif On Thu, 18 Apr 2002, Makarov

Re: [ADMIN] problem in module Pg with Apache, Perl and SSL

2002-04-18 Thread BELLIARD Francois - FT.BD/FTRD/DRHG/RSCL
The web server is not chrooted and when Apache is started, the LD_LIBRARY_PATH variable points to all the directories containing the libraries   "Nigel J. Andrews" wrote: On Wed, 17 Apr 2002, Morten Sickel wrote: > BELLIARD Francois wrote: > [Snip] > >When a Perl Cgi script tries to load the "Pg"

Re: [ADMIN] problem in module Pg with Apache, Perl and SSL

2002-04-18 Thread Jie Liang
module/category current distrbution file Pg pgsql_perl5-1.9.0tar.gz -Original Message- From: Morten Sickel [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 5:50 AM To: 'Nigel J. Andrews'; Pgsql-Admin (E-post) Cc: 'BELLIARD Francois - FT.BD/FTRD/DRHG/

Re: [ADMIN] problem in module Pg with Apache, Perl and SSL

2002-04-18 Thread Morten Sickel
> From: Nigel J. Andrews [mailto:[EMAIL PROTECTED]] > Morten Sickel (I) wrote: >> I cannot find any 'Pg' module at CPAN, but if you are using the DBD-Pg... > Or of course he could be using the Pg module :) Oops, is there any? Sorry then, I searhed at cpan, withou finding any modules named just

[ADMIN] Database mirroring

2002-04-18 Thread Rommel B. Abaya
Hi, I'm trying to find out if database mirroring could be done with PostgreSQL. What i mean is that when my applications insert/delete/update records in my production server, it will also insert/delete/update the same in my development server such that my production server and development server

[ADMIN] Migrating Oracle to PostgreSQL

2002-04-18 Thread Makarov Gera x8521
Hi there, Has anyone migrated Oracle database to Postgres? If yes, could you please help me - what are the steps involved, complications you faced, any other info you think is appropriate. Thanks in advance. Regards, Gera Makarov Oracle DBA CitiPower Pty

Re: [ADMIN] problem in module Pg with Apache, Perl and SSL

2002-04-18 Thread Nigel J. Andrews
On Wed, 17 Apr 2002, Morten Sickel wrote: > BELLIARD Francois wrote: > [Snip] > >When a Perl Cgi script tries to load the "Pg" module (use Pg; in the > script), > >there is the following error in the Apache Error Log : > [Snip] > > I cannot find any 'Pg' module at CPAN, but if you are using

[ADMIN] How to repair a corrupt database

2002-04-18 Thread Ferdinand Smit
Hi, Sometimes when i import a psql dump, i found out that the original dabases had fault values (NULL value where NULL is not allowd, dubble primary keys ...). This cost me a lot of time to correct everything. So, how kan i repair a postgres database before i make an export ? Regards, Ferdina

[ADMIN] Vacuum blocking...

2002-04-18 Thread Jean-Arthur Silve
Hello ! I used to run vacuum verbose analyze (vacuumdb -v -a -z) every days. Everything was ok for months until yesterday ! Usually, this command takes about 1 mn. Now, vacuum "blocks" on one table (apparently "comptes" table) , without HD activity, no error message avr 15 10:31:27 uranus