Skip site navigation (1) Skip section navigation (2)

Re: Problems with precompiled pgsql on mac

From: Peter Elmers <p(dot)elmers(at)gmx(dot)de>
To: Shane Ambler <pgsql(at)Sheeky(dot)Biz>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Problems with precompiled pgsql on mac
Date: 2007-03-27 07:38:57
Message-ID: 6C97816F-36CE-4799-A03D-18A2A6B63984@gmx.de (view raw or flat)
Thread:
Lists: pgsql-admin
Hi Shane,


> Peter Elmers wrote:
>> Hi Guys!
>
> A bit more info would help -
>
>> I am trying to deploy an application together with postgresql.  
>> Therefore, i compiled postgres versions on Intel, G4 and G5.
>> Mostly, this works perfectly. But on some machines, the  
>> installation was successful and postgres does not start.
>
> Is there some common info on the machines that don't work?
There must be. But at the moment, i did not find anything.  
Architecture and Ressources are different.

> Is it only cpu type that fails? Is the correct binary installed on  
> them?
The correct binary is used.

> Is there a system version or installed software that is common to  
> the failing machines?
10.4.9. On my machines, this works perfectly.

> How much RAM is on the failing machines?
Also different.

> Are you adjusting the postgres.conf file? What changes? Try with a  
> standard postgres.conf first.
Changes are made for the amount of connections. Otherwise i had to  
change the sysctl settings.

max_connections = 50
shared_buffers = 1MB

> Are you adjusting any of the sysctl settings?
>
No

> What version are you installing?

I compiled 8.2.3

>
> I do remember reading somewhere about Apple Remote Desktop 2 (or  
> maybe it was 3) (which uses pg as data source) may conflict with a  
> postgres install.

>
>> PostGres does not write any log. If i try to start the postmaster  
>> directly, he says, it will start but no process is shown within  
>> the process list.
>
> There should at least be a serverlog in the data directory. If you  
> have setup rotating logs look in data/pg_log
There is definitely no log.

>
> Bad permission settings on the data dir can stop postgres from  
> starting. Has the postgres user been created and set as the owner  
> of the data dir with drwx------ permissions set on the data dir and  
> all contents?
I already checked this. All permissions are correct. We use a own  
user to keep it clean if a possible postgres standard installation  
exist on the target machine.

>
> What script are you using to start? Is POSTGRESQLSERVER=-YES- in / 
> etc/hostconfig Some scripts use this or similar to turn postgres on  
> or off.
> One thing to try is to try starting with pg_ctl - you may get more  
> feedback than the startupitems script

We use a own start script together with the systemstarter to get the  
database up each time the computer starts. In detail, it just uses
"pg_ctl -D $Somewhere -l $OtherWhere start"

> Two logs to look at are console.log and system.log which may have  
> STDERR output not seen at the terminal. You can use Console.app to  
> view them or open them directly, console.log is in /Library/Logs/ 
> Console and system.log is in /var/log
I tailed the system.log directly after trying to start pg_ctl. Not a  
single line about postgres. Also for the crashlog.
The Console.log is new to me. I will check this.


Thanks for your help!

>
>
>
> -- 
>
> Shane Ambler
> pgSQL(at)Sheeky(dot)Biz
>
> Get Sheeky @ http://Sheeky.Biz
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 6: explain analyze is your friend


In response to

Responses

pgsql-admin by date

Next:From: Thomas PundtDate: 2007-03-27 08:29:24
Subject: Re: Problems with precompiled pgsql on mac
Previous:From: Devrim GÜNDÜZDate: 2007-03-27 07:08:40
Subject: Re: RPMs for RedHat 5 Enterprise?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group