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

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.

On Mon, Nov 29, 2010 at 8:43 PM, Kevin Grittner <Kevin.Grittner@wicourts.gov

wrote:

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

--
Rashad

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.

Dear scott,
I forgot to add cc so you please ignore this
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:24 PM, Scott Marlowe <scott.marlowe@gmail.com>wrote:

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.

--
Rashad

i removed the postgresql packages using apt-get purge postgresql-8.4 and
deleted all directories
and installed using apt-get install postgresql-8.4

and get this error

* Starting PostgreSQL 8.4 database server

* Error: /var/lib/postgresql/8.4/main is not
accessible or does not exist

--
Rashad

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.

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.

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.