Thank you, Bruce. Actually I mean I am using WAL-G what I am curious about
is that I want to test shipping process automate, and I am looking for the
ideas. But thanks for your help.
Bruce Momjian , 18 Mar 2021 Per, 17:24 tarihinde şunu
yazdı:
> On Thu, Mar 18, 2021 at 05:18:30PM -0400, aslı coka
On 3/18/21 3:39 PM, Gustavo FERREYRA wrote:
Hello, a request, which may be resolved in another way and I did not see it.
When doing a BACKUP plain and using "Include DROP DATABASE statement",
could you add by default "IF EXISTS" ?
https://www.postgresql.org/docs/12/app-pgdump.html
--if-exists
Am 18.03.21 um 17:19 schrieb Laurenz Albe:
> On Thu, 2021-03-18 at 15:39 +0100, basti wrote:
>> I need to as follow:
>>
>> ande
>> Amma
>> Anit
>> Anti
>> Brac
>> Cali
>>
>>
>> I have try ORDER by name COLLATE 'C';
>>
>> but this order as follow:
>>
>> Amma
>> Anit
>> Anti
>> Brac
>> Cali
>
Hello, a request, which may be resolved in another way and I did not see it.
When doing a BACKUP plain and using "Include DROP DATABASE statement",
could you add by default "IF EXISTS" ?
Because when doing a restore, if the database does not exist, it gives an
error and you have to edit the file to
Hi,
I hope I am right here for a question on the wiki site
https://wiki.postgresql.org/wiki/Pg_depend_display .
The views on that web page build dependency information, but do not seem to
take into account function parameters of custom data types - i. e. CREATE
FUNCTION x(myparam mytype) should b
On Thu, Mar 18, 2021 at 05:18:30PM -0400, aslı cokay wrote:
> Hi all,
>
> I'd like to get postgres log files to the cloud but i want this process going
> live i want to automate test process and after that i want it go live.
>
> What i have in my mind is setting archive_mode is on and archiving_
On 3/18/21 2:18 PM, aslı cokay wrote:
Hi all,
I'd like to get postgres log files to the cloud but i want this process
going live i want to automate test process and after that i want it go
live.
What i have in my mind is setting archive_mode is on and
archiving_command with a script. After
Hi all,
I'd like to get postgres log files to the cloud but i want this process
going live i want to automate test process and after that i want it go
live.
What i have in my mind is setting archive_mode is on and archiving_command
with a script. After that i want to execute pgbench to get more W
Hi all,
Is there any way to get for example a table version of 5 minutes ago, or we
should PITR to 5 minutes ago, dump the table and restore with this dump ?
Thanks.
On 3/18/21 6:32 AM, DAVID Nicolas wrote:
Dear PostgreSQL Team,
We are a software editor that historically use PostgreSQL for one of our
product.
We currently use the version 9.6 since many years and now we would like
to update to the last version 13.2.
However, before that, we would like t
On Thu, Mar 18, 2021 at 6:51 AM Tom Dearman wrote:
> Is this a known issue, are they any ways around it, and if it is an
> issue is there a plan to fix it if a fix is possible?
It's not exactly a known issue per se, but I think the problem here is
related to the fact that you have lots of duplica
On Thu, 2021-03-18 at 15:39 +0100, basti wrote:
> I need to as follow:
>
> ande
> Amma
> Anit
> Anti
> Brac
> Cali
>
>
> I have try ORDER by name COLLATE 'C';
>
> but this order as follow:
>
> Amma
> Anit
> Anti
> Brac
> Cali
>
> ande
Create an ICU collation:
CREATE COLLATION inv
or, maybe, just nothing ?
Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com
On Thu, Mar 18, 2021 at 4:44 PM Ron wrote:
> Exactly. "C" collation is the opposite of what he wants.
>
> OP needs something like "de_DE".
>
> On 3/18/21 10:36 AM, Marc Millas wrote:
>
> to me, collate 'C' ask
Exactly. "C" collation is the opposite of what he wants.
OP needs something like "de_DE".
On 3/18/21 10:36 AM, Marc Millas wrote:
to me, collate 'C' ask for the raw ascii order which put caps before
because the hexa coding is lower
did you try any thing else (POSIX is same as 'C')
Marc MILLA
to me, collate 'C' ask for the raw ascii order which put caps before
because the hexa coding is lower
did you try any thing else (POSIX is same as 'C')
Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com
On Thu, Mar 18, 2021 at 4:18 PM basti wrote:
> This does not help in that case.
>
>
This does not help in that case.
On 18.03.21 15:45, Basques, Bob (CI-StPaul) wrote:
Maybe check out using the UPPER/LOWER/INITCAP functions in the order by clause?
Bobb
-Original Message-
From: basti
Sent: Thursday, March 18, 2021 9:40 AM
To: pgsql-gene...@postgresql.org
Subject:
Maybe check out using the UPPER/LOWER/INITCAP functions in the order by clause?
Bobb
> -Original Message-
> From: basti
> Sent: Thursday, March 18, 2021 9:40 AM
> To: pgsql-gene...@postgresql.org
> Subject: postgresql order lowercase before uppercase
>
> Think Before You Click: This
Dear PostgreSQL Team,
We are a software editor that historically use PostgreSQL for one of our
product.
We currently use the version 9.6 since many years and now we would like to
update to the last version 13.2.
However, before that, we would like to check some points regarding the embedded
Hello,
I need to as follow:
ande
Amma
Anit
Anti
Brac
Cali
I have try ORDER by name COLLATE 'C';
but this order as follow:
Amma
Anit
Anti
Brac
Cali
ande
Best Regards
Hi,
We have a partial index on a column of the form:
CREATE TABLE table_p2021q1 (
pk_id BIGINT,
col1 BIGINT NOT NULL,
status character varying(255) NOT NULL,
...other columns
PRIMARY KEY (pk_id)
);
CREATE INDEX table_p2021q1_ix04 ON table_p2021q1 (col1) WHERE status =
'IN_PROGRESS';
(t
On Thu, Mar 18, 2021 at 9:56 AM Luca Ferrari wrote:
>
> What puzzles me is that I'm somehow "locking" the testdb.wa table (by
> inserting a tuple every 20 minutes), so all other tables and databases
> are free to be frozen by an emergency autovacuum. And I was expecting
> the problem to happen due
Dear list,
I ran into an error when running the following snippet of code (I
simplified as much as I could):
CREATE DOMAIN domaintest AS VARCHAR(10) NOT NULL;
CREATE TABLE tabletest (
fieldtest domaintest GENERATED ALWAYS AS ('valuetest') STORED
);
INSERT INTO tabletest DE
Hi all,
I'm doing some experiments on a cluster to see what happens at xid
wraparound, and I'm approaching it. There is no activity in any
database but testdb.
Scenario: I've a procedure that is consuming all xids, while another
connection is inserting a tuple every 20 minutes or so in a table,
jus
23 matches
Mail list logo
