[ADMIN] Servicios de Salud Ocupacional de su Empresa...

2005-12-06 Thread Clinica Vitro
Title: canaco.net | CLINICA NOVA Si usted no visualiza este mensaje importante, haga Click aquí Envía este boletín a un amigo AHORA Usted recibe esta publicación por que está suscrito a las publicaciones de canaco

[ADMIN]

2005-12-06 Thread Nirav Parikh
Hi   I am trying to update machine running pgsql 7.4 to 8.0, I tried installing rpm packages but it conflicts with old stuff install on it. Is there any other way to upgrade it?   What can I use to accelarate PHP scripting ?   Thanks in Advance.     Regards,     Nirav Parikh

Re: [ADMIN] pg_dump, pg_restore and tablespaces

2005-12-06 Thread Jim C. Nasby
On Tue, Nov 29, 2005 at 02:35:12PM -0500, Colton Smith wrote: > Hi: > > Let's say I have a database comprised of tables scattered over several > tablespaces. Suppose I need to move the database to another server and > I can't > use the same pathnames for the tablespaces. Am I out of luck when

Re: [ADMIN] error while creating database

2005-12-06 Thread Jim C. Nasby
I would also strongly recommend upgrading from 7.1.3. That version is over 3 years old, is no longer supported, and IIRC has known data integrity issues. On Tue, Dec 06, 2005 at 03:55:16PM +, Guido Barosio wrote: > Quote: > > "I am having a script(uses psql) which drops and creates a database

Re: [ADMIN] Database testing.

2005-12-06 Thread Jim C. Nasby
On Mon, Dec 05, 2005 at 11:27:33AM +0200, Niv Cohen wrote: > Hi, > My questions are regarding the way you are doing tests to your database. > 1.Can you explain in general the method you test the database > engine. > 2.Are you doing testing for data integrity? > 3.Are you using a special

[ADMIN] 8.1.0 - PITR - cp: cannot stat

2005-12-06 Thread Dan The Man
Hi, I found this old post - see the bottom of the message. I'm having a similiar issue. After a PITR everything looks good. I do see the following in the logs: Can that be safely ignored? cp cannot stat `/sprj/sqldumps_Linux.pgsql_carp5442/0002.history': No such file or directory cp:

Re: [ADMIN] error while creating database

2005-12-06 Thread Dario Brignardello
Greetings: I may be wrong, but you could try using the createdb / dropdb utils from the pgsql/bin directory, or calling psql with some of the parameters used by such tools (-c -d , etc). Hope it helps. Best regards Dario On 12/6/05, Karthik.S <[EMAIL PROTECTED]> wrote: > Dear all, > >

Re: [ADMIN] ssl and/or md5 encryption

2005-12-06 Thread Bruno Wolff III
On Wed, Nov 30, 2005 at 08:24:34 -0500, Colton A Smith <[EMAIL PROTECTED]> wrote: > > I specify md5 encryption in my pg_hba.conf file. Would using SSL on > top of this be overkill? md5 password hashing doesn't buy a whole lot. If packet sniffing is a significant threat for you, you probably

Re: [ADMIN] error while creating database

2005-12-06 Thread Guido Barosio
Quote:"I am having a script(uses psql) which drops and creates a database bylogginginto 'template1'. This will be invoked from crontab."If you are actually connecting with this script into template1 before running the create database, you will then receive that message. Ensure that the script is no

[ADMIN] error while creating database

2005-12-06 Thread Karthik.S
Dear all, I am using postgres version: 7.1.3 in Red hat linux : 7.2. I am having a script(uses psql) which drops and creates a database by logging into 'template1'. This will be invoked from crontab. Sometimes (nearly 50% of the times) the database creation fails by saying "ERROR: CRE