Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

2310:5875 -- re: 2.3.2 -> Postgres 8.2.4 (Linux) Errors

PostgreSQL
omfgppc
2008-05-27
2013-03-08
  • omfgppc
    omfgppc
    2008-05-27

    pclark wrote: Are you able to connect via PgAdmin or from psql to the db you''ve restored?
    And do you see tables and data?

    Do you have more than 1 version of Postgres installed?

    Do you have your linux distribution''s versions of postgres installed also?

    Did you follow these instructions from the INSTALL.TXT in your postgres source?
    [code:1:08b0565cc5]./configure
    gmake
    su
    gmake install
    adduser postgres
    mkdir /usr/local/pgsql/data
    chown postgres /usr/local/pgsql/data
    su - postgres
    /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
    /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data >logfile 2>&1 &
    /usr/local/pgsql/bin/createdb test
    /usr/local/pgsql/bin/psql test[/code:1:08b0565cc5]

    When you type \"which psql\" what does it spit back?
    How about \"which postgres\"?

    Thanks,

    Perry Clark -- Read more at http://www.xtuple.org/phpBB2/viewtopic.php?t=2310