I missed to mentioned in the last.
On Sat, Oct 26, 2024, 10:51 PM Adrian Klaver
wrote:
> On 10/26/24 10:06, Asad Ali wrote:
> >
> > In the typical upgrade scenario, replication flows from the lower
> > (older) version to the higher (newer) version. Here, the source is the
&
(PostgreSQL 14) is possible but unconventional and not usually done for
upgrades.
Best Regards,
Asad Ali
On Sat, Oct 26, 2024, 9:10 PM Adrian Klaver
wrote:
> On 10/25/24 23:02, Asad Ali wrote:
> > Hi Durgamahesh,
> >
> > Yes, you can replicate a PostgreSQL 16 database t
Hi Durgamahesh,
Yes, you can replicate a PostgreSQL 16 database to PostgreSQL 14 using
built-in logical replication. PostgreSQL's built-in logical replication
allows for replicating data between different versions of PostgreSQL,
provided the source version is higher than or equal to the target ver
ns or operations on your custom dates (BC/AD), you
can create user-defined functions in PostgreSQL for adding, subtracting, or
comparing dates.
Best Regards,
Asad Ali
On Thu, Oct 17, 2024 at 5:36 AM Tom Lane wrote:
> David Rowley writes:
> > It's by no means a trivial thing to do, bu
assistance!
Best regards,
Asad Ali
On Thu, Oct 17, 2024 at 12:38 AM Andy Hartman
wrote:
> I am very new to Postgres and have always worked in the mssql world. I'm
> looking for suggestions on DB backups. I currently have a DB used to store
> Historical information that has images it
lly or include it in your
.psqlrc file for automatic loading with each session.
I hope this helps!
Best regards,
Asad Ali
On Mon, Sep 23, 2024 at 2:31 PM Dominique Devienne
wrote:
> Hi. I've successfully customized my psql PROMPT1,
> using %n for session_user, but I'd like to see
&g
I am just trying to revive this question, I am still hoping to get an
answer
how can we verify the postgresql download on windows ?
Thanks
Ali
On Wed, Feb 8, 2023 at 2:03 PM Ali M. wrote:
> Hi the Postgresql binaries and installer are provided by EDB
> How can i verify the do
Hi the Postgresql binaries and installer are provided by EDB
How can i verify the download
Usually other projects provide a SHA256 hash list to verify the downloads
EDB doesnt seem to provide that, so how else can i verify the download
Thanks
Ali
Hello,
I'm seeing \dt used for "show tables", \l used for "show databases". Why
not standart SQL syntax words? Why specified PostgreSQL commands?
I can't figure out that.
Ali
I can't understand functions in md5.h, these are seemingly little bit
weird. Such as:
/* Utilities common to all the MD5 implementations,
as of md5_common.c */
extern bool pg_md5_hash(const void *buff, size_t len, char *hexsum);
extern bool pg_md5_binary(const voi
Ok, thanks
--
Sent from Mail.ru app for Android Wednesday, 24 November 2021, 11:28pm +03:00
from Godfrin, Philippe E philippe.godf...@nov.com :
>The notion of COPY blocks and asynchronously is very interesting
>
>From: Gavin Roy < gav...@aweber.com>
>Sent: Wednesday, November 24, 2021 1:50 PM
Hi,
Is there any way to continue logical replication (either in-built or using
pglogical) between a promoted replica and existing subscribers without data
loss?
I could find some discussions about fail-over slots and other mechanisms
for addressing this as part of PostgreSQL 9.6 release. But I am
> 1) What side are you talking about, the parent of the record or the
> children?
the children. only one level of depth is fine.
> 2) What procedural language are you using?
PL/pgSQL
As I understand, I need to loop over all columns in the "NEW" record, find out
if the column is a foreign key
Hello.
In PostgreSQL 10.10, I have created a trigger function that converts the `NEW`
row to a JSON object using `to_jsonb(NEW)`. But now I need to include the
records on the other side of the foreign keys in `NEW` record in the JSON
object in a nested fashion.
What is the best and most gene
-03-22 12:17:57.869 +03 [31760] LOG: invalid record length at
0/CD0: wanted 24, got 0*
2019-03-22 12:17:57.870 +03 [31757] LOG: database system is ready to
accept read only connections
2019-03-22 12:17:57.877 +03 [31764] LOG: started streaming WAL from
primary at 0/C00 on timeline 1
Ali
Hello Friends,
I wanna to create Streaming Replication with 2 Node(1 Master, 1 Slave)
After i create streaming replication, streaming is okay , and than when i
add new record on master , than on slave records occurs autamaticly.
but When i look service status on slave server i "see startup reco
just tell me the site , i dont have time to waste on shitty things , i will
program a spammer to send email to this list
Bye
From: James Keener
Sent: Wednesday, June 20, 2018 3:16 AM
To: Asif Ali; pgsql-general@lists.postgresql.org; Alban Hertroys; Ravi Krishna
just tell me the site , i dont have time to waste on shitty things , i will
program a spammer to send email to this list
Bye
From: James Keener
Sent: Wednesday, June 20, 2018 3:16 AM
To: Asif Ali; pgsql-general@lists.postgresql.org; Alban Hertroys; Ravi Krishna
@lists.postgresql.org; Asif Ali; Alban Hertroys; Ravi Krishna
Cc: PG mailing List
Subject: Re: Load data from a csv file without using COPY
Seriously, stop spamming the list and stop cursing and acting like a petulant
child. Go to the site and unsubscribe or use a mail client that understands the
standard
how the fuck i unsubscribe to this mailing list , i get more than 100 emails a
day
Bye
From: Rob Sargent
Sent: Wednesday, June 20, 2018 12:54 AM
To: Łukasz Jarych
Cc: pgsql-gene...@postgresql.org
Subject: Re: Run Stored procedure - function from VBA
On 06/18/
how the fuck i unsubscribe to this mailing list , i get more than 100 emails a
day
Bye
From: Alban Hertroys
Sent: Wednesday, June 20, 2018 2:05 AM
To: Hellmuth Vargas
Cc: pgsql-gene...@postgresql.org
Subject: Re: Is postorder tree traversal possible with recursi
how the fuck i unsubscribe to this mailing list , i get more than 100 emails a
day
Bye
From: Alban Hertroys
Sent: Wednesday, June 20, 2018 2:10 AM
To: Ravi Krishna
Cc: PG mailing List
Subject: Re: Load data from a csv file without using COPY
> On 19 Jun 2018,
how the fuck i unsubscribe to this mailing list , i get more than 100 emails a
day
Bye
From: Paul Jungwirth
Sent: Wednesday, June 20, 2018 2:31 AM
To: pgsql-general@lists.postgresql.org
Subject: Re: Is postorder tree traversal possible with recursive CTE's?
On
how the fuck i unsubscribe to this mailing list , i get more than 100 emails a
day
From: Tim Cross
Sent: Wednesday, June 20, 2018 2:59 AM
To: Ravi Krishna
Cc: PG mailing List
Subject: Re: Load data from a csv file without using COPY
Ravi Krishna writes:
> I
24 matches
Mail list logo
