Re: [HACKERS] Strange issue with initdb on 8.0 and Solaris automounts

2005-01-27 Thread David Parker
Will this make it into 8.1? >-Original Message- >From: Tom Lane [mailto:[EMAIL PROTECTED] >Sent: Thursday, January 27, 2005 7:38 PM >To: Kenneth Lareau >Cc: David Parker; pgsql-hackers@postgresql.org >Subject: Re: [HACKERS] Strange issue with initdb on 8.0 and &

Re: [HACKERS] Strange issue with initdb on 8.0 and Solaris automounts

2005-01-27 Thread David Parker
Yes, thanks very much! - DAP >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Kenneth Lareau >Sent: Thursday, January 27, 2005 8:10 PM >To: Tom Lane >Cc: Kenneth Lareau; pgsql-hackers@postgresql.org >Subject: Re: [HACKERS] Stra

Re: [HACKERS] Strange issue with initdb on 8.0 and Solaris automounts

2005-01-27 Thread Kenneth Lareau
In message <[EMAIL PROTECTED]>, Tom Lane writes: >Kenneth Lareau <[EMAIL PROTECTED]> writes: >> In message <[EMAIL PROTECTED]>, Tom Lane writes: >>> Could you truss that and see what it does? > >> Here's the relevant truss output from 'mkdir /software/postgresql-8.0.0' >> on my Solaris 9 system: >

Re: [HACKERS] Strange issue with initdb on 8.0 and Solaris automounts

2005-01-27 Thread Tom Lane
Kenneth Lareau <[EMAIL PROTECTED]> writes: > In message <[EMAIL PROTECTED]>, Tom Lane writes: >> Could you truss that and see what it does? > Here's the relevant truss output from 'mkdir /software/postgresql-8.0.0' > on my Solaris 9 system: > 10832: mkdir("/software/postgresql-8.0.0", 0777)

Re: [HACKERS] Strange issue with initdb on 8.0 and Solaris automounts

2005-01-27 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > There's also a tiny race condition, which I guess isn't worth worrying > about. Considering that we're not checking ownership or permissions of the parent directories, I'd say not. regards, tom lane ---

Re: [HACKERS] Strange issue with initdb on 8.0 and Solaris automounts

2005-01-27 Thread Andrew Dunstan
Tom Lane wrote: I don't know why the command 'mkdir' doesn't exhibit the same problem as the function 'mkdir', but running: mkdir /software/postgresql-8.0.0 produces the correct error "File exists" on my system. Could you truss that and see what it does? It would be a simpl

Re: [HACKERS] Strange issue with initdb on 8.0 and Solaris automounts

2005-01-27 Thread Kenneth Lareau
In message <[EMAIL PROTECTED]>, Tom Lane writes: >Kenneth Lareau <[EMAIL PROTECTED]> writes: >> In message <[EMAIL PROTECTED]>, Tom Lane writes: >>> I suppose that manually creating the data directory before running >>> initdb would also avoid this issue, since the mkdir(2) loop is only >>> entered

Re: [HACKERS] Strange issue with initdb on 8.0 and Solaris automounts

2005-01-27 Thread Tom Lane
Kenneth Lareau <[EMAIL PROTECTED]> writes: > In message <[EMAIL PROTECTED]>, Tom Lane writes: >> I suppose that manually creating the data directory before running >> initdb would also avoid this issue, since the mkdir(2) loop is only >> entered if we don't find the directory in existence. > Actua

Re: [HACKERS] Strange issue with initdb on 8.0 and Solaris automounts

2005-01-27 Thread Kenneth Lareau
In message <[EMAIL PROTECTED]>, Tom Lane writes: >"David Parker" <[EMAIL PROTECTED]> writes: >> Did initdb previously just assume the -D path existed, and now it is >> trying to create the whole path, if necessary? > >Pre-8.0 it was using mkdir(1), which might possibly contain some weird >workaroun

Re: [HACKERS] Strange issue with initdb on 8.0 and Solaris automounts

2005-01-27 Thread David Parker
m: Tom Lane [mailto:[EMAIL PROTECTED] >Sent: Thursday, January 27, 2005 6:22 PM >To: David Parker >Cc: Kenneth Lareau; pgsql-hackers@postgresql.org >Subject: Re: [HACKERS] Strange issue with initdb on 8.0 and >Solaris automounts > >"David Parker" <[EMAIL PROTECTED]

Re: [HACKERS] Strange issue with initdb on 8.0 and Solaris automounts

2005-01-27 Thread Tom Lane
"David Parker" <[EMAIL PROTECTED]> writes: > Did initdb previously just assume the -D path existed, and now it is > trying to create the whole path, if necessary? Pre-8.0 it was using mkdir(1), which might possibly contain some weird workaround for this case on Solaris. I suppose that manually cr

Re: [HACKERS] Strange issue with initdb on 8.0 and Solaris automounts

2005-01-27 Thread David Parker
Coincidentally I JUST NOW built 8.0 on Solaris 9, and ran into the same problem. As they say, "this used to work". We build databases as part of the build of our product, and I'm looking into what we need to do to upgrade from 7.4.5, and this was the first thing I ran into. I hadn't gotten as