Thread: Could not find your PostgreSQL installation in /var/lib/pgsql
system=3Dfedora15=A0
software env=3Dall =A0software in DVD are completely installed(include pgsq=
l psql) and some thing like pppoe=A0
postgresql are install with fedora by default option,=A0
/etc/passwd/: =A0 =A0 =A0 =A0 =A0 =A0postgres =A0PostgreSQL Server:/var/lib=
/pgsql:/bin/bash
operations:
su - postgres
initdb =A0-D /var/lib/pgsql/data -E UTF-8=A0
pg_ctl -D /var/lib/pgsql/data -l logfile start
pg_ctl status =A0 =A0 =A0{terminal =A0return =A0 =A0 =A0=A0pg_ctl: (PID: 30=
52)/usr/bin/postgres "-D" "/var/lib/pgsql/data"}
createdb DatabaseName
psql DatabaseName =A0 =A0 =A0 =A0=A0
su - root
cd=A0/home/download/pgadmin3-1.14.0
./configure --with-pgsql=3D/var/lib/pgsql
{ Could not find your PostgreSQL installation in /var/lib/pgsql }=
You've used : su - root
Before this, you possibly need populate some environment variables from your postgre user.
Before this, you possibly need populate some environment variables from your postgre user.
------------------
----------------------------------------------------------
iihero(Xiong He) http://www.sql9.com
----------------------------------------------------------
------------------ Original ------------------
From: "Terrance Chen"<naturalchen@yahoo.com>;
Date: Thu, Apr 5, 2012 11:14 PM
To: "pgsql-bugs@postgresql.org"<pgsql-bugs@postgresql.org>;
Subject: [BUGS] Could not find your PostgreSQL installation in /var/lib/pgsql
system=fedora15
software env=all software in DVD are completely installed(include pgsql psql) and some thing like pppoe
postgresql are install with fedora by default option,
/etc/passwd/: postgres PostgreSQL Server:/var/lib/pgsql:/bin/bash
operations:
su - postgres
initdb -D /var/lib/pgsql/data -E UTF-8
pg_ctl -D /var/lib/pgsql/data -l logfile start
pg_ctl status {terminal return pg_ctl: (PID: 3052)/usr/bin/postgres "-D" "/var/lib/pgsql/data"}
createdb DatabaseName
psql DatabaseName
su - root
cd /home/download/pgadmin3-1.14.0
./configure --with-pgsql=/var/lib/pgsql
{ Could not find your PostgreSQL installation in /var/lib/pgsql }
On Thu, Apr 5, 2012 at 8:14 AM, Terrance Chen <naturalchen@yahoo.com> wrote:
> system=fedora15
> software env=all software in DVD are completely installed(include pgsql
> psql) and some thing like pppoe
> postgresql are install with fedora by default option,
> /etc/passwd/: postgres PostgreSQL
> Server:/var/lib/pgsql:/bin/bash
>
> operations:
> su - postgres
> initdb -D /var/lib/pgsql/data -E UTF-8
> pg_ctl -D /var/lib/pgsql/data -l logfile start
> pg_ctl status {terminal return pg_ctl: (PID: 3052)/usr/bin/postgres
> "-D" "/var/lib/pgsql/data"}
> createdb DatabaseName
> psql DatabaseName
> su - root
> cd /home/download/pgadmin3-1.14.0
> ./configure --with-pgsql=/var/lib/pgsql
>
/var/lib/pgsql is your data directory. --with-pgsql is looking for
binaries.
try ./configure --with-pgsql=/usr/
or
./configure --with-pgsql=/usr/bin/
--Scott
>
> { Could not find your PostgreSQL installation in /var/lib/pgsql }
>
On Thu, 2012-04-05 at 08:14 -0700, Terrance Chen wrote:
> cd /home/download/pgadmin3-1.14.0
> ./configure --with-pgsql=/var/lib/pgsql
>
> { Could not find your PostgreSQL installation in /var/lib/pgsql }
This is not a bug -- you need to specify PostgreSQL *installation*
directory, which is /usr/bin -- not data directory.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz