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

G. Roderick Singleton documentation@opengroupware.org
Sat, 15 Jan 2005 14:31:21 -0500


Chris H wrote:

> 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
>
>
>
>
>
>
>
That helps. Thanks. I think you have my telco number. Please call