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

Tom Lane wrote:
> Gan Uesli Starling <alias(at)starling(dot)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}