[ADMIN] Vacuum blocking...

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

[ADMIN] How to repair a corrupt database

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,

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

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 the DBD-Pg,

[ADMIN] Migrating Oracle to PostgreSQL

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

[ADMIN] Database mirroring

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

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

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

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

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 -

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

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] [GENERAL] Migrating Oracle to PostgreSQL

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