Re: [ADMIN] Question about multiple postmasters

> > > Has anyone tried running multiple postmasters w/ the same data > > > directory. > > > Any issues to watch out for? Problems with locking? > > > All of the systems would be running on Red Hat 5.1 x86. > > > > Hard to imagine why you would want to do that. pg_log would be shared > > by al

RE: [ADMIN] Question about multiple postmasters

> > Has anyone tried running multiple postmasters w/ the same data > > directory. > > Any issues to watch out for? Problems with locking? > > All of the systems would be running on Red Hat 5.1 x86. > > Hard to imagine why you would want to do that. pg_log would be shared > by all backends, ev

Re: [ADMIN] Question about multiple postmasters

> Has anyone tried running multiple postmasters w/ the same data > directory. > Any issues to watch out for? Problems with locking? > All of the systems would be running on Red Hat 5.1 x86. > > Hard to imagine why you would want to do that. pg_log would be shared by all backends, even if th

RE: [ADMIN] COPY slows down; is it normal?

I dont know if this will help, but you could try a vacuum command. Just be patient, it can run for quite a while... Gregory S. Youngblood ext 2164     -Original Message- From: Gene Selkov Jr. [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 01, 1998 1:49 PM To: [EMAIL PROTECTED] Subje

Re: [ADMIN] COPY slows down; is it normal?

Hi, I just complained about the slow copy operation a few hours ago. I think it came to uneventful end, at least as far as I can tell (nothing too bad in the logfile). The psql client I used to start this copy command detached at some point because of the network timeout, but the backend itself

Re: [ADMIN] List of users

> Dumb question, but I've been searching all day and can't find any way to > get a current list of Postgres users on my system. How do I do so? psql -d template1 -c "select * from pg_user" Gene

[ADMIN] List of users

Hello, Dumb question, but I've been searching all day and can't find any way to get a current list of Postgres users on my system.  How do I do so?

RE: [ADMIN] Having problems compiling postgres on IRIX

Well 1st problem --prefix is not where the source code is at but where you want the binaries to go once the compile is finished. The syntax errors that you are getting on snprintf.c I'm not experiencing here. I'm using gcc v2.7.2.3 (you can do gcc --version to check yours). You might want to try

[ADMIN] COPY slows down; is it normal?

Hi, I am watching the progress of a COPY from a 2 megarow table. It seems to slow down almost exponentially. The database file grew at about 2 megabytes a minute in the beginning and now, 20 hours since started, it grows at 80 kilobytes a minute. The table has 7 columns of char and int types,

[ADMIN] Having problems compiling postgres on IRIX

Hi everyone. I am new to postgres. I need a relational db that can be used with a web client from any plataform, and this seems to be it, BUT. Our lab has ONLY sgi machines. Indigo 2s running Irix 6.2, an Origin 200 running IRIX 6.4, and a lonely Indigo running IRIX 5.3 !!