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