Re: Newbie Stupid Question - Mailing list pgsql-novice

Hi Marsie !

Yes, I will, now reinstalling RH after playing hotswap devil with software
raid on my new server ... phuuahh. Well I wanted to repartition anyway.

Sunshine, take care and BR,

aarni

On Friday 19 July 2002 05:18 pm, you wrote:
> Hi Aarni,
> Thanks for the help and cautions!
> I have had problems with the new Red Hat Linux install anyway.
> I'm going to try to resolve the new Red Hat Linux install, and then do the
> PostgreSQL again.
> Have a great weekend!
> Peace and Joy,
> Marsie
>
> Aarni Ruuhimäki / Megative Tmi / KYMI.com wrote:
> > Hi Marsie !
> >
> > Ok, I wish you luck !
> >
> > SysV ? You want to start PgSQL on system start up ?
> >
> > I tried this once and something went wrong, I had to reinit the whole
> > thing.
> >
> > On second thought I decided I want to start all extra daemons like httpd,
> > PgSQL, MySql, ColdFusion, sendmail and the rest manually. Why ? On boot I
> > want to first see the system is clean and running smoothly. Because if it
> > goes down and reboots you also probably want to know the reason first and
> > then start worrying about something else. Ofcourse it is a different
> > thing if you do a reboot yourself. But then again, why would you do that
> > ? Ok, with hardware maintenance or new hardware. But in general, the
> > saying 'if something goes up, it must come down' does not apply to linux
> > ?
> >
> > BR,
> >
> > aarni
> >
> > On Friday 19 July 2002 02:46 pm, you wrote:
> > > Hi Aarni,
> > > You are no Newbie to me!
> > > You know a lot more than you think!
> > > I have the new Red Hat 7.3 Pro.
> > > I also have the latest PostgreSQL 7.2.1.
> > > I did do the default installation of both RH and Postgres.
> > > Thanks so much for all your help I think I'm going to back everything
> > > out and start over.
> > > My little bit of hell ;)
> > > Peace and Joy,
> > > Marsie
> > >
> > > Aarni Ruuhimäki / Megative Tmi / KYMI.com wrote:
> > > > 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