R: [ADMIN] Can't connect to phppgadmin

2004-01-24 Thread Martinelli Paolo A.
Did you use the configure flag '--with-pgsql' while compiling PHP? Paolo Martinelli IrisCube Reply S.p.A. Da: [EMAIL PROTECTED] per conto di Chalrie Schaubmair Inviato: dom 6/23/2002 20:49 A: [EMAIL PROTECTED] Oggetto: [ADMIN] Can't connect to phppgadmin Hi, I

[ADMIN] Easy pg_hba.conf question.

2004-01-24 Thread Robert
I want to add a line in a pg_hba.conf file so that the user 'auser' can connect to the database 'aDB' via host based authentication: so far for the line I have: host aDB 134.117.76.10 255.255.255.255 md5 However, I'm not sure how to specify only 'auser' can connect to the database

Re: [ADMIN] Easy pg_hba.conf question.

2004-01-24 Thread Bruno Wolff III
On Sat, Jan 24, 2004 at 12:23:44 -0500, Robert <[EMAIL PROTECTED]> wrote: > I want to add a line in a pg_hba.conf file so that the user 'auser' can > connect to the database 'aDB' via host based authentication: so far for > the line I have: > > host aDB 134.117.76.10 255.255.255.255

Re: [ADMIN] Easy pg_hba.conf question.

2004-01-24 Thread Robert
Bruno Wolff III wrote: On Sat, Jan 24, 2004 at 12:23:44 -0500, Robert <[EMAIL PROTECTED]> wrote: I want to add a line in a pg_hba.conf file so that the user 'auser' can connect to the database 'aDB' via host based authentication: so far for the line I have: host aDB 134.117.76.10 25

[ADMIN] "mirroring" a table - PostgreSQL 7.3.2

2004-01-24 Thread C. Bensend
Hey folks, I searched the archives and didn't really come up with much, so I'm posting my question here. I have two tables in the same database, whose structure I want to be identical. Call them 'bob' and 'test_bob' for example. If I make a change to the schema of 'bob', I want that e

Re: [ADMIN] Easy pg_hba.conf question.

2004-01-24 Thread Bruno Wolff III
On Sat, Jan 24, 2004 at 14:18:09 -0500, Robert <[EMAIL PROTECTED]> wrote: > Bruno Wolff III wrote: > > >What version of postgres are you using? I think the hba format changed > >between 7.1 and 7.2 (though it might have been between 7.2 and 7.3) > >to include a specifation for allowed users. > >

Re: [ADMIN] "mirroring" a table - PostgreSQL 7.3.2

2004-01-24 Thread Tom Lane
"C. Bensend" <[EMAIL PROTECTED]> writes: >I have two tables in the same database, whose structure I want to be > identical. Call them 'bob' and 'test_bob' for example. >If I make a change to the schema of 'bob', I want that exact change to > happen to 'test_bob'. Possibly you could get t

Re: [ADMIN] "mirroring" a table - PostgreSQL 7.3.2

2004-01-24 Thread C. Bensend
> Possibly you could get the effect you want by making one a child of the > other. Read up on inheritance. There are some side-effects you'd > probably *not* want, so this isn't a perfect solution, but I can't think > of anything else. Thanks for the quick reply, Tom. I appreciate that.

Re: [ADMIN] "mirroring" a table - PostgreSQL 7.3.2

2004-01-24 Thread Reece Hart
On Sat, 2004-01-24 at 13:21, C. Bensend wrote: I've looked at this, and it seems to be on the same level as a quick DROP/CREATE. Is there no way to "mirror" a table structure in real time? Benny- If I understand what you want correctly, inheritance seems like a pretty good option. Chang

Re: [ADMIN] setting statement_timeout on live postmaster

2004-01-24 Thread Bruce Momjian
Warren Little wrote: > Is there anyway to modify the statement_timeout value set > in postgresql.conf we creating a connection? > I would like to have the value set to something like 60 seconds on a > regular basis but my vacuumdb statements run longer and timeout without > completing the vacuum

Re: [ADMIN] "mirroring" a table - PostgreSQL 7.3.2

2004-01-24 Thread C. Bensend
> when you drop a column). This is NOT "on the same level as a quick > DROP/CREATE". Hi Reece, My apologies to Tom - I certainly was not trying to disreguard or "blow off" his advice. I think my lack of understanding may have manifested itself as dismissal. I'm a systems/network guy, not a