[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 logger: NOTICE: --Relation comptes-- avr 15 10:31:27 uranus logger: NOTICE: Pages 492: Changed 26, reaped 491, Empty 0, New 0; Tup 6900: Vac 6229, Keep/VTL 0/0, Crash 0, UnUsed 694, MinLen 242, MaxLen 698; Re-using: Free/Avail. Space 1946648/1943020; EndEmpty/Avail. Pages 0/456. CPU 0.04s/0.27u sec. Then, nothing happens... Any idea ? PS : I use 7.0 version jean-arthur ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[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, Ferdinand ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
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, you are not supposed to have any 'use Pg;' in your code, but rather use DBI; Or of course he could be using the Pg module :) As for the problem of not finding the library file. You say they exist, you presumably have checked they exist at the paths in the root filesystem the error message mentions. Is your web server/cgi-bin program running in a chroot box? -- Nigel J. Andrews Director --- Logictree Systems Limited Computer Consultants ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[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 ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This email message has been swept for the presence of computer viruses CitiPower Pty. ACN 064 651 056 ** ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[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 always contain the same data. Is this possible with PostgreSQL ? -- I'm using PostgreSQL version 7.2 -- # Most people are willing to adapt not because they see the light but because they feel the heat
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 Pg... Morten ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
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 - FT.BD/FTRD/DRHG/RSCL' Subject: 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 Pg... Morten ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
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" 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, you > are not supposed to have any 'use Pg;' in your code, but rather > use DBI; Or of course he could be using the Pg module :) As for the problem of not finding the library file. You say they exist, you presumably have checked they exist at the paths in the root filesystem the error message mentions. Is your web server/cgi-bin program running in a chroot box? -- Nigel J. Andrews Director --- Logictree Systems Limited Computer Consultants ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org -- Franois BELLIARD FTRD/DRHG/RSCL - (33) (0)2 96 05 22 51
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 Gera x8521 wrote: 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 ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This email message has been swept for the presence of computer viruses CitiPower Pty. ACN 064 651 056 ** ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])