Hi,
Maybe this is not an issue, but first time I see it.
Only for 10.4 and rhel7 x86_64 I can see this issue (*). They are
consistent for earlier releases, as well as for 10.4 and rhel 6 x86_64, and
also for the release 9.6.9 all rpms are consistent.
(*) https://yum.postgresql.org/10/redhat/rhel
On 05/13/2018 03:45 PM, Peter J. Holzer wrote:
On 2018-05-13 12:46:42 -0700, Adrian Klaver wrote:
Not trying to trick anyone and no magic. The difference in the represented
values between ts_tz and ts_naive is the heart of my argument. Timestamptz
values are stored in manner that allows you to h
On 2018-05-13 12:46:42 -0700, Adrian Klaver wrote:
> Not trying to trick anyone and no magic. The difference in the represented
> values between ts_tz and ts_naive is the heart of my argument. Timestamptz
> values are stored in manner that allows you to have the output with a time
> zone offset. Ti
On 05/13/2018 01:55 AM, Francisco Olarte wrote:
On Sat, May 12, 2018 at 8:19 PM, Adrian Klaver
wrote:
I would agree that timestamp and timestamptz are both stored as numbers.
Well, after reading source that is a fact. I was trying to say they
are like real numbers, a point in a line.
I wou
"Andrus" writes:
> Database is created in
> "PostgreSQL 10.1 on x86_64-pc-mingw64, compiled by gcc.exe (Rev5, Built
> by MSYS2 project) 4.9.2, 64-bit"
> and contains tables with autogenerated primary keys like
> ...
> if this database is restored to Postgres 9.1 from custom backup using
> ...
Database is created in
"PostgreSQL 10.1 on x86_64-pc-mingw64, compiled by gcc.exe (Rev5, Built
by MSYS2 project) 4.9.2, 64-bit"
and contains tables with autogenerated primary keys like
CREATE TABLE public.logifail
(
id integer NOT NULL DEFAULT nextval('logifail_id_seq'::regclass
On Sun, May 13, 2018 at 09:42:42AM +0200, Hannes Erven wrote:
> But when new WAL is needed, the standby will fetch /all/ WAL present on the
> master.
Fetching as much WAL as possible when recovery happens is wanted by
design, so as it recovers as much as possible. And that's documented.
> I'd sa
On Sat, May 12, 2018 at 8:19 PM, Adrian Klaver
wrote:
> I would agree that timestamp and timestamptz are both stored as numbers.
Well, after reading source that is a fact. I was trying to say they
are like real numbers, a point in a line.
> I would not agree they do not have timezones:
> show t
Michael,
Am 2018-05-13 um 08:23 schrieb Michael Paquier:
On Sun, May 13, 2018 at 01:39:48AM +0200, Hannes Erven wrote:
what is Postgresql's strategy when to fetch WAL from the master while in
streaming replication, and could it be tweaked?
Fetching WAL from a primary (or another standby) can
