Re: [GENERAL] 10beta1 role

2017-06-22 Thread Tom Lane
Ray Stell writes: > I added -W to the initdb, but the startup has same msg. same. As I > said, the postmaster starts. I just thought the msgs might not be desired. In principle, we could add a -U option to pg_ctl to tell it to do test connections with a userid other than your

Re: [GENERAL] 10beta1 role

2017-06-22 Thread Adrian Klaver
On 06/22/2017 01:43 PM, Jeff Janes wrote: On Thu, Jun 22, 2017 at 1:39 PM, Jeff Janes > wrote: Correction, it can prove it started, because when it connects as the wrong user, it gets an error message which it would only get if the

Re: [GENERAL] 10beta1 role

2017-06-22 Thread Adrian Klaver
On 06/22/2017 01:41 PM, Ray Stell wrote: On 6/22/17 4:36 PM, Adrian Klaver wrote: On 06/22/2017 01:16 PM, Ray Stell wrote: On 6/22/17 4:07 PM, Adrian Klaver wrote: On 06/22/2017 12:06 PM, Ray Stell wrote: I used "initdb -U" to specify an alternate superuser. On startup it Can you show

Re: [GENERAL] 10beta1 role

2017-06-22 Thread Jeff Janes
On Thu, Jun 22, 2017 at 1:39 PM, Jeff Janes wrote: > On Thu, Jun 22, 2017 at 1:34 PM, Adrian Klaver > wrote: > >> On 06/22/2017 01:29 PM, Jeff Janes wrote: >> >>> On Thu, Jun 22, 2017 at 1:22 PM, Adrian Klaver < >>> adrian.kla...@aklaver.com

Re: [GENERAL] 10beta1 role

2017-06-22 Thread Ray Stell
On 6/22/17 4:36 PM, Adrian Klaver wrote: On 06/22/2017 01:16 PM, Ray Stell wrote: On 6/22/17 4:07 PM, Adrian Klaver wrote: On 06/22/2017 12:06 PM, Ray Stell wrote: I used "initdb -U" to specify an alternate superuser. On startup it Can you show your complete initdb command? throws

Re: [GENERAL] 10beta1 role

2017-06-22 Thread Jeff Janes
On Thu, Jun 22, 2017 at 1:34 PM, Adrian Klaver wrote: > On 06/22/2017 01:29 PM, Jeff Janes wrote: > >> On Thu, Jun 22, 2017 at 1:22 PM, Adrian Klaver > > wrote: >> >> On 06/22/2017 01:13 PM, Jeff Janes

Re: [GENERAL] 10beta1 role

2017-06-22 Thread Ray Stell
On 6/22/17 4:34 PM, Adrian Klaver wrote: On 06/22/2017 01:29 PM, Jeff Janes wrote: On Thu, Jun 22, 2017 at 1:22 PM, Adrian Klaver > wrote: On 06/22/2017 01:13 PM, Jeff Janes wrote: On Thu, Jun 22, 2017 at 12:06 PM, Ray

Re: [GENERAL] 10beta1 role

2017-06-22 Thread Adrian Klaver
On 06/22/2017 01:16 PM, Ray Stell wrote: On 6/22/17 4:07 PM, Adrian Klaver wrote: On 06/22/2017 12:06 PM, Ray Stell wrote: I used "initdb -U" to specify an alternate superuser. On startup it Can you show your complete initdb command? throws these msgs: 2017-06-22 14:36:34 EDT,0,startup

Re: [GENERAL] 10beta1 role

2017-06-22 Thread Adrian Klaver
On 06/22/2017 01:29 PM, Jeff Janes wrote: On Thu, Jun 22, 2017 at 1:22 PM, Adrian Klaver > wrote: On 06/22/2017 01:13 PM, Jeff Janes wrote: On Thu, Jun 22, 2017 at 12:06 PM, Ray Stell

Re: [GENERAL] 10beta1 role

2017-06-22 Thread Jeff Janes
On Thu, Jun 22, 2017 at 1:22 PM, Adrian Klaver wrote: > On 06/22/2017 01:13 PM, Jeff Janes wrote: > >> On Thu, Jun 22, 2017 at 12:06 PM, Ray Stell ste...@vt.edu>> wrote: >> >> I used "initdb -U" to specify an alternate superuser. On startup it >>

Re: [GENERAL] 10beta1 role

2017-06-22 Thread Adrian Klaver
On 06/22/2017 01:13 PM, Jeff Janes wrote: On Thu, Jun 22, 2017 at 12:06 PM, Ray Stell > wrote: I used "initdb -U" to specify an alternate superuser. On startup it throws these msgs: 2017-06-22 14:36:34 EDT,0,startup FATAL: 28000: role

Re: [GENERAL] 10beta1 role

2017-06-22 Thread Ray Stell
On 6/22/17 4:10 PM, Melvin Davidson wrote: On Thu, Jun 22, 2017 at 4:07 PM, Adrian Klaver > wrote: On 06/22/2017 12:06 PM, Ray Stell wrote: I used "initdb -U" to specify an alternate superuser. On startup it

Re: [GENERAL] 10beta1 role

2017-06-22 Thread Ray Stell
On 6/22/17 4:07 PM, Adrian Klaver wrote: On 06/22/2017 12:06 PM, Ray Stell wrote: I used "initdb -U" to specify an alternate superuser. On startup it Can you show your complete initdb command? throws these msgs: 2017-06-22 14:36:34 EDT,0,startup FATAL: 28000: role "postgresql" does not

Re: [GENERAL] 10beta1 role

2017-06-22 Thread Jeff Janes
On Thu, Jun 22, 2017 at 12:06 PM, Ray Stell wrote: > I used "initdb -U" to specify an alternate superuser. On startup it > throws these msgs: > > 2017-06-22 14:36:34 EDT,0,startup FATAL: 28000: role "postgresql" does > not exist > > 2017-06-22 14:36:34 EDT,0,startup LOCATION:

Re: [GENERAL] 10beta1 role

2017-06-22 Thread Melvin Davidson
On Thu, Jun 22, 2017 at 4:07 PM, Adrian Klaver wrote: > On 06/22/2017 12:06 PM, Ray Stell wrote: > >> I used "initdb -U" to specify an alternate superuser. On startup it >> > > Can you show your complete initdb command? > > throws these msgs: >> >> 2017-06-22 14:36:34

Re: [GENERAL] 10beta1 role

2017-06-22 Thread Adrian Klaver
On 06/22/2017 12:06 PM, Ray Stell wrote: I used "initdb -U" to specify an alternate superuser. On startup it Can you show your complete initdb command? throws these msgs: 2017-06-22 14:36:34 EDT,0,startup FATAL: 28000: role "postgresql" does not exist 2017-06-22 14:36:34 EDT,0,startup

[GENERAL] 10beta1 role

2017-06-22 Thread Ray Stell
I used "initdb -U" to specify an alternate superuser. On startup it throws these msgs: 2017-06-22 14:36:34 EDT,0,startup FATAL: 28000: role "postgresql" does not exist 2017-06-22 14:36:34 EDT,0,startup LOCATION: InitializeSessionUserId, miscinit.c:503 -- Sent via pgsql-general mailing