pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #15895: pg_dump execution with OpenSSL encryption from Windows Service application
3+ messages / 3 participants
[nested] [flat]
* BUG #15895: pg_dump execution with OpenSSL encryption from Windows Service application
@ 2019-07-05 07:01 PG Bug reporting form <noreply@postgresql.org>
2019-07-05 13:08 ` Re: BUG #15895: pg_dump execution with OpenSSL encryption from Windows Service application Robert Haas <robertmhaas@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: PG Bug reporting form @ 2019-07-05 07:01 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: nagy.ervin.rn@gmail.com
The following bug has been logged on the website:
Bug reference: 15895
Logged by: Ervin Nagy
Email address: nagy.ervin.rn@gmail.com
PostgreSQL version: 10.4
Operating system: Windows 10 -64 /x64
Description:
Hi,
We would like to make some Postgres databases backups from a windows service
application, using OpenSSL app to encrypt those files. To accomplish that we
use a batch file, containing that command lines. If we do it in two steps,
first we make the backup file and after that we want to encrypt it or even
when we include in Postgres "pg_dump" instructions it doesn't work, I
presume because the service app is running as SYSTEM. If I run the same
application as desktop mode it works fine.
Is there any workaround that can help us to do that?
Thank you. Regards.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #15895: pg_dump execution with OpenSSL encryption from Windows Service application
2019-07-05 07:01 BUG #15895: pg_dump execution with OpenSSL encryption from Windows Service application PG Bug reporting form <noreply@postgresql.org>
@ 2019-07-05 13:08 ` Robert Haas <robertmhaas@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Robert Haas @ 2019-07-05 13:08 UTC (permalink / raw)
To: nagy.ervin.rn@gmail.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
On Fri, Jul 5, 2019 at 3:02 AM PG Bug reporting form
<noreply@postgresql.org> wrote:
> We would like to make some Postgres databases backups from a windows service
> application, using OpenSSL app to encrypt those files. To accomplish that we
> use a batch file, containing that command lines. If we do it in two steps,
> first we make the backup file and after that we want to encrypt it or even
> when we include in Postgres "pg_dump" instructions it doesn't work, I
> presume because the service app is running as SYSTEM. If I run the same
> application as desktop mode it works fine.
Hi Ervin,
I have a couple of comments.
1. This doesn't sound like a bug report. There are other mailing lists
for user questions.
2. If you don't actually describe the exact series of steps that you
followed, the chances that anyone else is going to be able to comment
usefully are not good.
3. "it doesn't work" is the textbook example of how not to report a problem.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
^ permalink raw reply [nested|flat] 3+ messages in thread
* [PATCH] Don't open partitions that were detached and dropped
@ 2024-08-13 18:07 Alvaro Herrera <alvherre@alvh.no-ip.org>
0 siblings, 0 replies; 3+ messages in thread
From: Alvaro Herrera @ 2024-08-13 18:07 UTC (permalink / raw)
---
src/backend/optimizer/util/inherit.c | 13 +++++++++++--
1 file changed, 11 insertions(+), 2 deletions(-)
inline patch 1: src/backend/optimizer/util/inherit.c (+11/-2 lines) download inline-1.patch
diff --git a/src/backend/optimizer/util/inherit.c b/src/backend/optimizer/util/inherit.c
index 4797312ae5..c5b906a9d4 100644
--- a/src/backend/optimizer/util/inherit.c
+++ b/src/backend/optimizer/util/inherit.c
@@ -386,8 +386,17 @@ expand_partitioned_rtentry(PlannerInfo *root, RelOptInfo *relinfo,
Index childRTindex;
RelOptInfo *childrelinfo;
- /* Open rel, acquiring required locks */
- childrel = table_open(childOID, lockmode);
+ /*
+ * Open rel, acquiring required locks. If a partition was recently
+ * detached and subsequently dropped, then opening it will fail. In
+ * this case, behave as though the partition had been pruned.
+ */
+ childrel = try_table_open(childOID, lockmode);
+ if (childrel == NULL)
+ {
+ relinfo->live_parts = bms_del_member(relinfo->live_parts, i);
+ continue;
+ }
/*
* Temporary partitions belonging to other sessions should have been
--
2.39.2
end of thread, other threads:[~2024-08-13 18:07 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-07-05 07:01 BUG #15895: pg_dump execution with OpenSSL encryption from Windows Service application PG Bug reporting form <noreply@postgresql.org>
2019-07-05 13:08 ` Robert Haas <robertmhaas@gmail.com>
2024-08-13 18:07 [PATCH] Don't open partitions that were detached and dropped Alvaro Herrera <alvherre@alvh.no-ip.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox