Re: [ADMIN] How to use pg_log ?

1999-09-09 Thread Jacques B. Dimanche
At 07:14 PM 9/9/99 +1100, Stéphane FILLON wrote: >I would like to know our I can read the log file. >Is it the file where I can detail all the transactions ? Hmmm... I believe the pg_log is just for internal use of Postgres to track the committed and uncommitted transactions. If you want to l

Re: [ADMIN] Problem with regression testing

1999-09-09 Thread Jacques B. Dimanche
At 07:42 PM 9/9/99 -0700, Postgres Mailing List wrote: >is indeed running. PGLIB and PGDATA are properly set >(PGLIB=/usr/local/pgsql/lib and PGDATA=/usr/local/pgsql/data). But when I >run "createdb" to test things out I get this: >FATAL 1: Database template1 does not exist in pg_database H

[ADMIN] ODBC

1999-09-09 Thread Nuchanach Klinjun
Dear Sir, I work with Postgres on Ms Access by using ODBC and it work well. since I've installed postdrv which support 6.4 protocal because of the database was upgraded to 6.5.1 which support 6.4 protocal. then I had some problem when I use passthrough query to send query to run at backen

[ADMIN] Problem with regression testing

1999-09-09 Thread Postgres Mailing List
Hi, I've installed PostgreSQL on a RedHat 6.0 i386 box. The compile and everything seemed to go fine. I'm now logged in as the superuser (postgresql) following the install instructions in the docs. postmaster is indeed running. PGLIB and PGDATA are properly set (PGLIB=/usr/local/pgsql/lib and

RE: [ADMIN] PGSQL Preinstalled Directories - for PHP installation

1999-09-09 Thread Jackson, DeJuan
I believe it needs the PostgreSQL header files. Which would still be a problem because the ./setup in PHP is going to add a /include to the end of whatever path you give it. I gave up on building PHP from the PostgreSQL RPM long ago so I'm not certain. I know that it has to have the libs in the

Re: [ADMIN] Undoing a preinstallation and reinstalling

1999-09-09 Thread Lamar Owen
> Mike Field wrote: > > 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'

Re: [ADMIN] PGSQL Preinstalled Directories - for PHP installation

1999-09-09 Thread Lamar Owen
> Mike Field wrote: > 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 > spec

[ADMIN] How to use pg_log ?

1999-09-09 Thread Stéphane FILLON
Hi !   I would like to know our I can read the log file.   Is it the file where I can detail all the transactions ?   Regards,   Stephane FILLON

[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