Re: Transaction Logs Recycling Problem
От | Dennis Gearon |
---|---|
Тема | Re: Transaction Logs Recycling Problem |
Дата | |
Msg-id | 641Y5YUO1UDWS5ZUS2VPKMJZWFAMA9.3e53ad3c@cal-lab обсуждение исходный текст |
Ответ на | Re: Transaction Logs Recycling Problem ("Colin Mangiagalli" <colin@camara.co.za>) |
Ответы |
creating table
|
Список | pgsql-general |
BTW, What is ntsec? 2/18/2003 11:09:30 PM, "Colin Mangiagalli" <colin@camara.co.za> wrote: >Tom Lane <tgl@sss.pgh.pa.us> wrote .. >> "Colin Mangiagalli" <colin@camara.co.za> writes: >> > Could these permission denied errors have been cause by the fact that >> > ntsec was off and the permissions weren't set correctly on the >> > data folder. >> >> If the folder permissions were wrong, then every single attempt to >> create or rename a log file would have failed, I'd think. It sounded to >> me more like a few of the individual log files had wrong ownership or >> permissions. If you ran initdb as Administrator then the >> originally-created log file would have belonged to Administrator, but >> the additional ones would have belonged to postgres --- that might >> explain the behavior. >> >> regards, tom lane > >Hi > >This morning I see the database was down. I had a look at the >permissions on the log files. THey are owned by Administrator and >permissions are (rw r r) .This is on the machine that I haven't >changed yet, doesn't have ntsec on and is on the domain. > >The interesting thing is, when the database stops, it always stops at >just after 7pm, but the network guys assure me that nothing is happening >over the network at that time (ie. backups, etc) > >The other machine I have, randomly seems to fall over, but since I took >it off the domain, it has been working fine. > >If I set ntsec, do I need to run export the database, run initdb and then >import the database again, or can I just change ownership to postgres and >set the permissions. > >I think I need to set ntsec and see if the problem goes away. > > >Thanks for all the help >Colin > > > >---------------------------(end of broadcast)--------------------------- >TIP 6: Have you searched our list archives? > >http://archives.postgresql.org >
В списке pgsql-general по дате отправления: