[OGo-Documentation] A bit of help, please.

[Chris H]

G. Roderick Singleton wrote:

> I have a rh9 laptop on which I am attempting to install ogo 1alpha. 
> Getting the files and installing them was no problem BUT I find myself 
> in an awkward situation, I can' t get postgres started. The error is 
> "psql: FATAL:  Database "root" does not exist in the system catalog." 
> and I cannot find the command(s) to make pg work. Before anyone says 
> RTFM, I would but cannot because of a family emergency that restricts 
> web access. So any quicky hints would be appreciated.
>
> Now why on documentation list? Because I think that this kind of info 
> should alwaqys be provided. Perhaps a setup guide. I am hoping that 
> once I get 1.xalpha installed I will have the start of such a document 
> for RH9 that could possibly be used as a template for other platforms.
>
> So thanks in advance for the help and I look forward to comments on my 
> suggestion.
>
> ger
>
google provides the following:
-----------------------------------------------------

http://www.postgresql.org/docs/7.2/interactive/odbc-install.html

I had the same problem yesterday. My problem was
postmaster was started as 'postgres' being the owner. So inorder to
create a database or start psql I had to 'su postgres'. My Linux
distrbution came with PostgreSQL and it had done all configurations. So
I had to set/change the password for 'postgres' user. When I logged in
postgres and gave 'psql template1', it let me in. After that you can
create database, user or tables...

So make sure that your postmaster is running as postgres. This might be the problem that you are having if I am right.
===============================


I havent touch redhat in years now, but it seems to me that your rh postgreql install is pooched. If you are haveing troubles starting postgrsql from an init script then perhaps its because its not being started as user postgres

Perhaps that helps, probably not.

/ch