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
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
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
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
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
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
=?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
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
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
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
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
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
12 matches
Mail list logo
