Skip site navigation (1) Skip section navigation (2)

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

From: Gan Uesli Starling <alias(at)starling(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-novice(at)postgresql(dot)org
Subject: Re: My bad...user and database not recognized after reboot
Date: 2005-11-14 10:16:29
Message-ID: 437863FD.8090203@starling.us (view raw or flat)
Thread:
Lists: pgsql-novice
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}

In response to

pgsql-novice by date

Next:From: Marcus EngeneDate: 2005-11-14 14:23:37
Subject: oids and tsearch2
Previous:From: A. KretschmerDate: 2005-11-14 09:45:39
Subject: Re: connecting to linux server from windows xp

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group