SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-11-2008, 05:05 AM
| ||||
| ||||
 Re: Remote administration functionality > -----Original Message----- > From: Bruce Momjian [mailto  gman@candle.pha.pa.us]> Sent: 01 August 2005 01:35 > To: Dave Page > Cc: Tom Lane; Magnus Hagander; PostgreSQL-development > Subject: Re: [HACKERS] Remote administration functionality > > I am thinking we will need load_pg_hba() and write_pg_hba() that will > load and write the table to pg_hba.conf. Yeah, that bit is straghtforward enough, but what about the situation where dba #1 updates the pg_hba table, at the same time as dba #2 is editting pg_hba.conf in vi? Regards, Dave. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend      |
|
04-11-2008, 05:05 AM
| |||
| |||
| Re: Remote administration functionality Dave Page wrote: > > > > -----Original Message----- > > From: Bruce Momjian [mailto gman@candle.pha.pa.us]> > Sent: 01 August 2005 01:35 > > To: Dave Page > > Cc: Tom Lane; Magnus Hagander; PostgreSQL-development > > Subject: Re: [HACKERS] Remote administration functionality > > > > I am thinking we will need load_pg_hba() and write_pg_hba() that will > > load and write the table to pg_hba.conf. > > Yeah, that bit is straghtforward enough, but what about the situation > where dba #1 updates the pg_hba table, at the same time as dba #2 is > editting pg_hba.conf in vi? I don't see any way to fix that. The hope is that the administrator has enough control that this isn't happenening --- it could already happen now if who people edit the same file with different editors/locking systems. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org |
|
04-11-2008, 05:05 AM
| ||||
| ||||
| Re: Remote administration functionality "Dave Page" <dpage@vale-housing.co.uk> writes: > > >> -----Original Message----- >> From: Bruce Momjian [mailto gman@candle.pha.pa.us]>> I am thinking we will need load_pg_hba() and write_pg_hba() that will >> load and write the table to pg_hba.conf. > > Yeah, that bit is straghtforward enough, but what about the situation > where dba #1 updates the pg_hba table, at the same time as dba #2 is > editting pg_hba.conf in vi? "Don't do that then." With this change, editing ph_hba.conf by hand should only be done when the database is down... -Doug ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings |
Linear Mode
