Re: [ADMIN] postgres hab modification without restarting

2003-08-27 Thread Bruce Momjian
Robert Treat wrote: > On Mon, 2003-08-25 at 09:15, Hornyak Laszlo wrote: > > Hi all! > > > > Is it possible to make the postmaster re-read the pg_hba.conf when needed > > without pg_ctl restarting the database? I think I could send a unix signal > > to it, it would simly re-read the file and apply

Re: [ADMIN] postgresql and replication

2003-08-27 Thread Thierry Missimilly
Hi, This is a good status. But i think you have forgotten DBMirror which is in the contrib directory. I have tried to run it on the same machine but on to 2 differents Postgres instances. The master on Port 5432 and the Slave on Port 5434. These does not work as the Perl script in charge of synchr

Re: [ADMIN] Indexing a boolean

2003-08-27 Thread Bruce Momjian
Renney Thomas wrote: > scott.marlowe wrote: > > >On Thu, 21 Aug 2003, Kris Kiger wrote: > > > > > >>I would appreciate it if I could get some thoughts on indexing a field > >>with only two values? For example, I have a table with a few million > >> > > >>Often the best approach here is to ma