Re: [GENERAL] Multiple Postgres Instances

1999-01-21 Thread David Giffin
It looks like the .profile and /etc/profile were overriding the -D option. I set the profile to this: PATH=/sbin:/usr/sbin:/bin:/usr/bin:/usr/local/bin:/usr/local/pgsql/bin MANPATH=:/usr/local/pgsql/bin PGLIB=/usr/local/pgsql/lib # note: PGDATA overwrites the -D startup option # PGDATA=/usr/loca

Re: [GENERAL] RE: ODBC question on R+w and +r only. solved

1999-01-21 Thread David Hartwig
- Original Message - From: Robert Chalmers <[EMAIL PROTECTED]> To: psql-general <[EMAIL PROTECTED]> Sent: Wednesday, January 20, 1999 8:51 PM Subject: [GENERAL] RE: ODBC question on R+w and +r only. solved >Hmmm. Just gave all permisions to user, and created a NEW table database in >Acc

[GENERAL] Newbie interface question

1999-01-21 Thread Dan Warren
You'll have to forgive me if this is a trivial question but I'm *very* new to this. I'm developing an online time clock program and was wondering if there was a character based front end, similar to Oracle's SQL*Forms, that could be used for a postgres 6.4.2 database. Thanks Dan Warren Design D

Re: [GENERAL] Multiple Postgres Instances

1999-01-21 Thread Alex P. Rudnev
Looks like you are running two PSQL server with THE SAME DATA BASE DIRECTORY! On Thu, 21 Jan 1999, Jeff Hoffmann wrote: > Date: Thu, 21 Jan 1999 08:46:56 -0600 > From: Jeff Hoffmann <[EMAIL PROTECTED]> > To: David Giffin <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: [GENERAL] Mu

Re: [GENERAL] Multiple Postgres Instances

1999-01-21 Thread Jeff Hoffmann
David Giffin wrote: > > Hello, > > I'm trying to run postgres on two different post 5432 and port 5433 with > different data directories for each instance: > > [ -x /usr/local/pgsql/bin/postmaster ] && { > su -l postgres -c '/usr/local/pgsql/bin/postmaster -S -i' > echo -n ' pgs

[GENERAL] Re: test data type

1999-01-21 Thread Silvio Emanuel Barbosa de Macedo
Hi! In the source tree of Postgresql you'll find: postgresql-6.4.2/contrib/fulltextindex and you'll read README: - The included software is an attempt to add some sort of Full Text Indexing support to PostgreSQL. I mean by this that we can ask question

Re: [GENERAL] Oracle vs Postgresql

1999-01-21 Thread Alex P. Rudnev
Hmm. Due to my experience (I have played with boths) - if you need stable network with predicted behaviour in case of disc overflow, bad (crazy) requests, and you lost a lot of money in case of any instability - use Oracle. If you need to deploy wide informational system, it should be easy to

Re: [GENERAL] Porting to RTOS

1999-01-21 Thread Gilles Darold
Hi Tim, Perhaps it's usefull for VxWorks or PostgreSQL to have such a port, but I think that a better way is to use Linux Real Time. You will have less port problems and probably no lost of time. Ok, this is my point of view! Tim Wadsworth wrote: > Hello, > > I was wondering how easy or other