Hi ceco,
Once again, thanks for the response.
I have done the following:
...
/usr/local/pgsql/bin/initdb --locale=pt_PT -D /usr/local/pgsql/data
...
/usr/local/pgsql/bin/createdb -E SQL_ASCII test
When I performed the restore I did not get the errors I was experiencing before.
However, when I tried to install PGAdmin III (using rpm -Uvh pgadmin3-1.4.0-1.i686.rpm), to view the restored data, I am getting a Failed dependencies error:
postgresql is needed by pgadmin3-1.4.0-1.i686
NB. I installed PostgreSQL as follows:
gunzip postgresql-8.0.7.tar.gz
tar xf postgresql-8.0.7.tar
cd /usr/local/postgresql-8.0.7
./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 --locale=pt_PT -D /usr/local/pgsql/data
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 &
/usr/local/pgsql/bin/createdb -E SQL_ASCII test
Thanks
Dabase