Re: Newbie Stupid Question

Hi !

Try creating one more user with createuser -d

-d switch here means the user can create dbs, although if you omit the switch
your system should prompt you if the new user can create dbs, other users etc.

Check your pg_hba.conf file to allow the new user to connect or maybe even
all local users ...

And by the by, the only stupid question is the one that remains unasked ;-)

BR,

aarni

On Monday 15 July 2002 02:42 pm, you wrote:
> Hi All,
> I have run the initdb and the -i switch, and it seems to be working. Now
> I'm in the last step creating the testdb, which it won't let me do. It
> says I don't have permissions. Yes, I'm postgres. I thought PostgreSQL
> had postgres as the default user. I also tried to create other less higher
> users for the db. That didn't work either. Well, I'm going to check a few
> things tonight maybe something will click. If you all have any suggestions
> I'll be most grateful! :) I just want to thank you all for ans. my email.
> I really appreciate this help.
> Peace and Joy,
> Marsie
>
> Aarni Ruuhimäki / Megative Tmi / KYMI.com wrote:
> > Hi !
> >
> > Have you run initdb and then started postmaster with -i switch ?
> >
> > BR,
> >
> > aarni
> >
> > On Thursday 11 July 2002 05:02 pm, you wrote:
> > > Hi All
> > > I have just installed PostgreSQL on my duel booted Windows 98/Red Hat
> > > Linux system. I just want to experiment/learn/play with the db without
> > > interfering with real dbs so I'm not connected to anything. No
> > > surprise when I get the error with the first createdb at the end of the
> > > installation, which states:
> > >
> > > Is the server running locally and accepting
> > > connections on Unix domain socket
> > > "tmp/.S.PGSQL.5432"?
> > > createdb: database creation failed
> > >
> > > Can anyone help, I'm almost done!
> > > Peace,
> > > Marsie
> > > ---------------------------(end of
> > > broadcast)--------------------------- TIP 5: Have you checked our
> > > extensive FAQ?
> > >
> > > http://www.postgresql.org/users-lounge/docs/faq.html