Forum OpenACS Q&A: Re: database recovery: how does postgres unix work?

Collapse
Posted by Eric Wolfram on
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?