Thanks for helping out. This message makes me wonder if it is permissions:
but unable to open file "/mnt/oldboot/usr/local/pgsql/data/global/pg_control": Permission denied
Because don't we want it to look for that file in /usr/local/pgsql/global/pgcontrol and not on the old mount? It's strange, I ran the chown as root and it basically repeats this for everything.
chown: changing ownership of `/mnt/oldboot/usr/local/pgsql/data/postmaster.opts': Read-only file system
chown: changing ownership of `/mnt/oldboot/usr/local/pgsql/data/postgresql.conf~': Read-only file system
chown: changing ownership of `/mnt/oldboot/usr/local/pgsql/.psql_history': Read-only file system
chown: changing ownership of `/mnt/oldboot/usr/local/pgsql/.bash_history': Read-only file system
here's the ls -l
[root@rhumba pgsql]# ls -l
total 28
drwxr-xr-x 2 506 507 4096 Feb 17 2003 bin
drwx------ 6 506 507 4096 May 13 10:06 data
drwxr-xr-x 4 506 507 4096 Feb 17 2003 doc
drwxr-xr-x 4 506 507 4096 Feb 17 2003 include
drwxr-xr-x 2 506 507 4096 Feb 17 2003 lib
drwxr-xr-x 4 506 507 4096 Feb 17 2003 man
drwxr-xr-x 3 506 507 4096 Feb 17 2003 share
[root@rhumba pgsql]#
I don't know users 506 or 507? Hmmmmm. I then cp the data directory to /tmp/data and I was able to chown it to postgres. But then it still gave the similar message:
but unable to open file "/tmp/data/global/pg_control": No such file or directory
Any thoughts?