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?
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 &
When you type \&quot;which psql\&quot; what does it spit back?
How about \&quot;which postgres\&quot;?
Perry Clark -- Read more at http://www.xtuple.org/phpBB2/viewtopic.php?t=2310