Обсуждение: 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.

Additional: if i start postgresql with user postgres then I got the the
following message:

postgres@delta ~ $ /usr/lib/postgresql/8.4/bin/pg_ctl start
/usr/lib/postgresql/8.4/bin/pg_ctl: symbol lookup error:
/usr/lib/postgresql/8.4/bin/pg_ctl: undefined symbol:
PQconnectionNeedsPassword

Is there a bug?

--
View this message in context: http://postgresql.1045698.n5.nabble.com/postgresql-8-4-error-tp3284527p4271336.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.

Hi,

As Mohammed Rashad wrote in the past I have still the same problems with
Linux Mint Version 10.

I install it via the package manager "synaptic" and during the installation
I got an error message,
analogous "can not start postgres because postgresql 8.4 is not configured"

So for me it looks like that the configuration phase was not running through
successfully.
Afterwards I got the same error Message like Mohammad.

"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" :"

Furthermore no logs gives a hint.

Is there a possibility to configure manually? If yes, what and how has to
configured.
Thanks for any hint in advance.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/postgresql-8-4-error-tp3284527p4271330.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.

I figured out the reason.

I had installed ZendStudio 8.0 in the directory /usr/local for experimental
things.

The ZendStudio runs fine, but since this time I got always mysterious
messages after closing vi. Vi could not find a python library.
So I deleted (rm -rf ...) all this stuff.

Now my vi works fine and I am able to start postgresql (as user postgres).

So for everybody, please check if you application installations are correct
and has no influence to your system.


--
View this message in context: http://postgresql.1045698.n5.nabble.com/postgresql-8-4-error-tp3284527p4273382.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.

On Wed, Mar 30, 2011 at 8:03 AM, fhaegele <frank.haegele@uni-koeln.de> wrote:
> Additional: if i start postgresql with user postgres then I got the the
> following message:
>
> postgres@delta ~ $ /usr/lib/postgresql/8.4/bin/pg_ctl start
> /usr/lib/postgresql/8.4/bin/pg_ctl: symbol lookup error:
> /usr/lib/postgresql/8.4/bin/pg_ctl: undefined symbol:
> PQconnectionNeedsPassword
>
> Is there a bug?

I'm not sure what this is "additional" to, but I suspect you might be
using binaries from one version of PostgreSQL with shared libraries
from another version.  What happens if you run ldd on
/usr/lib/postgresql/8.4/bin/pg_ctl?

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Hello Robert.

As I already wrote the reason was based on installation of ZendStudio 8.0
(30 day version for testing).
My LinuxMint was afterwards in an unexpected condition which comes to this
behaviour with postgreSQL.

Since I deinstalled ZendStudio, all the standard binaries of postgreSQL from
LinuxMint 10 works fine.
So there was NOT a bug in postgreSQL but a inconsistence in my Linux system
;-)

Thanks for your reply.
Regards Frank

--
View this message in context: http://postgresql.1045698.n5.nabble.com/postgresql-8-4-error-tp3284527p4389412.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.