Hello,
I am taking pg_basebackup of primary db (docker container env.) using the below
command :
pg_basebackup -x -h vmzti -U replication -D
/etc/postgresql/9.5/main/pg_basebkp/basekp1224 -Ft -z -P
Password:
WARNING: skipping special file "./postgresql.conf"
WARNING: skipping special file
Samuel Teixeira Santos schrieb am 20.12.2019 um 16:15:
BigSQL still allow to install Postgres and others resources as like a
portable install.
But today, it's only offer your tool (pgc) for newer Postgresql
versions.
I would like to install as portable option because it's more easy to
config
On 2019-12-22 16:07, Jeff Ross wrote:
On 2019-12-22 15:27, Andrei Pozolotin wrote:
Hello.
Problem:
1. any attempt to define python function as an event_trigger, i.e.:
CREATE FUNCTION public.verify()
RETURNS event_trigger
LANGUAGE 'plpython3u'
AS $$ print("hello-kitty") $$;
2. fails with
> From: Adrian Klaver
> Sent: Sunday, December 22, 2019 10:35 AM
.
> Alright this is the part where I got confused. I think what is going on is:
>1) The immediate change is going to be to Access 2016 on Windows 10 64
keeping the data in Access files(.accdb)
> 2) The long term plan is to
On 12/22/19 11:59 AM, Boylan, Ross wrote:
From: Adrian Klaver
> Sent: Sunday, December 22, 2019 10:35 AM
.
Alright this is the part where I got confused. I think what is going on is:
1) The immediate change is going to be to Access 2016 on Windows 10 64
keeping the data in Access
On 12/22/19 1:56 AM, Daulat Ram wrote:
Hello,
I am taking pg_basebackup of primary db (docker container env.) using
the below command :
pg_basebackup -x -h vmzti -U replication -D
/etc/postgresql/9.5/main/pg_basebkp/basekp1224 -Ft -z -P
Password:
WARNING: skipping special file
On 12/21/19 6:40 PM, Boylan, Ross wrote:
From: Adrian Klaver
Sent: Saturday, December 21, 2019 3:37 PM
This might be easier to figure out if you outline what is going on:
Since I seem to have gone on in my responses, let me do one-line answers before
the fuller ones.
1) The purpose of
Hello.
Problem:
1. any attempt to define python function as an event_trigger, i.e.:
CREATE FUNCTION public.verify()
RETURNS event_trigger
LANGUAGE 'plpython3u'
AS $$ print("hello-kitty") $$;
2. fails with message:
ERROR: trigger functions can only be called as triggers
SQL state: 0A000
On 2019-12-22 15:27, Andrei Pozolotin wrote:
Hello.
Problem:
1. any attempt to define python function as an event_trigger, i.e.:
CREATE FUNCTION public.verify()
RETURNS event_trigger
LANGUAGE 'plpython3u'
AS $$ print("hello-kitty") $$;
2. fails with message:
ERROR: trigger functions can
Andrei Pozolotin writes:
> 1. any attempt to define python function as an event_trigger, i.e.:
AFAICS, there's not really any event trigger support in plpython.
That feature has only been built out in the other three PLs.
Somebody oughta fix this sometime, I guess, but it evidently hasn't
been
Jeff, hi:
1. my concern is global "event_trigger" for DDL, not per-table "trigger"
for DML
2. regardless - thank you for the link, I found it helpful
3. Tom Lane says event_trigger is just not implemented in plpython
Andrei.
On 2019-12-22 17:20, Jeff Ross wrote:
On 2019-12-22 16:07, Jeff
1. Timelines
> The long term solution is?
I just meant I'm hoping to switch to Postgres soonish.
> So at some point you will switch the link from being Access native to a
ODBC DSN pointing at a Postgres database, correct?
The switch will be to ODBC but no DSN. You can specify the connection
Tom, hi:
1. actual use case has to do with:
BUG #16177: pg_event_trigger_ddl_commands() returns empty set for
ddl_command_start and "drop table"
https://www.postgresql.org/message-id/16177-053a34714817c3e1%40postgresql.org
2. I was merely hoping to re-implement pg_event_trigger_ddl_commands
Well.. it seems I have to rethink about my application design. Anyway,
thank you all for your insights and suggestions.
On 12/18/2019 10:46 PM, Justin wrote:
I agree completely,
I do not think Postgresql is a good fit for Shalini based on the
conversation so far
tracking Concurrency is
thanks Adrian, what about the
postmaster.opts file, this file was also skipped in backup.
We have single cluster running on the VM.
Thanks.
On 22-Dec-2019 11:19 PM, Adrian Klaver wrote:
On 12/22/19 1:56 AM, Daulat Ram wrote:
> Hello,
>
> I am taking pg_basebackup of primary db (docker
15 matches
Mail list logo