From: | Josip Rodin <joy(at)entuzijast(dot)net> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: ERROR: tablespace "archive2" is not empty |
Date: | 2015-10-19 18:25:20 |
Message-ID: | 20151019182520.GA6498@entuzijast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Oct 19, 2015 at 11:15:08AM -0700, Adrian Klaver wrote:
> >Sorry, that's another typo. It's the latter. The symlink is indeed pointing to the 5 GB of leftovers.
>
> This:
>
> % sudo find /media/ssd/archive2/ -type f -ls
> 36962439 393940 -rw------- 1 postgres postgres 403390464 Jun 27
> 2014 /media/ssd/archive2
>
> is a typo or is there another symlink involved?
>
> So, is there anything at /media/archive2/psql?
This time I'll just paste command output to make sure it's verbatim :)
% sudo ls -la /media/ssd/postgresql/9.1/main/pg_tblspc/7849107
lrwxrwxrwx 1 postgres postgres 30 Sep 30 2014 /media/ssd/postgresql/9.1/main/pg_tblspc/7849107 -> /media/ssd/archive2/postgresql
% sudo ls -la $(sudo readlink -f /media/ssd/postgresql/9.1/main/pg_tblspc/7849107)
total 12
drwx------ 3 postgres root 4096 Jun 25 2014 .
drwxr-xr-x 3 root root 4096 Sep 30 2014 ..
drwx------ 3 postgres postgres 4096 Jun 25 2014 PG_9.1_201105231
% sudo ls -la /media/archive2/psql
ls: cannot access /media/archive2/psql: No such file or directory
> Or more to the point how did spclocation and the symlink get to be
> different?
No idea, I inherited this machine. But like Tom said, spclocation being
wrong is apparently harmless.
--
2. That which causes joy or happiness.
From | Date | Subject | |
---|---|---|---|
Next Message | romeo407 | 2015-10-19 18:33:29 | Are there any major benefits to using point and not real data type |
Previous Message | Adrian Klaver | 2015-10-19 18:15:08 | Re: ERROR: tablespace "archive2" is not empty |