Re:

2021-05-16 Thread David G. Johnston
On Sunday, May 16, 2021, Loles wrote: > I don't understand why the server starts that process if I'm not using > replication of any kind. > > > The server starts it with the default configuration of version 13. > > I think that it consumes resources that I do not need because, as I have > comment

Re:

2021-05-16 Thread Loles
I don't understand why the server starts that process if I'm not using replication of any kind. The server starts it with the default configuration of version 13. I think that it consumes resources that I do not need because, as I have commented, I will not use replication of any kind. El lun, 1

Re:

2021-05-16 Thread Dilip Kumar
On Mon, May 17, 2021 at 12:18 AM Loles wrote: > > Hi! > > Let's see if someone can answer my question. > > In a default PostgreSQL 13 installation, starting the server starts a process > called "logical replication launcher". > > I know what logical replication is but I don't know what this proce

Re:

2021-05-16 Thread Loles
Why the Server startup this background process? Isn't a mandatory process. And what's the logical replicación Launcher do? El dom., 16 may. 2021 21:21, Ron escribió: > On 5/16/21 1:47 PM, Loles wrote: > > Hi! > > > > Let's see if someone can answer my question. > > > > In a default PostgreSQ

Re:

2021-05-16 Thread Ron
On 5/16/21 1:47 PM, Loles wrote: Hi! Let's see if someone can answer my question. In a default PostgreSQL 13 installation, starting the server starts a process called "logical replication launcher". I know what logical replication is but I don't know what this process does on the server.

[no subject]

2021-05-16 Thread Loles
Hi! Let's see if someone can answer my question. In a default PostgreSQL 13 installation, starting the server starts a process called "logical replication launcher". I know what logical replication is but I don't know what this process does on the server. Even if you change the default setting

Question about integer out of range in function

2021-05-16 Thread David G. Johnston
On Sunday, May 16, 2021, Condor wrote: > > new_time = fromtime * 1000; -- here is line 19 > > An integer times an integer results in an integer. Period. Neither fromtime nor new_time have been assigned to yet, the in-memory result of the computation is only allocated integer bits and if y

Re: Question about integer out of range in function

2021-05-16 Thread Condor
On 14-05-2021 17:42, Tom Lane wrote: Condor writes: new_time = fromtime * 1000; -- here is line 19 Are you entirely certain that you counted lines correctly? If new_time and fromtime are both declared bigint, and fromtime is on the order of # select extract(epoch from now())::bigint;

Re: Postgres upgrade 12 - issues with OIDs

2021-05-16 Thread David Rowley
On Sun, 16 May 2021 at 13:00, David G. Johnston wrote: > > On Saturday, May 15, 2021, Venkata B Nagothi wrote: >> Below is the query generating the error : >> >> STATEMENT: SELECT c.relname AS table_name, c.relhaspkey AS has_primary_key >> FROM pg_catalog.pg_class c, pg_catalog.pg_namespace n W

Re: Empty tablespace directory after restore with psql -d dbname -f dump.sql

2021-05-16 Thread Julien Rouhaud
Le sam. 15 mai 2021 à 01:14, frank picabia a écrit : > > We cancelled a web application upgrade part way through when it was > realized > Postgres needed a version upgrade first. Using the dump file extracted > from > a full dump with pg_dumpall the DB was restored with a line like : > > psql -