The 2.8TB database must be moved to a new server in a new Data Center, and
upgraded from 8.4.17 to 9.6.6
Will this work?
pg_upgrade
--old-datadir "CURSERVER://var/lib/pgsql/data"
--new-datadir "NEWSERVER://var/lib/pgsql/data"
--old-bindir "CURSERVER://usr/bin"
--
Hi all,
I am on Postgres 10.2 and try to get a statement level trigger to work
that is executed after UPDATE statements on a particular table. This
trigger references both the old and new transition table and for some
reason I am unable to reference each transition table multiple times in
a C
>
> On Fri, Feb 23, 2018 at 6:10 AM, mariusz wrote:
> i guess, you can easily get max continuous range for each row with
> something like this:
>
> CREATE OR REPLACE FUNCTION
> append_daterange(d1 daterange, d2 daterange)
> RETURNS daterange
> LANGUAGE sql
> AS
>
On Fri, Feb 23, 2018 at 6:42 AM, Viktor Fougstedt
wrote:
>
> Hi.
>
> This answer is perhaps useful if I understand your problem correctly. But
> I might have interpreted it wrongly. :-)
>
>
> I would probably start with merging intervals so that overlapping and
> adjacent intervals become single
On Wed, Jan 3, 2018 at 6:34 PM, Tom Lane wrote:
> Thomas Munro writes:
>> On Wed, Jan 3, 2018 at 6:13 PM, Thuc Nguyen Canh
>> wrote:
>>> mount | grep /dev/shm
>>> => shm on /dev/shm type tmpfs (rw,nosuid,nodev,noexec,relatime,size=65536k)
>
>> Bingo. Somehow your container tech is limiting shar
Hi Tom,
> PG_CPPFLAGS ought to work. One point is that you need to set that before
> including pgxs.mk; maybe it's an ordering problem?
On closer inspection, it was working, but the pg Makefile was specifically
including “-Wdeclaration-after-statement” which I think was overriding the
‘-std=c9
Demitri Muna writes:
> I’m writing a C extension and have successfully based my Makefile on existing
> templates. This conveniently hides the details of the full Makefile provided
> by "pg_config --pgxs”. Which variable would be the appropriate one to specify
> the ‘-std=c99’ compiler flag? I’v
Hi,
On 2018-02-23 15:59:18 -0300, Andre Oliveira Freitas wrote:
> I'm using the libpq that comes with debian, however I can install the
> library from the official repository to be sure, I assume the one from
> the official repo has it enabled.
That should be fine. Could you get the backtrace aga
2018-02-23 14:20 GMT-03:00 Andres Freund :
>
> Hi,
>
> On 2018-02-23 13:33:18 -0300, Andre Oliveira Freitas wrote:
> > Since it's been happening for a few weeks now, every time it freezes we
> > take a gcore dump and check it in gdb... and after a lot of hair pulling
> > and learning about the inna
Hello,
I'm seeing the following behavior with a trigger file which is very
confusing to me, I'd like to get some advice of what is the expected
behavior of the trigger file with the standby.
1. setup the replication, with the standby having the following
recovery.conf
# we use wal-e
restore_
Hi,
I’m writing a C extension and have successfully based my Makefile on existing
templates. This conveniently hides the details of the full Makefile provided by
"pg_config --pgxs”. Which variable would be the appropriate one to specify the
‘-std=c99’ compiler flag? I’ve tried many and still ge
Hi,
On Feb 22, 2018, at 9:31 PM, Michael Paquier wrote:
> PG_GETARG_NUMERIC(), no?
That function returns an object of datatype “Numeric” which still requires some
(not immediately obvious) conversation to a double (or whatever primitive C
type).
> When working on implementing your own data
>
Hi,
On 2018-02-23 13:33:18 -0300, Andre Oliveira Freitas wrote:
> Since it's been happening for a few weeks now, every time it freezes we
> take a gcore dump and check it in gdb... and after a lot of hair pulling
> and learning about the innards of the VoIP software we see that most often
> the so
Hi, I've been experiencing an issue. We use an open-source VoIP software
whose backend is PostgreSQL. Initially we had a twin-server setup (one
server running the VoIP software, another one running the pg instance). Due
to company growth we were running into performance issues, so we rolled out
a n
Hi.
This answer is perhaps useful if I understand your problem correctly. But I
might have interpreted it wrongly. :-)
I would probably start with merging intervals so that overlapping and adjacent
intervals become single continuous intervals, then select from those merged
intervals.
We hav
On Thu, 2018-02-22 at 17:23 -0800, Ken Tanzer wrote:
>
>
> On Thu, Feb 22, 2018 at 5:05 PM, Adrian Klaver
> wrote:
> On 02/22/2018 04:58 PM, Ken Tanzer wrote:
>
>
>
> On Thu, Feb 22, 2018 at 4:53 PM, Adrian Klaver
>
On Fri, 23 Feb 2018 17:10:56 +1300
David Rowley wrote:
> On 23 February 2018 at 04:00, Bill Moran wrote:
> > 2) The negative impact of an unused index is tiny compared to the negative
> > impact of a missing index.
>
> I'd say that would entirely depend on the workload of the table and
> the e
17 matches
Mail list logo
