Обсуждение: postgresql-8.4 error

On Monday 29 November 2010 7:02:46 am Mohammed Rashad wrote:
> I am running ubuntu 10.04
> I have problem installing postgresql-8.4
>
> when i tried to start postgresql
> /etc/init.d/postgresql-8.4 start
>
> I am getting this error
>
>  * Starting PostgreSQL 8.4 database server
>                                         * Error: could not exec
> /usr/lib/postgresql/8.4/bin/pg_ctl /usr/lib/postgresql/8.4/bin/pg_ctl start
> -D /var/lib/postgresql/8.4/main -l
> /var/log/postgresql/postgresql-8.4-main.log -s -o  -c
> config_file="/etc/postgresql/8.4/main/postgresql.conf" :

Are you trying to start Postgres as root? If so Postgres will not run as root,
you will need to start it as the Postgres superuser, usually that is postgres.

--
Adrian Klaver
adrian.klaver@gmail.com

Mohammed Rashad <mohammedrashadkm@gmail.com> wrote:

> I am getting this error
>
>  * Starting PostgreSQL 8.4 database server
>                                         * Error: could not exec
> /usr/lib/postgresql/8.4/bin/pg_ctl
> /usr/lib/postgresql/8.4/bin/pg_ctl start -D
> /var/lib/postgresql/8.4/main -l
> /var/log/postgresql/postgresql-8.4-main.log -s -o  -c
> config_file="/etc/postgresql/8.4/main/postgresql.conf" :

Anything in /var/log/postgresql/postgresql-8.4-main.log ?

-Kevin

Adrian Klaver <adrian.klaver@gmail.com> wrote:
> On Monday 29 November 2010 7:02:46 am Mohammed Rashad wrote:

>> /etc/init.d/postgresql-8.4 start

> Are you trying to start Postgres as root? If so Postgres will not
> run as root,
> you will need to start it as the Postgres superuser, usually that
> is postgres.

Service scripts in /etc/init.d/ are normally run by root and su to
the appropriate user for the service.

-Kevin

Hello Mohammed,

Mohammed Rashad [2010-11-29 20:50 +0530]:
> I reinstalled the postgresql and got this error
>  * Starting PostgreSQL 8.4 database server
>    * Insecure directory in $ENV{PATH} while running with -T switch at
> /usr/bin/pg_ctlcluster line 63.

This is not an upstream bug at all. Can you please open a Debian or
Ubuntu bug report, with the output of

  ls -ld /sbin /bin /usr/sbin /usr/bin

? The error message suggests that one or more of these directories are
world-writable.

Thank you,

Martin
--
Martin Pitt                        | http://www.piware.de
Ubuntu Developer (www.ubuntu.com)  | Debian Developer  (www.debian.org)

On Mon, Nov 29, 2010 at 8:02 AM, Mohammed Rashad
<mohammedrashadkm@gmail.com> wrote:
>
> I am running ubuntu 10.04
> I have problem installing postgresql-8.4
> when i tried to start postgresql
> /etc/init.d/postgresql-8.4 start
> I am getting this error
>  * Starting PostgreSQL 8.4 database server
>                                         * Error: could not exec
> /usr/lib/postgresql/8.4/bin/pg_ctl /usr/lib/postgresql/8.4/bin/pg_ctl start
> -D /var/lib/postgresql/8.4/main -l
> /var/log/postgresql/postgresql-8.4-main.log -s -o  -c
> config_file="/etc/postgresql/8.4/main/postgresql.conf" :

I run ubuntu 10.04 and postgresql 8.4 just fine.  Could you provide
more info on how you've instaled 8.4?  Was it through a normal apt-get
install method?  Or did you download some .deb packages somewhere and
dpkg install them?  Or compile by hand and using the service scripts
that come with pgsql?

The more you tell us how you've done things, the more we can help.

As a followup I just noticed you cross posted to pgsql-bugs.

1: please don't cross post.
2: PLEASE don't cross post to bugs especially, unless you have a
reproduceable test case that proves it's a pg bug.
3: Again, please don't cross post.

You want to use apt-get purge to remove it completely.  and keep the
list cc'd others might have more input.

On Mon, Nov 29, 2010 at 8:53 AM, Mohammed Rashad
<mohammedrashadkm@gmail.com> wrote:
> I installed using apt-get install postgresql-8.4
> and it worked correctly for me
> today when i tried to start postgresql server using
> /etc/init.d/postgresql-8.4 restart it not starting now
> will you please tell me how to completely remove postgresql from my system
> and do a fresh install.?
> On Mon, Nov 29, 2010 at 9:20 PM, Scott Marlowe <scott.marlowe@gmail.com>
> wrote:
>>
>> On Mon, Nov 29, 2010 at 8:02 AM, Mohammed Rashad
>> <mohammedrashadkm@gmail.com> wrote:
>> >
>> > I am running ubuntu 10.04
>> > I have problem installing postgresql-8.4
>> > when i tried to start postgresql
>> > /etc/init.d/postgresql-8.4 start
>> > I am getting this error
>> >  * Starting PostgreSQL 8.4 database server
>> >                                         * Error: could not exec
>> > /usr/lib/postgresql/8.4/bin/pg_ctl /usr/lib/postgresql/8.4/bin/pg_ctl
>> > start
>> > -D /var/lib/postgresql/8.4/main -l
>> > /var/log/postgresql/postgresql-8.4-main.log -s -o  -c
>> > config_file="/etc/postgresql/8.4/main/postgresql.conf" :
>>
>> I run ubuntu 10.04 and postgresql 8.4 just fine.  Could you provide
>> more info on how you've instaled 8.4?  Was it through a normal apt-get
>> install method?  Or did you download some .deb packages somewhere and
>> dpkg install them?  Or compile by hand and using the service scripts
>> that come with pgsql?
>>
>> The more you tell us how you've done things, the more we can help.
>
>
>
> --
> Rashad
>



--
To understand recursion, one must first understand recursion.