Re: Newbie Stupid Question - Mailing list pgsql-novice

Hi Marsie !

Location depends on your linux distro and pg-installation and version. Mine
is RedHat 7.3 / default pg7.2 installation and pg_hba.conf resides in
/usr/local/pgsql/data. It should be in whatever your datadir is. The file
itself is well commented and explained with examples.

BR,

aarni



On Wednesday 17 July 2002 02:47 pm, you wrote:
> Hi Aarni,
> Now about this pg_hba.conf file where is it suppose to reside?
> I found one in '/usr/local/pgsql/share' called 'pg_hba.conf.sample'!
> If it's suppose to be under the '/usr/local/pgsql/bin' where other pg_files
> are it's not there!
> I did start and stop the Postmaster last night, and it's working fine.
> It just won't let me createdb for the first time.
> Can you clarify?
> Peace,
> Marsie
>
> Aarni Ruuhimäki / Megative Tmi / KYMI.com wrote:
> > 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