On 10/19/19 4:51 PM, Julie Nishimura wrote:
an entire cluster
*From:* Adrian Klaver
*Sent:* Saturday, October 19, 2019 4:34 PM
*To:* Julie Nishimura ; Tomas Vondra
*Cc:* pgsql-general@lists.postgresql.org
; pgsql-genera
On Sat, Oct 19, 2019 at 04:34:32PM -0700, Adrian Klaver wrote:
On 10/19/19 4:17 PM, Julie Nishimura wrote:
Thank you, Thomas. Do you know if it is safe to replicate 9.6.2
(smaller) db to 9.6.15 (larger capacity) using pg_basebackup? Would
it be considered as an upgrade?
pg_basebackup backups
On 10/19/19 4:17 PM, Julie Nishimura wrote:
Thank you, Thomas. Do you know if it is safe to replicate 9.6.2
(smaller) db to 9.6.15 (larger capacity) using pg_basebackup? Would it
be considered as an upgrade?
pg_basebackup backups an entire Postgres cluster which will be many
databases. So whe
Thank you, Thomas. Do you know if it is safe to replicate 9.6.2 (smaller) db to
9.6.15 (larger capacity) using pg_basebackup? Would it be considered as an
upgrade?
From: Tomas Vondra
Sent: Saturday, October 19, 2019 5:44 AM
To: Julie Nishimura
Cc: pgsql-general
On Fri, Oct 18, 2019 at 7:55 AM Tom Lane wrote:
> Guillaume Lelarge writes:
> > Le ven. 18 oct. 2019 à 11:51, Patrick FICHE
> a
> > écrit :
> >> Is it possible to execute a function located on a server accessed
> through
> >> Postgres fdw.
>
> > It's probably easier to create a view on the remo
Hello,
On Sat, Oct 19, 2019, 3:27 PM Tomas Vondra
wrote:
> On Sat, Oct 19, 2019 at 12:47:39PM -0400, Andrew Dunstan wrote:
> >
> >On 10/19/19 12:32 PM, David G. Johnston wrote:
> >> On Sat, Oct 19, 2019 at 9:19 AM Tomas Vondra
> >> mailto:tomas.von...@2ndquadrant.com>>
> >> wrote:
> >>
> >>
On Sat, Oct 19, 2019 at 12:47:39PM -0400, Andrew Dunstan wrote:
On 10/19/19 12:32 PM, David G. Johnston wrote:
On Sat, Oct 19, 2019 at 9:19 AM Tomas Vondra
mailto:tomas.von...@2ndquadrant.com>>
wrote:
>
>We invented jsonb_set() (credit to Dmitry Dolgov). And we've had it
>since 9.5
Hi,
On Sat, Oct 19, 2019 at 11:16 PM Daulat Ram
wrote:
> Hi All,
>
>
>
> Thanks for your suggestions.
>
> One more questions is, how backups are useful if we have streaming
> replication . As I know, we can promote the standby as primary in case of
> disaster at primary side. Do we need to sched
On Fri, Oct 18, 2019 at 1:59 AM Daulat Ram
wrote:
> Hello All,
>
> Can you please share some ideas and scenarios how we can do the PITR in
> case of disaster.
>
It depends on what you mean by "disaster". Usually I think that would mean
your server (or entire data center) was destroyed. In this
On 10/18/19 7:18 PM, Ariadne Conill wrote:
Hello,
On Fri, Oct 18, 2019 at 7:04 PM Adrian Klaver wrote:
On 10/18/19 4:31 PM, Ariadne Conill wrote:
Hello,
On Fri, Oct 18, 2019 at 6:01 PM Adrian Klaver wrote:
On 10/18/19 3:11 PM, Ariadne Conill wrote:
Hello,
On Fri, Oct 18, 2019 at 5:01 P
Hi All,
Thanks for your suggestions.
One more questions is, how backups are useful if we have streaming replication
. As I know, we can promote the standby as primary in case of disaster at
primary side. Do we need to schedule backups if we have streaming replication?
Thanks
From: Avinash Kuma
On 10/19/19 12:32 PM, David G. Johnston wrote:
> On Sat, Oct 19, 2019 at 9:19 AM Tomas Vondra
> mailto:tomas.von...@2ndquadrant.com>>
> wrote:
>
> >
> >We invented jsonb_set() (credit to Dmitry Dolgov). And we've had it
> >since 9.5. That's five releases ago. So it's a bit late to be
On Sat, Oct 19, 2019 at 9:19 AM Tomas Vondra
wrote:
> >
> >We invented jsonb_set() (credit to Dmitry Dolgov). And we've had it
> >since 9.5. That's five releases ago. So it's a bit late to be coming to
> >us telling us it's not safe (according to your preconceptions of what it
> >should be doing
On 10/19/19 12:18 PM, Tomas Vondra wrote:
> On Sat, Oct 19, 2019 at 11:26:50AM -0400, Andrew Dunstan wrote:
>
> Not sure, but that seems rather confusing to me, because it's mixing SQL
> NULL and JSON null, i.e. it's not clear to me why
>
> jsonb_set(..., "...", NULL)
>
> should do the same th
On Sat, Oct 19, 2019 at 11:21:26AM -0400, Stephen Frost wrote:
Greetings,
* Dmitry Dolgov (9erthali...@gmail.com) wrote:
If we want to change it, the question is where to stop? Essentially we have:
update table set data = some_func(data, some_args_with_null);
where some_func happened to b
On Sat, Oct 19, 2019 at 11:26:50AM -0400, Andrew Dunstan wrote:
...
The hyperbole here is misplaced. There is a difference between a bug and
a POLA violation. This might be the latter, but it isn't the former. So
please tone it down a bit. It's not the function that's unsafe, but the
ill-inform
On 10/18/19 3:10 PM, Mark Felder wrote:
>
> On Fri, Oct 18, 2019, at 12:37, Ariadne Conill wrote:
>> Hello,
>>
>> I am one of the primary maintainers of Pleroma, a federated social
>> networking application written in Elixir, which uses PostgreSQL in
>> ways that may be considered outside the typ
Greetings,
* Dmitry Dolgov (9erthali...@gmail.com) wrote:
> If we want to change it, the question is where to stop? Essentially we have:
>
> update table set data = some_func(data, some_args_with_null);
>
> where some_func happened to be jsonb_set, but could be any strict function.
I don't
## Ariadne Conill (aria...@dereferenced.org):
> NULL propagation makes sense in the context of traditional SQL. What
> users expect from the JSONB support is for it to behave as JSON
> manipulation behaves everywhere else.
Well, some users expect that. Others are using this interface as it is
do
> On Sat, Oct 19, 2019 at 1:08 PM Tomas Vondra
> wrote:
>
> >Here is how other implementations handle this case:
> >
> >MySQL/MariaDB:
> >
> >select json_set('{"a":1,"b":2,"c":3}', '$.a', NULL) results in:
> > {"a":null,"b":2,"c":3}
> >
> >Microsoft SQL Server:
> >
> >select json_modify('{"a":1
On Thu, Oct 17, 2019 at 11:52:39AM +0200, Tom Lane wrote:
Morris de Oryx writes:
Given that Amazon is bragging this week about turning off Oracle, it seems
like they could kick some resources towards contributing something to the
Postgres project. With that in mind, is the idea of defining dict
On Thu, Oct 17, 2019 at 05:20:09PM +, Julie Nishimura wrote:
Hello everybody, We are running PostgreSQL 9.6.2 cluster master ->
standby (streaming replication). 22 tb of space (constantly struggling
with the space, pruning the old data, but not fast enough). The biggest
db takes 16 tb. So, we
On Fri, Oct 18, 2019 at 05:54:34PM -0400, Edilmar Alves wrote:
I have 3 servers running CentOS+PG 11
(postgresql11-server-11.5-1PGDG.rhel7.x86_64):
- s1: main db + publication
- s2: subscription of the main db
all works fine until here...
Now, I tried to config this:
- s2: publication of the sam
On 2019-10-15 13:10:13 -0400, David Gauthier wrote:
> I was hoping there was a way to integrate the user/permissions/groups in linux
> with the PG permissions functionality.
You can at least map the OS users to DB roles by using the peer or ident
authentication schemes. This way the users won't h
On Fri, Oct 18, 2019 at 09:14:09PM -0500, Ariadne Conill wrote:
Hello,
On Fri, Oct 18, 2019 at 6:52 PM Stephen Frost wrote:
Greetings,
* Ariadne Conill (aria...@dereferenced.org) wrote:
> On Fri, Oct 18, 2019 at 6:01 PM Adrian Klaver
wrote:
> > https://www.postgresql.org/docs/11/functions-
25 matches
Mail list logo
