Re: [ADMIN] Postmaster crashes

2000-07-06 Thread Mike Field
Message - From: Mathieu Arnold <[EMAIL PROTECTED]> To: Mike Field <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, July 06, 2000 9:49 AM Subject: Re: [ADMIN] Postmaster crashes > I've had quite the same thing on a busy server, it was due to a lack of > file

[ADMIN] Postmaster crashes

2000-07-06 Thread Mike Field
Hi- My php website interacts with a postrgres database, and every now and then, postgres just seems to crash. A simple restart of postmaster fixes the problem, until it crashes again. However, I have no idea EXACTLY when it crashes (what the website users are doing at the time, if anything

Re: [ADMIN] Converting Data

1999-10-19 Thread Mike Field
erts *tongue in cheek* No kidding! Although, I'm never afraid to ask a question, and am humble about what I THINK I know. Thanks for checking out my website! Mike [EMAIL PROTECTED] I am Canadian :-) -Original Message- From: Aaron J. Seigo <[EMAIL PROTECTED]> To: Mike Field <

[ADMIN] Converting Data

1999-10-19 Thread Mike Field
Hi all- I have 400 documents in Word for Mac format that I need to enter into my database, saving as much formatting as possible (italics, line breaks, superscripts for footnote markers, etc...). What is the best way to convert this data, and how can I do it automatically? I'm running Post

Re: [ADMIN] New Administrator

1999-10-05 Thread Mike Field
Hi all- Thanks for the help on setting up the new administrator! I used createuser from the shell and it worked fine. Cheers, Mike [EMAIL PROTECTED]

[ADMIN] New Administrator

1999-10-04 Thread Mike Field
Hi all- I'm getting a bit confused by the manual on this one, so excuse my ignorance. I want to set up a new ADMINISTRATOR for postgres databases. He already has his username in Linux. He needs to be able to: PREFERABLY: create db's destroy db's update db's backup db's AT LEAST: be able

[ADMIN] allow a web user for pg_dump

1999-09-22 Thread Mike Field
Hi- I want to allow my web administrator (username 'admin') to be able to run a pg_dump on a database, to do backups on demand. I'm using PHP to execute the command via the web, but I need to allow the admin user to run that command (the user with access to the db is not admin, but rather '

[ADMIN] PGdump then PHP search

1999-09-16 Thread Mike Field
    Hi all-   I've transferred a database using a pg_dump, and everything transferred fine.  But in my search engine (made with PHP3 performing SQL queries using: WHERE fieldname LIKE keywords) the only documents that seem to be searched are the ones that I've put in SINCE the pg_dump/db t

[ADMIN] Undoing a preinstallation and reinstalling

1999-09-09 Thread Mike Field
    Hi again-   In case I can't find the answer to my previous question, I have another question:   If I have PostgreSQL preinstalled on a server with Redhat, and I want to re-compile, what is the best way to prepare for the re-compile to ensure that there won't be any conflicting files?  

[ADMIN] PGSQL Preinstalled Directories - for PHP installation

1999-09-09 Thread Mike Field
    Hi all-   I installed Redhat on a new server, and it came with PostgreSQL preinstalled.  I'm trying to install PHP, to run with PGSQL, but PHP asks me for the "base installation directory" for pgsql.  Since it came pre-installed with Redhat, I don't know which directory to specify.  An