| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Andrus <kobruleht2(at)hot(dot)ee>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: permission denied for large object 200936761 |
| Date: | 2021-02-02 09:37:38 |
| Message-ID: | f1b313941d768ae1c19ed0a5629af845050b4c4a.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 2021-02-02 at 10:48 +0200, Andrus wrote:
> > You can extract it with
> > \lo_export 200936761 'somefile'
> >
> > in psql and examine the file.
> >
> > Ask the people who use that database!
>
> Tried
>
> root(at)c202-76:~# ./pgsqlkaiv.sh
>
> psql (12.2 (Debian 12.2-2.pgdg100+1))
> Type "help" for help.
>
> sba=# \lo_export 200936761 'large200936761'
> lo_export
> sba=# \q
>
> root(at)c202-76:~# ls -l large*
> -rw-r--r-- 1 root root 0 veebr 2 10:45 large200936761
> result file size is 0 .
So? What is your point?
Somebody created a large object of size 0.
Don't ask me who did it, ask the people who use this database.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | unilynx | 2021-02-02 09:59:50 | Index created with PGSQL11 on ubuntu 18.04 corrupt with PGSQL11 on ubuntu 20.04 |
| Previous Message | Andrus | 2021-02-02 09:35:00 | Re: permission denied for large object 200936761 |