Re: My bad...user and database not recognized after reboot

Tom Lane wrote:
> Gan Uesli Starling <alias@starling.us> writes:
>
>>I had run out of space on Unix directory /var and had
>>decided to move it. I not so cleverly used 'tar -cf' and
>>'tar -xf' to restore /var in its new location. Alas, it
>>seems to have set all ownerships in /var to root. Oops!
>>...
>>If that be the case, how might I get psql to admit
>>existence thereof and again allow access?
>
>
> "chown -R postgres:postgres /usr/pgdata", or something close to that,
> should fix it.
>
>             regards, tom lane
>

But /var is wholly different path from /usr/pgdata and
those paths are as before, thus:

baal: {2} sudo ls -l /usr/pgdata
total 50
-rw-------  1 pgsql  pgsql      4 Oct  2 21:07 PG_VERSION
drwx------  6 pgsql  pgsql    512 Oct 10 23:00 base
drwx------  2 pgsql  pgsql    512 Nov 13 17:20 global
drwx------  2 pgsql  pgsql    512 Oct  2 21:07 pg_clog
-rw-------  1 pgsql  pgsql   3405 Oct  2 21:07 pg_hba.conf
-rw-------  1 pgsql  pgsql   1460 Oct  2 21:07 pg_ident.conf
drwx------  2 pgsql  pgsql    512 Oct  2 21:07 pg_subtrans
drwx------  2 pgsql  pgsql    512 Oct  2 21:07 pg_tblspc
drwx------  3 pgsql  pgsql    512 Oct 21 11:48 pg_xlog
-rw-------  1 pgsql  pgsql  11026 Oct  2 21:07 postgresql.conf
-rw-------  1 pgsql  pgsql     37 Oct  2 21:12 postmaster.opts
baal: {3}