Postgres Pro
Downloads
Home   >   mailing lists

Thread: I cannot get the db to initialize. Please help.

I cannot get the db to initialize. Please help.

From
P G
Date:
Has anyone seen this error and managed to get it to
work?  I have installed the PostgreSQL 7.3.1 RPMs, but
I cannot get the database to initialize.  I keep
getting the following error.  BTW, this is on a Cobalt
RAQ550.

Any help would be appreciated.

TIA.
**************************************
[root admin]# su -l postgres -c '/usr/bin/initdb
--pgdata=/var/lib/pgsql/data'
The program
    '/usr/bin/postgres'
needed by initdb does not belong to PostgreSQL version
7.3.1, or
there may be a configuration problem.

This was the error message issued by that program:
/usr/bin/postgres: error while loading shared
libraries: cannot open shared obje
ct file: cannot load shared object file: No such file
or directory
[root admin]# rpm -qf /usr/bin/postgres
postgresql-server-7.3.1-1PGDG
[root admin]#

__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com

Re: I cannot get the db to initialize. Please help.

From
Tom Lane
Date:
P G <pg_dba@yahoo.com> writes:
> This was the error message issued by that program:
> /usr/bin/postgres: error while loading shared
> libraries: cannot open shared obje
> ct file: cannot load shared object file: No such file
> or directory

You probably need a shared library that you don't have, or don't have
the right version of.  Or maybe you just need to fix ldconfig to know
where the libraries are.  "ldd /usr/bin/postgres" should tell you what
it's looking for.

            regards, tom lane

Re: I cannot get the db to initialize. Please help.

From
P G
Date:
Thanks, I forgot all about ldd.  Anyhow, I was able to
track down the problem pretty quickly with your
suggestion.

Thanks Again.

--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> P G <pg_dba@yahoo.com> writes:
> > This was the error message issued by that program:
> > /usr/bin/postgres: error while loading shared
> > libraries: cannot open shared obje
> > ct file: cannot load shared object file: No such
> file
> > or directory
>
> You probably need a shared library that you don't
> have, or don't have
> the right version of.  Or maybe you just need to fix
> ldconfig to know
> where the libraries are.  "ldd /usr/bin/postgres"
> should tell you what
> it's looking for.
>
>             regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please
> send an appropriate
> subscribe-nomail command to majordomo@postgresql.org
> so that your
> message can get through to the mailing list cleanly


__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com