Re: Newbie Stupid Question - Mailing list pgsql-novice

Hi Marsie !

You got me lost here. Still a newbie myself too.

Anyway, it seems you have too many errors in install and regress which should
run cleanly without errors before going to creating dbs etc. You are bound to
have more trouble later if you start with errors.

Sorry I can not help you any further on this.

Maybe you sould try ( downloading  the latest version and ) doing a default
installation to see if it goes right on your box ?

Which version and linux distro are you using ?

BR,

aarni


On Thursday 18 July 2002 05:00 pm, you wrote:
> Hi Aarni,
> I did find the file and it is set up correctly.
> I went back and redid some things just to see if they would make a
> difference, but to no avail!
> One of the things was to empty the data directory and reinitiate the db.
> I does give me all the right comments back and makes all the correct files.
> I'm having problems with the part just before the createdb, which I think
> is optional.
> This is the part with starting PostgreSQL with the SysV script, which
> didn't work.
>
> It says that the "service" command does not exist.
> I went on to the next step which was to do the createdb.  This is where I
> get  the error that postgres is not a user?
> But I'm logged into the system as su postgres?  Do I need to be log into
> PostgreSQL somehow?
> There are no big errors on the regress test only 3 errors pertaining to
> some user commands in sql.
> I'm getting really close to backing everything out and starting over, but I
> feel I'm so close to getting this.
> Peace,
> Marsie
>
> Aarni Ruuhimäki / Megative Tmi / KYMI.com wrote:
> > 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