On 6/27/20 10:52 AM, Matthias Apitz wrote:
El día Samstag, Juni 27, 2020 a las 07:21:21 -0700, Adrian Klaver escribió:
2020-06-27 10:23:02.631 CEST [18302] ERROR: canceling autovacuum task
2020-06-27 10:23:02.631 CEST [18302] CONTEXT: automatic analyze of table
"testdump.public.idm_tasktab"
Matthias Apitz writes:
> El día Samstag, Juni 27, 2020 a las 07:21:21 -0700, Adrian Klaver escribió:
>>> 2020-06-27 10:23:02.631 CEST [18302] ERROR: canceling autovacuum task
>>> 2020-06-27 10:23:02.631 CEST [18302] CONTEXT: automatic analyze of table
>>> "testdump.public.idm_tasktab"
>> From
El día Samstag, Juni 27, 2020 a las 07:21:21 -0700, Adrian Klaver escribió:
> > 2020-06-27 10:23:02.631 CEST [18302] ERROR: canceling autovacuum task
> > 2020-06-27 10:23:02.631 CEST [18302] CONTEXT: automatic analyze of table
> > "testdump.public.idm_tasktab"
> >
> From what I understand they
On 6/27/20 1:37 AM, Matthias Apitz wrote:
El día Donnerstag, Juni 25, 2020 a las 04:25:00 -0400, Tom Lane escribió:
Matthias Apitz writes:
On Thursday, 25 June 2020 21:41:54 CEST, Tom Lane
wrote:
regardless of the exact details, it seems like the most likely theory
about what is happening i
El día Donnerstag, Juni 25, 2020 a las 04:25:00 -0400, Tom Lane escribió:
> Matthias Apitz writes:
> > On Thursday, 25 June 2020 21:41:54 CEST, Tom Lane
> > wrote:
> >> regardless of the exact details, it seems like the most likely theory
> >> about what is happening is that the dump file is co
Matthias Apitz writes:
> On Thursday, 25 June 2020 21:41:54 CEST, Tom Lane
> wrote:
>> regardless of the exact details, it seems like the most likely theory
>> about what is happening is that the dump file is corrupt and the
>> corruption is causing the de-gzipped output to be missing or
>> dupl
On Thursday, 25 June 2020 21:41:54 CEST, Tom Lane
wrote:
Adrian Klaver writes:
On 6/25/20 11:03 AM, Matthias Apitz wrote:
I looked in the dump file after uncompressing it. The 'syntax error'
comes from: one large table contains in a bytea column Perl code wich
our software reads from the tabl
Adrian Klaver writes:
> On 6/25/20 11:03 AM, Matthias Apitz wrote:
>> I looked in the dump file after uncompressing it. The 'syntax error'
>> comes from: one large table contains in a bytea column Perl code wich
>> our software reads from the table and executes it with Perl. But, why
>> the psql t
On Thursday, 25 June 2020 21:12:50 CEST, Adrian Klaver
wrote:
acq_vardata where id= order by sel_seq_3
2020-06-25 12:06:42.098 CEST [306] ERROR: syntax error at or
near "q" at character 1
...
If this was coming from the restore of the dump file I would expect to
see a COPY line just pr
On 6/25/20 11:03 AM, Matthias Apitz wrote:
El día Donnerstag, Juni 25, 2020 a las 08:59:49 -0700, Adrian Klaver escribió:
On 6/25/20 5:54 AM, Matthias Apitz wrote:
El día jueves, junio 25, 2020 a las 01:11:37p. m. +0200, Matthias Apitz
escribió:
Hello
A PG dump file was produced on a 11
El día Donnerstag, Juni 25, 2020 a las 08:59:49 -0700, Adrian Klaver escribió:
> On 6/25/20 5:54 AM, Matthias Apitz wrote:
> >
> >
> > El día jueves, junio 25, 2020 a las 01:11:37p. m. +0200, Matthias Apitz
> > escribió:
> >
> > >
> > > Hello
> > >
> > > A PG dump file was produced on a 11.4
On 6/25/20 5:54 AM, Matthias Apitz wrote:
El día jueves, junio 25, 2020 a las 01:11:37p. m. +0200, Matthias Apitz
escribió:
Hello
A PG dump file was produced on a 11.4. server the usual ways.
When it is loaded with
$ gzip -dc newanna_export.dmp | /usr/local/sisis-pap/pgsql/bin/psql -U sis
El día jueves, junio 25, 2020 a las 01:11:37p. m. +0200, Matthias Apitz
escribió:
>
> Hello
>
> A PG dump file was produced on a 11.4. server the usual ways.
> When it is loaded with
>
> $ gzip -dc newanna_export.dmp | /usr/local/sisis-pap/pgsql/bin/psql -U sisis
> sisis
>
> it gives lots
Hello
A PG dump file was produced on a 11.4. server the usual ways.
When it is loaded with
$ gzip -dc newanna_export.dmp | /usr/local/sisis-pap/pgsql/bin/psql -U sisis
sisis
it gives lots of error messages in the server log as:
2020-06-25 12:00:50.333 CEST [31295] ERROR: canceling autovacuu
14 matches
Mail list logo
