[ome-users] Further questions about broken server

[Jason Swedlow]

Hi Glenn-

Did you actually start postgres-- for full instructions on install  
and running of PostgreSQL is at:

http://developer.apple.com/internet/opensource/postgres.html

If you type:

ps aux | grep postmaster

do you see the postmaster, the database manager process  running?

Cheers,

Jason


On 11 Feb 2008, at 20:27, Glenn Murray wrote:

> It doesn't work for me.  Note that the NetInfo postgres user that the
> installation script creates has shell set to /usr/bin/false, so it  
> seems
> pretty unlikely that I can su to a postgres shell:
>
> omero3.0b2.3/$ sudo su
> gmurray-10708s:/Users/gmurray/projects/omero3.0b2.3 root# su postgres
> gmurray-10708s:/Users/gmurray/projects/omero3.0b2.3 root# id
> uid=0(root) gid=0(wheel) groups=0(wheel), 1(daemon), 2(kmem), 3(sys),
> 4(tty), 29(certusers), 8(procview), 5(operator), 9(procmod), 80 
> (admin),
> 20(staff)
> gmurray-10708s:/Users/gmurray/projects/omero3.0b2.3 root# su -  
> postgres
> gmurray-10708s:/Users/gmurray/projects/omero3.0b2.3 root# id
> uid=0(root) gid=0(wheel) groups=0(wheel), 1(daemon), 2(kmem), 3(sys),
> 4(tty), 29(certusers), 8(procview), 5(operator), 9(procmod), 80 
> (admin),
> 20(staff)
>
> To run initdb I had to delete the postgres user and group created  
> by the
> installation script, create the postgres user manually (in  
> Accounts), and
> reinstall.  Then:
>
> omero3.0b2.3/$ sudo su - postgres
> gmurray-10708s:~ postgres$ initdb -D /Library/PostgreSQL8/data
> The files belonging to this database system will be owned by user  
> "postgres"...
>
> So PG is working, but it has no databases.  When I restart JBoss I get
>
> org.postgresql.util.PSQLException: FATAL: database "omero3" does  
> not exist
>
> What's next?
>
> Thanks,
> Glenn
>
> On Mon, 11 Feb 2008, Sean Burke wrote:
>> Try:
>> su
>> su postgres
>>
>> You don't need a password if you do it as root.
>>
>> -Sean
>>
>> Glenn Murray wrote:
>>> Hi Sean,
>>>
>>> Thanks for the quick reply.  It seems something that the Mac  
>>> install script
>>> would do or document---it has chown'd the directories in
>>> /Library/PostgreSQL8/ to user postgres, but it seems that a regular
>>> postgres user has not been created.  It does create a NetInfo  
>>> postgres user
>>> with home /Library/PostgreSQL8/ and PG's initdb is supposed to be  
>>> run as
>>> postgres, but:
>>>
>>> omero3.0b2.3/$ su - postgres
>>> Password:
>>>
>>> I don't know what the password is here.
>>>
>>> Thanks,
>>> Glenn
>>>
>>>
>>> On Mon, 11 Feb 2008, Sean Burke wrote:
>>>> Glenn,
>>>>  It sounds like you haven't initialized your database, per the  
>>>> postgres
>>>> setup instructions.  Check out:
>>>> http://www.postgresql.org/docs/8.3/interactive/installation.html
>>>>
>>>> Look especially at the step that requires you to run "initdb".
>>>>
>>>> Good luck!
>>>>
>>>> Sean
>>
> _______________________________________________
> ome-users mailing list
> ome-users at lists.openmicroscopy.org.uk
> http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users



**************************
Wellcome Trust Centre for Gene Regulation & Expression
College of Life Sciences
MSI/WTB/JBC Complex
University of Dundee
Dow Street
Dundee  DD1 5EH
United Kingdom

phone (01382) 385819
Intl phone:  44 1382 385819
FAX   (01382) 388072
email: jason at lifesci.dundee.ac.uk

Lab Page: http://www.dundee.ac.uk/lifesciences/swedlow/
Open Microscopy Environment: http://openmicroscopy.org
**************************