Re: [HACKERS] pg_ctl reload - is it safe?

2003-10-14 Thread Tom Lane
Michael Brusser [EMAIL PROTECTED] writes: 2003-10-10 22:37:05 ERROR: cannot read block 0 of s_noteimportlinks: Interrupted system call Hmm. I found this hard to believe at first, but indeed my local man pages for read() and write() say they can return EINTR if interrupted by a signal. This

Re: [HACKERS] pg_ctl reload - is it safe?

2003-10-14 Thread Michael Brusser
Yes, we use NFS. Many of our customers use it as well. Mike. -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] ... ... Michael Brusser [EMAIL PROTECTED] writes: 2003-10-10 22:37:05 ERROR: cannot read block 0 of s_noteimportlinks: Interrupted system call Hmm. I

Re: [HACKERS] pg_ctl reload - is it safe?

2003-10-14 Thread Tom Lane
Michael Brusser [EMAIL PROTECTED] writes: Yes, we use NFS. Many of our customers use it as well. You are of course aware that this is not real safe... regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and

Re: [HACKERS] pg_ctl reload - is it safe?

2003-10-14 Thread Greg Stark
Michael Brusser [EMAIL PROTECTED] writes: Michael Brusser [EMAIL PROTECTED] writes: 2003-10-10 22:37:05 ERROR: cannot read block 0 of s_noteimportlinks: Interrupted system call Hmm. I found this hard to believe at first, but indeed my local man pages for read() and write() say

Re: [HACKERS] pg_ctl reload - is it safe?

2003-10-14 Thread Bruce Momjian
Tom Lane wrote: Michael Brusser [EMAIL PROTECTED] writes: Yes, we use NFS. Many of our customers use it as well. You are of course aware that this is not real safe... Maybe we should throw a stop using NFS if we get an EINTR from read()/write(), or explain what NFS options they should

Re: [HACKERS] pg_ctl reload - is it safe?

2003-10-14 Thread Larry Rosenman
--On Tuesday, October 14, 2003 15:31:42 -0400 Bruce Momjian [EMAIL PROTECTED] wrote: Tom Lane wrote: Michael Brusser [EMAIL PROTECTED] writes: Yes, we use NFS. Many of our customers use it as well. You are of course aware that this is not real safe... Maybe we should throw a stop using NFS if

Re: [HACKERS] pg_ctl reload - is it safe?

2003-10-14 Thread Bruce Momjian
Larry Rosenman wrote: -- Start of PGP signed section. --On Tuesday, October 14, 2003 15:31:42 -0400 Bruce Momjian [EMAIL PROTECTED] wrote: Tom Lane wrote: Michael Brusser [EMAIL PROTECTED] writes: Yes, we use NFS. Many of our customers use it as well. You are of course aware

Re: [HACKERS] pg_ctl reload - is it safe?

2003-10-14 Thread scott.marlowe
On 14 Oct 2003, Greg Stark wrote: Michael Brusser [EMAIL PROTECTED] writes: Michael Brusser [EMAIL PROTECTED] writes: 2003-10-10 22:37:05 ERROR: cannot read block 0 of s_noteimportlinks: Interrupted system call Hmm. I found this hard to believe at first, but indeed my

Re: [HACKERS] pg_ctl reload - is it safe?

2003-10-14 Thread Bruce Momjian
wscott.marlowe wrote: If you use intr then this type of thing can happen. Lots of programs assume the unix semantics for disk accesses. You can get all kinds of bugs when they're violated. If you use soft then the consequences can be much much worse. If your fileserver were to reboot

[HACKERS] pg_ctl reload - is it safe?

2003-10-10 Thread Michael Brusser
Env: Postgres 7.3.4 on Unix I have a script to create a new database user and update pg_hba.conf. I was wondering whether I need to restart server, or simply run pg_ctl reload. The question is what happens to all active clients when all backends get the signal. I ran such client process which