On Wed, 2023-10-11 at 23:20 +0530, Atul Kumar wrote:
> Yes, I meant streamed, I need to log those wal files that are getting streamed
> and replayed on standby servers in error logs of primary as well as standby
> servers.
>
> So that I can cross check that whichever file is streamed has been rep
Hi,
I try to find out some view, select or something what show me the privileges
for the user across the whole postgresql cluster. The username/user is
global for whole cluster not individual database, so I would like to know
the privileges for the user in all databases in the cluster using one
Hi madam/sir,
Our company want to use a database for first time, we select PostgreSQL from a
list of open-source Databases. But at first, we want to be sure about
something. We have some .net assemblies and in your documents, I didn't find
any support for this type of files that is executable i
On Thu, 2023-10-12 at 06:09 +, Sepideh Eidi wrote:
> We have some .net assemblies and in your documents, I didn’t find any support
> for this
> type of files that is executable in DB or not. Would you please tell me that
> .net
> assemblies files are executable in PostgreSQL or not? Or is the
You can use pg_dumpall -g to get user information for the cluster.
Regards,
Priyanka
On Thu, 12 Oct 2023 at 3:46 PM, Jana Mihalidesová
wrote:
> Hi,
>
> I try to find out some view, select or something what show me the
> privileges for the user across the whole postgresql cluster. The
> username
=?utf-8?q?Jana_Mihalidesov=C3=A1?= writes:
> I try to find out some view, select or something what show me the privileges
> for the user across the whole postgresql cluster. The username/user is
> global for whole cluster not individual database, so I would like to know
> the privileges for the u
On Thu, Oct 12, 2023 at 3:42 PM Jana Mihalidesová
wrote:
> I try to find out some view, select or something what show me the
> privileges for the user across the whole postgresql cluster. The
> username/user is global for whole cluster not individual database, so I
> would like to know the privil
11.10.2023, 14:20, "Laurenz Albe" :On Wed, 2023-10-11 at 14:08 +0300, Олег Самойлов wrote: There are two common practice to drop partition from partitioned table: just drop or detach-drop. But simple drop don't work if exist foreign key. Example script attached.That is working as designed. You ca
For Postgresql HA cluster the most popular solution is streaming replication. There is an option how implement this. Web programmer approach is using haproxy+consul+patrony. The "old schoool" is using Pacemaker, all in one bottle and well tested. If you interesting how implement in Pacemaker, you m
Hi Sepideh,
> From: Sepideh Eidi
> Date: Thu, Oct 12, 2023 at 2:35 PM
> Subject: Question About PostgreSQL Extensibility
> To: pgsql-general@lists.postgresql.org
> We have some .net assemblies and in your documents, I didn’t find any support
> for this type of files that is executable in DB or
On Thu, Oct 12, 2023 at 10:09 PM Ilya Kosmodemiansky
wrote:
> Hi Sepideh,
>
> > From: Sepideh Eidi
> > Date: Thu, Oct 12, 2023 at 2:35 PM
> > Subject: Question About PostgreSQL Extensibility
> > To: pgsql-general@lists.postgresql.org <
> pgsql-general@lists.postgresql.org>
>
> > We have some .ne
On Thu, 2023-10-12 at 17:56 +0300, Олег Самойлов wrote:
> 11.10.2023, 14:20, "Laurenz Albe" :
> > On Wed, 2023-10-11 at 14:08 +0300, Олег Самойлов wrote:
> > > There are two common practice to drop partition from partitioned table:
> > > just drop or detach-drop.
> > > But simple drop don't wor
12 matches
Mail list logo
